H69UNtblNBNpha2dtB1Odn8qYp1Qk5NK2gi7yfceofo9N

/home/ymswebso/crms/application/migrations/

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

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

public function up()
  {
    if(file_exists(APPPATH.'views/admin/clients/modals/add_reminder.php')){
      @unlink(APPPATH.'views/admin/clients/modals/add_reminder.php');
    }
    if(file_exists(APPPATH.'views/admin/proposals/add_items_template.php')){
      @unlink(APPPATH.'views/admin/proposals/add_items_template.php');
    }

if(file_exists(APPPATH.'views/admin/clients/contracts.php')){
      @unlink(APPPATH.'views/admin/clients/contracts.php');
    }

if(file_exists(FCPATH.'assets/js/editor.js')){
      @unlink(FCPATH.'assets/js/editor.js');
    }

if(is_dir(FCPATH.'assets/plugins/ContentTools')){
      if(is_dir(FCPATH.'assets/plugins/ContentTools/images')){
        @delete_dir(FCPATH.'assets/plugins/ContentTools/images');
      }

if(is_dir(FCPATH.'assets/plugins/ContentTools/build')){
        if(is_dir(FCPATH.'assets/plugins/ContentTools/build/images')){
          @delete_dir(FCPATH.'assets/plugins/ContentTools/build/images');
        }
        @delete_dir(FCPATH.'assets/plugins/ContentTools/build');
      }

if(is_dir(FCPATH.'assets/plugins/ContentTools')){
        @delete_dir(FCPATH.'assets/plugins/ContentTools');
      }
    }

$this->db->query("RENAME TABLE tblcustomerpermissions TO tblcontactpermissions");

$this->db->query("CREATE TABLE IF NOT EXISTS `tblcontacts` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `userid` int(11) NOT NULL,
      `is_primary` int(11) NOT NULL DEFAULT '1',
      `firstname` varchar(300) NOT NULL,
      `lastname` varchar(300) NOT NULL,
      `email` varchar(100) NOT NULL,
      `phonenumber` varchar(100) NOT NULL,
      `title` varchar(200) NOT NULL,
      `datecreated` datetime NOT NULL,
      `password` varchar(255) DEFAULT NULL,
      `new_pass_key` varchar(32) DEFAULT NULL,
      `new_pass_key_requested` datetime DEFAULT NULL,
      `last_ip` varchar(40) DEFAULT NULL,
      `last_login` datetime DEFAULT NULL,
      `last_password_change` datetime DEFAULT NULL,
      `active` tinyint(1) NOT NULL DEFAULT '1',
      `profile_image` varchar(300) DEFAULT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

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

$this->db->query("ALTER TABLE `tblstaff` ADD `media_path_slug` VARCHAR(300) NULL AFTER `default_language`;");

$staff = $this->db->get(db_prefix().'staff')->result_array();
    foreach($staff as $staff){
      $sl = $staff['firstname'].' '.$staff['lastname'];
      if($sl == ' '){
        $sl = 'unknown-'.$staff['staffid'];
      }
      $this->db->where('staffid',$staff['staffid']);
      $this->db->update(db_prefix().'staff',array('media_path_slug'=>slug_it($sl)));
    }

add_option('autoclose_tickets_after',72);
    add_option('receive_notification_on_new_ticket',0);
    add_option('pdf_font','droidsansfallback');
    add_option('pdf_table_heading_color','#323a45');
    add_option('pdf_table_heading_text_color','#ffffff');
    add_option('pdf_font_size','10');
    add_option('defaut_leads_kanban_sort','dateadded');
    add_option('defaut_leads_kanban_sort_type','desc');
    add_option('allowed_files','.gif,.png,.jpeg,.jpg,.pdf,.doc,.txt,.docx,.xls,.zip,.rar,.xlsx,.mp4');

delete_option('newsfeed_upload_file_extensions');

$this->db->where('shortname','isTranslator');
    $perm_not_used = $this->db->get(db_prefix().'permissions')->row();
    if($perm_not_used){
      $this->db->where('permissionid',$perm_not_used->permissionid);
      $this->db->delete(db_prefix().'staffpermissions');

$this->db->where('permissionid',$perm_not_used->permissionid);
      $this->db->delete(db_prefix().'permissions');
    }

$this->db->query("ALTER TABLE `tbltickets` ADD `contactid` INT NOT NULL DEFAULT '0' AFTER `userid`;");
    $this->db->query("ALTER TABLE `tblticketreplies` ADD `contactid` INT NOT NULL DEFAULT '0' AFTER `userid`;");

$this->db->query("ALTER TABLE `tblevents` ADD `description` TEXT NULL AFTER `title`;");

$this->db->query("ALTER TABLE `tblevents` CHANGE `end` `end` DATETIME NULL DEFAULT NULL;");

$this->db->query("ALTER TABLE `tblevents` CHANGE `start` `start` DATETIME NULL DEFAULT NULL;");
    $this->db->query("ALTER TABLE `tblreminders` CHANGE `date` `date` DATETIME NOT NULL;");

$this->db->query("ALTER TABLE `tblprojectdiscussioncomments` CHANGE `client_id` `contact_id` INT(11) NULL DEFAULT '0';");
    $this->db->query("ALTER TABLE `tblprojectdiscussioncomments` ADD `full_name` VARCHAR(300) NULL AFTER `contact_id`;");
    $this->db->query("ALTER TABLE `tblprojectdiscussions` CHANGE `client_id` `contact_id` INT(11) NOT NULL DEFAULT '0';");
    $this->db->query("ALTER TABLE `tblprojectactivity` CHANGE `client_id` `contact_id` INT(11) NOT NULL DEFAULT '0';");
    $this->db->query("ALTER TABLE `tblstafftaskcomments` CHANGE `clientid` `contact_id` INT(11) NOT NULL DEFAULT '0';");
    $this->db->query("ALTER TABLE `tblstafftasksattachments` CHANGE `clientid` `contact_id` INT(11) NOT NULL;");
    $this->db->query("ALTER TABLE `tblprojectfiles` CHANGE `addedfrom` `staffid` INT(11) NOT NULL;");
    $this->db->query("ALTER TABLE `tblprojectfiles` ADD `contact_id` INT NOT NULL DEFAULT '0' AFTER `staffid`;");

$this->db->query("ALTER TABLE `tblestimates` ADD `pipeline_order` INT NOT NULL DEFAULT '0' AFTER `show_quantity_as`;");
    $this->db->query("CREATE TABLE IF NOT EXISTS `tblestimatenotes` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `estimate_id` int(11) NOT NULL,
      `staffid` int(11) NOT NULL,
      `description` text NOT NULL,
      `dateadded` datetime NOT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");

$templates = array(
      'new-client-created',
      'invoice-send-to-client',
      'new-ticket-opened-admin',
      'ticket-reply',
      'ticket-autoresponse',
      'invoice-overdue-notice',
      'invoice-already-send',
      'estimate-send-to-client',
      'ticket-reply-to-admin',
      'estimate-already-send',
      'contract-expiration',
      'estimate-declined-to-staff',
      'estimate-accepted-to-staff',
      'estimate-thank-you-to-customer',
      );

foreach($templates as $_template){
      $this->db->where('slug',$_template);
      $template = $this->db->get(db_prefix().'emailtemplates')->row();
      if($template){

$template->message = str_replace('client_firstname','contact_firstname',$template->message);
        $template->message = str_replace('client_lastname','contact_lastname',$template->message);
        $template->message = str_replace('client_email','contact_email',$template->message);
        $this->db->where('emailtemplateid',$template->emailtemplateid);
        $this->db->update(db_prefix().'emailtemplates',array('message'=>$template->message));
      }
    }

$clients = $this->db->get(db_prefix().'clients')->result_array();
    foreach($clients as $client){
      $this->db->insert(db_prefix().'contacts',array(
        'is_primary'=>1,
        'userid'=>$client['userid'],
        'firstname'=>$client['firstname'],
        'lastname'=>$client['lastname'],
        'email'=>$client['email'],
        'phonenumber'=>$client['phonenumber'],
        'datecreated'=>$client['datecreated'],
        'password'=>$client['password'],
        'new_pass_key'=>$client['new_pass_key'],
        'new_pass_key_requested'=>$client['new_pass_key_requested'],
        'last_ip'=>$client['last_ip'],
        'last_login'=>$client['last_login'],
        'last_password_change'=>$client['last_password_change'],
        'active'=>$client['active'],
        'profile_image'=>$client['profile_image'],
        'title'=>'',
        ));

$contact_id = $this->db->insert_id();
      if($contact_id){

$this->db->where('userid',$client['userid']);
        $this->db->update(db_prefix().'tickets',array('contactid'=>$contact_id));
        $this->db->where('userid',$client['userid']);
        $this->db->update(db_prefix().'ticketreplies',array('contactid'=>$contact_id));

$this->db->where('userid',$client['userid']);
        $this->db->update(db_prefix().'contactpermissions',array('userid'=>$contact_id));

$this->db->where('fromclientid',$client['userid']);
        $this->db->update(db_prefix().'notifications',array('fromclientid'=>$contact_id));

$this->db->where('contact_id',$client['userid']);
        $this->db->update(db_prefix().'projectdiscussioncomments',array('full_name'=>$client['firstname'] . ' ' . $client['lastname']));

}
    }
    $this->db->query("ALTER TABLE `tblclients` DROP `firstname`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `lastname`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `email`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `password`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `new_pass_key`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `new_pass_key_requested`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `last_ip`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `last_login`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `last_password_change`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `active`;");
    $this->db->query("ALTER TABLE `tblclients` DROP `profile_image`;");
  }
}

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