H69UNtblNBNpha2dtB1Odn8qYp1Qk5NK2gi7yfceofo9N

/home/ymswebso/crms/application/migrations/

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Migration_Version_104 extends CI_Migration
{
    function __construct()
    {
        parent::__construct();
    }

public function up()
    {
        add_option('last_cron_run','');
        add_option('show_sale_agent_on_invoices',1);
        add_option('show_sale_agent_on_estimates',1);
        add_option('predefined_terms_invoice','');
        add_option('predefined_terms_estimate','');
        add_option('predefined_clientnote_invoice','');
        add_option('predefined_clientnote_estimate','');
        add_option('custom_pdf_logo_image_url','');
        add_option('last_recurring_expenses_cron',time());
        add_option('number_padding_invoice_and_estimate',6);

// Add contract mime type
        $this->db->query("ALTER TABLE `tblcontractattachments` ADD `filetype` VARCHAR(50) NULL AFTER `file_name`;");

// Add ticket attachment mime type
        $this->db->query("ALTER TABLE `tblticketattachments` ADD `filetype` VARCHAR(50) NULL AFTER `filename`;");
        // Invoice item long description
        $this->db->query("ALTER TABLE `tblinvoiceitemslist` ADD `long_description` TEXT NULL AFTER `description`;");

// Add custom fields show on pdf for customers/invoice/estimate etc..
        $this->db->query("ALTER TABLE  `tblcustomfields` ADD  `show_on_pdf` INT NULL DEFAULT  '0' AFTER  `active` ;");

$this->db->query("ALTER TABLE `tblcontracts` CHANGE `dateadded` `dateadded` DATETIME NOT NULL;");
        $this->db->query("ALTER TABLE `tblcontracts` ADD `contract_value` DECIMAL(11,2) NULL AFTER `isexpirynotified`;");
        $this->db->query("ALTER TABLE `tblcontracts` ADD `trash` BOOLEAN NULL DEFAULT FALSE AFTER `contract_value`;");
        // Add date converted to leads
        $this->db->query("ALTER TABLE `tblleads` ADD `date_converted` DATETIME NULL AFTER `notes`;");

$this->db->query("CREATE TABLE IF NOT EXISTS `tblcontractrenewals` (
                          `id` int(11) NOT NULL AUTO_INCREMENT,
                          `contractid` int(11) NOT NULL,
                          `old_start_date` date NOT NULL,
                          `new_start_date` date NOT NULL,
                          `old_end_date` date NOT NULL,
                          `new_end_date` date NOT NULL,
                          `old_value` decimal(11,2) DEFAULT NULL,
                          `new_value` decimal(11,2) DEFAULT NULL,
                          `date_renewed` datetime NOT NULL,
                          `renewed_by` int(11) NOT NULL,
                          PRIMARY KEY (`id`)
                          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

$this->db->query("ALTER TABLE `tblinvoices` ADD `sale_agent` INT NOT NULL DEFAULT '0' AFTER `terms`;");
        $this->db->query("ALTER TABLE `tblestimates` ADD `sale_agent` INT NOT NULL DEFAULT '0' AFTER `reference_no`;");

// Add permission goals
        $this->db->query("INSERT INTO `tblpermissions` (`permissionid`, `name`, `shortname`) VALUES (NULL, 'Manage Goals', 'manageGoals');");

$this->db->query("INSERT INTO `tblpermissions` (`permissionid`, `name`, `shortname`) VALUES (NULL, 'Manage Expenses', 'manageExpenses');");

if(!is_dir(INVOICE_ATTACHMENTS_FOLDER)){
            mkdir(INVOICE_ATTACHMENTS_FOLDER, 0755);
            fopen(INVOICE_ATTACHMENTS_FOLDER . '.htaccess', 'w');
            $fp = fopen(INVOICE_ATTACHMENTS_FOLDER.'.htaccess','a+');
            if($fp)
            {
                fwrite($fp,'Order Deny,Allow'.PHP_EOL.'Deny from all');
                fclose($fp);
            }
        }

if(!is_dir(EXPENSE_ATTACHMENTS_FOLDER)){
          mkdir(EXPENSE_ATTACHMENTS_FOLDER, 0755);
          fopen(EXPENSE_ATTACHMENTS_FOLDER . '.htaccess', 'w');
          $fp = fopen(EXPENSE_ATTACHMENTS_FOLDER.'.htaccess','a+');
          if($fp)
          {
            fwrite($fp,'Order Deny,Allow'.PHP_EOL.'Deny from all');
            fclose($fp);
          }
        }

if(!is_dir(LEAD_ATTACHMENTS_FOLDER)){
          mkdir(LEAD_ATTACHMENTS_FOLDER, 0755);
          fopen(LEAD_ATTACHMENTS_FOLDER . '.htaccess', 'w');
          $fp = fopen(LEAD_ATTACHMENTS_FOLDER.'.htaccess','a+');
          if($fp)
          {
            fwrite($fp,'Order Deny,Allow'.PHP_EOL.'Deny from all');
            fclose($fp);
          }
        }

// Add expense category id column to invoiec items
        $this->db->query("ALTER TABLE `tblinvoiceitems` ADD `expenseid` INT NOT NULL DEFAULT '0' AFTER `itemid`;");
        // Add taxes decimal
        $this->db->query("ALTER TABLE `tbltaxes` CHANGE `taxrate` `taxrate` DECIMAL(11,2) NOT NULL;");
        // Add notifications link
        $this->db->query("ALTER TABLE `tblnotifications` ADD `link` MEDIUMTEXT NULL AFTER `fromcompany`;");

// Remove the translator
        if(is_dir(APPPATH . 'views/admin/translator')){
          delete_dir(APPPATH . 'views/admin/translator');
        }
        if(is_file(APPPATH . 'controllers/admin/Translator.php')){
          unlink(APPPATH . 'controllers/admin/Translator.php');
        }
        if(is_file(APPPATH . 'controllers/admin/._translator.php')){
          unlink(APPPATH . 'controllers/admin/._translator.php');
        }
        if(is_file(APPPATH . 'config/translator.php')){
          unlink(APPPATH . 'config/translator.php');
        }

if(is_file(APPPATH . 'controllers/Reset_demo.php')){
          unlink(APPPATH . 'controllers/Reset_demo.php');
        }

// Add invoice attachments table
        $this->db->query("CREATE TABLE IF NOT EXISTS `tblinvoiceattachments` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `invoiceid` int(11) NOT NULL,
            `file_name` varchar(50) NOT NULL,
            `original_file_name` mediumtext NOT NULL,
            `filetype` varchar(25) NOT NULL,
            `datecreated` datetime NOT NULL,
            PRIMARY KEY (`id`)
          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
        // Add expenses main table
        $this->db->query("CREATE TABLE IF NOT EXISTS `tblexpenses` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `category` int(11) NOT NULL,
            `amount` decimal(11,2) NOT NULL,
            `tax` int(11) DEFAULT NULL,
            `reference_no` varchar(100) DEFAULT NULL,
            `note` text,
            `attachment` mediumtext NOT NULL,
            `filetype` varchar(50) DEFAULT NULL,
            `clientid` int(11) NOT NULL,
            `billable` int(11) DEFAULT '0',
            `invoiceid` int(11) DEFAULT NULL,
            `paymentmode` int(11) DEFAULT NULL,
            `date` date NOT NULL,
            `recurring_type` varchar(10) DEFAULT NULL,
            `repeat_every` int(11) DEFAULT NULL,
            `recurring` int(11) NOT NULL DEFAULT '0',
            `custom_recurring` int(11) NOT NULL DEFAULT '0',
            `last_recurring_date` date DEFAULT NULL,
            `create_invoice_billable` tinyint(1) DEFAULT NULL,
            `send_invoice_to_customer` tinyint(1) NOT NULL,
            `recurring_from` int(11) DEFAULT NULL,
            `dateadded` datetime NOT NULL,
            `addedfrom` int(11) NOT NULL,
            PRIMARY KEY (`id`)
          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

// Add expenses categories table
        $this->db->query("CREATE TABLE IF NOT EXISTS `tblexpensescategories` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `name` varchar(300) NOT NULL,
            `description` text,
            PRIMARY KEY (`id`)
          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

// Add lead attachments table
        $this->db->query("CREATE TABLE IF NOT EXISTS `tblleadattachments` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `leadid` int(11) NOT NULL,
            `file_name` mediumtext NOT NULL,
            `filetype` varchar(50) DEFAULT NULL,
            `original_file_name` mediumtext NOT NULL,
            `addedfrom` int(11) NOT NULL,
            `dateadded` datetime NOT NULL,
            PRIMARY KEY (`id`)
          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

// Add goals tracking table
        $this->db->query("CREATE TABLE IF NOT EXISTS `tblgoals` (
            `id` int(11) NOT NULL AUTO_INCREMENT,
            `subject` varchar(400) NOT NULL,
            `description` text NOT NULL,
            `start_date` date NOT NULL,
            `end_date` date NOT NULL,
            `goal_type` int(11) NOT NULL,
            `contract_type` int(11) NOT NULL DEFAULT '0',
            `achievement` int(11) NOT NULL,
            `addedfrom` int(11) NOT NULL,
            `assigned` int(11) DEFAULT NULL COMMENT 'test',
            `notify_when_fail` tinyint(1) NOT NULL DEFAULT '1',
            `notify_when_achieve` tinyint(1) NOT NULL DEFAULT '1',
            `notified` int(11) NOT NULL DEFAULT '0',
            PRIMARY KEY (`id`)
          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

// Set description for contracts ability to be null
        $this->db->query("ALTER TABLE `tblcontracts` CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;");

}
}

Nama File / Folder	Size	Action
Wp	--	NONE
101_version_101.php	3.733KB	Hapus Edit Rename
102_version_102.php	6.224KB	Hapus Edit Rename
104_version_104.php	9.096KB	Hapus Edit Rename
105_version_105.php	5.675KB	Hapus Edit Rename
109_version_109.php	14.297KB	Hapus Edit Rename
111_version_111.php	9.57KB	Hapus Edit Rename
112_version_112.php	0.739KB	Hapus Edit Rename
115_version_115.php	0.271KB	Hapus Edit Rename
117_version_117.php	10.891KB	Hapus Edit Rename
118_version_118.php	12.875KB	Hapus Edit Rename
119_version_119.php	1.602KB	Hapus Edit Rename
121_version_121.php	1.712KB	Hapus Edit Rename
122_version_122.php	2.77KB	Hapus Edit Rename
123_version_123.php	0.281KB	Hapus Edit Rename
125_version_125.php	0.281KB	Hapus Edit Rename
127_version_127.php	23.343KB	Hapus Edit Rename
130_version_130.php	0.897KB	Hapus Edit Rename
132_version_132.php	0.294KB	Hapus Edit Rename
134_version_134.php	0.294KB	Hapus Edit Rename
136_version_136.php	0.294KB	Hapus Edit Rename
137_version_137.php	0.294KB	Hapus Edit Rename
138_version_138.php	0.294KB	Hapus Edit Rename
141_version_141.php	0.842KB	Hapus Edit Rename
142_version_142.php	0.842KB	Hapus Edit Rename
144_version_144.php	0.291KB	Hapus Edit Rename
148_version_148.php	0.291KB	Hapus Edit Rename
150_version_150.php	1.153KB	Hapus Edit Rename
153_version_153.php	0.291KB	Hapus Edit Rename
155_version_155.php	0.291KB	Hapus Edit Rename
156_version_156.php	0.291KB	Hapus Edit Rename
157_version_157.php	0.291KB	Hapus Edit Rename
160_version_160.php	2.27KB	Hapus Edit Rename
162_version_162.php	2.517KB	Hapus Edit Rename
165_version_165.php	0.282KB	Hapus Edit Rename
166_version_166.php	0.282KB	Hapus Edit Rename
167_version_167.php	0.282KB	Hapus Edit Rename
168_version_168.php	0.282KB	Hapus Edit Rename
172_version_172.php	0.283KB	Hapus Edit Rename
175_version_175.php	0.283KB	Hapus Edit Rename
177_version_177.php	0.283KB	Hapus Edit Rename
180_version_180.php	5.299KB	Hapus Edit Rename
181_version_181.php	0.787KB	Hapus Edit Rename
183_version_183.php	0.264KB	Hapus Edit Rename
184_version_184.php	0.264KB	Hapus Edit Rename
188_version_188.php	0.264KB	Hapus Edit Rename
189_version_189.php	0.264KB	Hapus Edit Rename
191_version_191.php	0.854KB	Hapus Edit Rename
192_version_192.php	3.287KB	Hapus Edit Rename
196_version_196.php	1.526KB	Hapus Edit Rename
198_version_198.php	2.598KB	Hapus Edit Rename
199_version_199.php	0.886KB	Hapus Edit Rename
200_version_200.php	26.133KB	Hapus Edit Rename
202_version_202.php	0.235KB	Hapus Edit Rename
203_version_203.php	0.235KB	Hapus Edit Rename
207_version_207.php	0.235KB	Hapus Edit Rename
210_version_210.php	2.168KB	Hapus Edit Rename
211_version_211.php	0.891KB	Hapus Edit Rename
213_version_213.php	0.291KB	Hapus Edit Rename
214_version_214.php	0.291KB	Hapus Edit Rename
215_version_215.php	0.291KB	Hapus Edit Rename
216_version_216.php	0.291KB	Hapus Edit Rename
218_version_218.php	0.291KB	Hapus Edit Rename
219_version_219.php	0.291KB	Hapus Edit Rename
221_version_221.php	0.94KB	Hapus Edit Rename
222_version_222.php	0.235KB	Hapus Edit Rename
225_version_225.php	0.291KB	Hapus Edit Rename
226_version_226.php	0.291KB	Hapus Edit Rename
229_version_229.php	0.291KB	Hapus Edit Rename
230_version_230.php	6.406KB	Hapus Edit Rename
237_version_237.php	0.235KB	Hapus Edit Rename
238_version_238.php	0.235KB	Hapus Edit Rename
241_version_241.php	1.335KB	Hapus Edit Rename
242_version_242.php	0.234KB	Hapus Edit Rename
248_version_248.php	0.234KB	Hapus Edit Rename
251_version_251.php	0.234KB	Hapus Edit Rename
253_version_253.php	0.234KB	Hapus Edit Rename
254_version_254.php	0.234KB	Hapus Edit Rename
255_version_255.php	0.234KB	Hapus Edit Rename
257_version_257.php	0.234KB	Hapus Edit Rename
259_version_259.php	0.234KB	Hapus Edit Rename
261_version_261.php	0.291KB	Hapus Edit Rename
262_version_262.php	0.291KB	Hapus Edit Rename
263_version_263.php	0.291KB	Hapus Edit Rename
264_version_264.php	0.291KB	Hapus Edit Rename
268_version_268.php	0.291KB	Hapus Edit Rename
269_version_269.php	0.291KB	Hapus Edit Rename
270_version_270.php	1.074KB	Hapus Edit Rename
271_version_271.php	3.423KB	Hapus Edit Rename
272_version_272.php	0.234KB	Hapus Edit Rename
273_version_273.php	1.81KB	Hapus Edit Rename
274_version_274.php	0.158KB	Hapus Edit Rename
276_version_276.php	0.158KB	Hapus Edit Rename
277_version_277.php	0.158KB	Hapus Edit Rename
281_version_281.php	0.158KB	Hapus Edit Rename
283_version_283.php	1.589KB	Hapus Edit Rename
285_version_285.php	0.168KB	Hapus Edit Rename
286_version_286.php	0.168KB	Hapus Edit Rename
287_version_287.php	0.168KB	Hapus Edit Rename
288_version_288.php	0.168KB	Hapus Edit Rename
293_version_293.php	0.168KB	Hapus Edit Rename
296_version_296.php	0.166KB	Hapus Edit Rename
297_version_297.php	0.166KB	Hapus Edit Rename
298_version_298.php	0.166KB	Hapus Edit Rename
299_version_299.php	0.166KB	Hapus Edit Rename
302_version_302.php	0.166KB	Hapus Edit Rename
303_version_303.php	0.166KB	Hapus Edit Rename
304_version_304.php	0.166KB	Hapus Edit Rename
index.html	0.128KB	Hapus Edit Rename