H69UNtblNBNpha2dtB1Odn8qYp1Qk5NK2gi7yfceofo9N

/home/ymswebso/crms/application/migrations/

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

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

public function up()
    {
        // Add the invoice discount fields
        $this->db->query("ALTER TABLE `tblinvoices` ADD `discount_percent` INT NOT NULL DEFAULT '0' AFTER `token`, ADD `discount_type` VARCHAR(30) NOT NULL AFTER `discount_percent`;");
        $this->db->query("ALTER TABLE `tblinvoices` ADD `discount_total` DECIMAL(11,2) NULL DEFAULT '0' AFTER `discount_percent`;");

// Add RTL option
        add_option('rtl_support_admin', 0);
        add_option('rtl_support_client', 0);
        add_option('allow_payment_amount_to_be_modified', 1);
        add_option('survey_send_emails_per_cron_run', 250);
        add_option('delete_only_on_last_invoice', 1);
        add_option('last_cron_run', '');
        add_option('last_recurring_invoices_cron', '');

// Estimates - new feature
        $this->db->query("CREATE TABLE IF NOT EXISTS `tblestimates` (
                    `id` int(11) NOT NULL AUTO_INCREMENT,
                    `sent` tinyint(1) NOT NULL DEFAULT '0',
                    `datesend` datetime DEFAULT NULL,
                    `clientid` int(11) NOT NULL,
                    `number` int(11) NOT NULL,
                    `year` int(11) NOT NULL,
                    `datecreated` datetime NOT NULL,
                    `date` date NOT NULL,
                    `expirydate` date DEFAULT NULL,
                    `currency` decimal(11,2) NOT NULL,
                    `subtotal` decimal(11,2) NOT NULL,
                    `total` decimal(11,2) NOT NULL,
                    `adjustment` decimal(11,2) DEFAULT NULL,
                    `addedfrom` int(11) NOT NULL,
                    `status` int(11) NOT NULL DEFAULT '1',
                    `clientnote` text,
                    `adminnote` text,
                    `discount_percent` int(11) DEFAULT NULL,
                    `discount_total` int(11) DEFAULT NULL,
                    `discount_type` int(11) DEFAULT NULL,
                    `invoiceid` int(11) DEFAULT NULL,
                    `invoiced_date` datetime DEFAULT NULL,
                    `terms` text,
                    `reference_no` varchar(100) DEFAULT NULL,
                    PRIMARY KEY (`id`)
                  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

$this->db->query("UPDATE `tbloptions` SET `name` = 'decimal_separator' WHERE `tbloptions`.`name` = 'invoice_decimal_separator';");
        $this->db->query("UPDATE `tbloptions` SET `name` = 'thousand_separator' WHERE `tbloptions`.`name` = 'invoice_thousand_separator';");
        $this->db->query("UPDATE `tbloptions` SET `name` = 'currency_placement' WHERE `tbloptions`.`name` = 'invoice_currency_placement';");

// Add options for estimates
        add_option('delete_only_on_last_estimate', 1);
        add_option('estimate_prefix', 'EST-');
        add_option('next_estimate_number', 1);
        add_option('estimate_number_decrement_on_delete', 1);
        add_option('estimate_number_format', 1);
        add_option('estimate_year', date('Y'));
        add_option('estimate_auto_convert_to_invoice_on_client_accept', 1);
        add_option('exclude_estimate_from_client_area_with_draft_status', 1);

$this->db->query("CREATE TABLE IF NOT EXISTS `tblestimateitems` (
                    `id` int(11) NOT NULL AUTO_INCREMENT,
                    `estimateid` int(11) NOT NULL,
                    `itemid` int(11) NOT NULL,
                    `qty` int(11) NOT NULL,
                    PRIMARY KEY (`id`)
                    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

$this->db->query("CREATE TABLE IF NOT EXISTS `tblestimateactivity` (
                    `id` int(11) NOT NULL AUTO_INCREMENT,
                    `estimateid` int(11) NOT NULL,
                    `description` text NOT NULL,
                    `staffid` varchar(11) DEFAULT NULL,
                    `date` datetime NOT NULL,
                    PRIMARY KEY (`id`)
                    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

// add terms to invoices
        $this->db->query('ALTER TABLE `tblinvoices` ADD `terms` TEXT NULL AFTER `last_recurring_date`;');
        // add translator permission
        $this->db->query("INSERT INTO `tblpermissions` (`permissionid`, `name`, `shortname`) VALUES (NULL, 'Translate', 'isTranslator');");

// New feature admin client notifications
        $this->db->query('CREATE TABLE IF NOT EXISTS `tbladminclientreminders` (
                      `id` int(11) NOT NULL AUTO_INCREMENT,
                      `description` text,
                      `date` date NOT NULL,
                      `isnotified` int(11) NOT NULL DEFAULT "0",
                      `clientid` int(11) NOT NULL,
                      `staff` int(11) NOT NULL,
                      `notify_by_email` int(11) NOT NULL DEFAULT "1",
                      `creator` int(11) NOT NULL,
                      PRIMARY KEY (`id`)
                    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');

// Add 3 new email templates
 $this->db->query("INSERT INTO `tblemailtemplates` (`emailtemplateid`, `type`, `slug`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
 (10, 'estimate', 'estimate-send-to-client', 'When sending estimate to client', '{estimate_number} - {companyname}', 'Dear {client_firstname}&nbsp;{client_lastname} Find the estimate with number {estimate_number} on attach. This estimate&nbsp;is with status:&nbsp;{estimate_status} We look forward to doing more business with you. Best Regards\r\n{email_signature}', 'Company', 'company@test.com', 0, 1, 0),
 (11, 'estimate', 'estimate-already-send', 'Estimate Already Send to Client', 'On your command here is the estimate', 'On your command here is the estimate you asked for. {estimate_number} {email_signature}', 'Company', 'sales@test.com', 0, 1, 0),
 (12, 'ticket', 'ticket-reply-to-admin', 'Ticket Reply (To admin)', 'New Ticket Reply', '{signature}', 'Company', 'info@test.com', 0, 1, 0);");

}

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
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