H69UNtblNBNpha2dtB1Odn8qYp1Qk5NK2gi7yfceofo9N

/home/ymswebso/crms/application/migrations/

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

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

public function up()
    {
        if(file_exists(FCPATH.'assets/js/sales-reports.js')){
            @unlink(FCPATH.'assets/js/sales-reports.js');
        }
        $this->db->query("ALTER TABLE `tblnotifications` ADD `additional_data` INT NULL AFTER `link`;");
        $this->db->query("ALTER TABLE `tblnotifications` CHANGE `additional_data` `additional_data` VARCHAR(600) NULL DEFAULT NULL;");
        $this->db->query("ALTER TABLE `tblinvoiceactivity` ADD `additional_data` VARCHAR(600) NULL AFTER `description`;");
        $this->db->query("ALTER TABLE `tblestimateactivity` ADD `additional_data` VARCHAR(600) NULL AFTER `description`;");
        $this->db->query("ALTER TABLE `tblleadactivitylog` ADD `additional_data` VARCHAR(600) NULL AFTER `description`;");

$this->db->query("CREATE TABLE IF NOT EXISTS `tblnotes` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `rel_id` int(11) NOT NULL,
          `rel_type` varchar(20) NOT NULL,
          `description` text,
          `addedfrom` int(11) NOT NULL,
          `dateadded` datetime NOT NULL,
          PRIMARY KEY (`id`)
          ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

$this->db->query("CREATE TABLE IF NOT EXISTS `tblitemsrelated` (
          `id` int(11) NOT NULL AUTO_INCREMENT,
          `rel_id` int(11) NOT NULL,
          `rel_type` varchar(30) NOT NULL,
          `item_id` int(11) NOT NULL,
          PRIMARY KEY (`id`)
          ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1");

$estimate_notes = $this->db->get(db_prefix().'estimatenotes')->result_array();
        foreach ($estimate_notes as $note) {
            $data                = array();
            $data['rel_type']    = 'estimate';
            $data['rel_id']      = $note['estimate_id'];
            $data['addedfrom']   = $note['staffid'];
            $data['description'] = $note['description'];
            $data['dateadded']   = $note['dateadded'];
            $this->db->insert(db_prefix().'notes', $data);
        }

$this->db->query("DROP TABLE tblestimatenotes");

$lead_notes = $this->db->get(db_prefix().'leadnotes')->result_array();
        foreach ($lead_notes as $note) {
            $data                = array();
            $data['rel_type']    = 'lead';
            $data['rel_id']      = $note['leadid'];
            $data['addedfrom']   = $note['staffid'];
            $data['description'] = $note['description'];
            $data['dateadded']   = $note['dateadded'];
            $this->db->insert(db_prefix().'notes', $data);
        }

$this->db->query("DROP TABLE tblleadnotes");

$customer_staff_notes = $this->db->get(db_prefix().'useradminnotes')->result_array();
        foreach ($customer_staff_notes as $note) {
            $data = array();
            if ($note['staff'] == 1) {
                $data['rel_type'] = 'staff';
            } else {
                $data['rel_type'] = 'customer';
            }
            $data['rel_id']      = $note['userid'];
            $data['addedfrom']   = $note['addedfrom'];
            $data['description'] = $note['description'];
            $data['dateadded']   = $note['dateadded'];
            $this->db->insert(db_prefix().'notes', $data);
        }

$this->db->query("DROP TABLE tbluseradminnotes");

$ticket_notes = $this->db->get(db_prefix().'ticketnotes')->result_array();
        foreach ($ticket_notes as $note) {
            $data                = array();
            $data['rel_type']    = 'ticket';
            $data['rel_id']      = $note['ticketid'];
            $data['addedfrom']   = $note['admin'];
            $data['description'] = $note['note'];
            $data['dateadded']   = $note['date'];
            $this->db->insert(db_prefix().'notes', $data);
        }

$this->db->query("DROP TABLE tblticketnotes");

add_option('auto_stop_tasks_timers_on_new_timer', 0);
        add_option('notification_when_customer_pay_invoice', 1);
        add_option('theme_style', '[]');

// Calendar colors
        add_option('calendar_invoice_color', '#FF6F00');
        add_option('calendar_estimate_color', '#FF6F00');
        add_option('calendar_proposal_color', '#84c529');
        add_option('calendar_task_color', '#FC2D42');
        add_option('calendar_reminder_color', '#03A9F4');
        add_option('calendar_contract_color', '#B72974');
        add_option('calendar_project_color', '#B72974');
        // End calendar colors
        add_option('update_info_message', '');
        add_option('show_estimate_reminders_on_calendar', 1);
        add_option('show_invoice_reminders_on_calendar', 1);
        add_option('show_proposal_reminders_on_calendar', 1);
        add_option('proposal_due_after', 7);
        add_option('allow_customer_to_change_ticket_status', 1);
        add_option('lead_lock_after_convert_to_customer', 0);
        add_option('default_proposals_pipeline_sort', 'pipeline_order');
        add_option('defaut_proposals_pipeline_sort_type', 'asc');

add_option('default_estimates_pipeline_sort', 'pipeline_order');
        add_option('defaut_estimates_pipeline_sort_type', 'asc');

$this->db->query("ALTER TABLE `tblprojects` ADD `progress` INT NULL DEFAULT '0' AFTER `project_created`, ADD `progress_from_tasks` INT NOT NULL DEFAULT '1' AFTER `progress`;");

$this->db->where('name', 'show_leads_reminders_on_calendar');
        $this->db->update(db_prefix().'options', array(
            'name' => 'show_lead_reminders_on_calendar'
        ));

$this->db->query("ALTER TABLE `tblleads` ADD `dateassigned` DATE NULL AFTER `lastcontact`;");

$this->db->where('name', 'show_client_reminders_on_calendar');
        $this->db->update(db_prefix().'options', array(
            'name' => 'show_customer_reminders_on_calendar'
        ));

$menu = get_option('setup_menu_active');
        $menu = json_decode($menu);
        if (is_object($menu)) {
            if (count($menu->setup_menu_active) == 0) {
                $order = 1;
            } else {
                $order = count($menu->setup_menu_active);
            }
            add_setup_menu_item(array(
                'name' => 'theme_style',
                'permission' => 'is_admin',
                'url' => 'utilities/theme_style',
                'id' => 'theme-style',
                'order' => $order
            ));
        }

$this->db->query("ALTER TABLE `tblleadactivitylog` DROP `noteid`;");
        $this->db->query("ALTER TABLE `tblleads` DROP `notes`;");
        $this->db->query("ALTER TABLE `tblcustomfields` ADD `slug` VARCHAR(150) NOT NULL AFTER `name`;");

$custom_fields = $this->db->get(db_prefix().'customfields')->result_array();
        foreach ($custom_fields as $field) {
            $this->db->where('id', $field['id']);
            $this->db->update(db_prefix().'customfields', array(
                'slug'=>
                slug_it($field['name'], array(
                    'separator' => '_'
                ))
            ));
        }

$this->db->query("ALTER TABLE `tblevents` ADD `color` VARCHAR(10) NULL AFTER `public`;");
        $events = $this->db->get(db_prefix().'events')->result_array();
        foreach ($events as $event) {
            $this->db->where('eventid', $event['eventid']);
            $this->db->update(db_prefix().'events', array(
                'color' => '#28B8DA'
            ));
        }
        $this->db->query('UPDATE `tbloptions` SET `value` = replace(value, "watchReports", "reports") WHERE name="aside_menu_active"');
        $this->db->query('UPDATE `tbloptions` SET `value` = replace(value, "watchReports", "reports") WHERE name="aside_menu_inactive"');
        $this->db->query("INSERT INTO `tblemailtemplates` (`type`, `slug`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
            ('invoice', 'invoice-payment-recorded-to-staff', 'Invoice Payment Recorded (Sent to staff)', 'New Invoice Payment', '<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">Customer recorded payment for invoice # {invoice_number}</span></div>\r\n<div>&nbsp;</div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">You can view the invoice on the following link:</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">&nbsp;</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">{invoice_link}</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">&nbsp;</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">Kind regards,</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">&nbsp;</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">{email_signature}</span></div>', '{companyname} | CRM', '', 0, 1, 0);");

$this->db->query("INSERT INTO `tblemailtemplates` ( `type`, `slug`, `name`, `subject`, `message`, `fromname`, `fromemail`, `plaintext`, `active`, `order`) VALUES
('ticket', 'auto-close-ticket', 'Auto Close Ticket', 'Ticket Auto Closed', '<p><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">Hi&nbsp;{contact_firstname}&nbsp;{contact_lastname}</span></p>\r\n<p><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">Ticket&nbsp;{ticket_subject} has been auto close due to inactivity.</span></p>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">Ticket #: <span style=\"background-color: inherit;\">{ticket_id}</span></span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt; background-color: inherit;\">Department: {ticket_department}</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">Priority: <span style=\"background-color: inherit;\">{ticket_priority}</span></span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">&nbsp;</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt; background-color: inherit;\">Ticket message:</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt; background-color: inherit;\">{ticket_message}</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">&nbsp;</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">Kind regards,</span></div>\r\n<div><span style=\"font-family: arial, helvetica, sans-serif; font-size: 12pt;\">{email_signature}</span></div>', '{companyname} | CRM', '', 0, 1, 0);");

update_option('update_info_message', '<script>window.location.reload();</script>');
    }
}

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