File manager - Edit - /home/autoph/public_html/tasks/classes.tar
Back
logger.php 0000644 00000001517 15024755751 0006553 0 ustar 00 <?php class Logger{ function log($data_arr){ $user_id = isset($data_arr['user_id']) ? $data_arr['user_id'] : '' ; $description = isset($data_arr['description']) ? $data_arr['description'] : '' ; $target_id = isset($data_arr['target_id']) ? $data_arr['target_id'] : '' ; $type = isset($data_arr['type']) ? $data_arr['type'] : '' ; $status = isset($data_arr['status']) ? intval($data_arr['status']) : 1 ; $db = $data_arr['db']; $query = "INSERT INTO `log`(`user_id`, `description`, `target_id`, `date_added`, `type`, `status`) VALUES ( NULLIF('$user_id',''), NULLIF('$description',''), NULLIF('$target_id',''), NOW(), NULLIF('$type',''), $status )"; $db->sql_query($query); } } ?> model_class.php 0000644 00000005556 15024755751 0007570 0 ustar 00 <?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Model{ function read_models($brand_id,$search,$utility_class,$db){ $query = "SELECT m.`id`, m.`name` FROM `vehicle_models` m INNER JOIN vehicle_brands b ON m.`brand_id` = b.id WHERE 1 AND m.status = 1 AND b.status = 1 AND b.id = $brand_id AND m.name LIKE '%$search%' ORDER BY m.name ASC;"; return $db->sql_query($query); } function read_model_by_name($brand_id,$model_name,$utility_class,$db){ $query = "SELECT m.* FROM `vehicle_models` m INNER JOIN lms2_vehicle_brands b ON m.brand_id = b.id WHERE m.name = '$model_name' AND m.status = 1 AND b.id = $brand_id ORDER BY m.name ASC LIMIT 1; "; return $db->sql_query($query); } function read_model_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_models` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_model_id_by_name_n_brand_id($brand_id,$name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_models` WHERE brand_id = $brand_id AND name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_model_variant_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_model_variants` WHERE description = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_model_variants($vehicle_model_id,$search,$utility_class,$db){ $model_filter = $utility_class->isNotEmpty($vehicle_model_id) ? " AND vmv.model_id = $vehicle_model_id " : "" ; // $model_filter = ""; $query = "SELECT vmv.id, vmv.description, vm.id as model_id, vm.name as model,vb.id as brand_id, vb.name as brand FROM `vehicle_model_variants` vmv LEFT OUTER JOIN vehicle_models vm ON vmv.model_id = vm.id LEFT OUTER JOIN vehicle_brands vb ON vm.brand_id = vb.id WHERE 1 AND vmv.description LIKE '%%%s%%' %s /*model id*/ AND vmv.status = 1 GROUP BY vmv.description LIMIT 10"; $query_final = sprintf($query,$search,$model_filter); // echo $query_final;exit; return $db->sql_query($query_final); } function insert_model_variant($model_id,$model_variant,$utility_class,$db){ $query = "INSERT INTO `vehicle_model_variants`(`model_id`, `description`, `status`) VALUES ('$model_id','$model_variant',1)"; return $db->sql_query_id($query); } } ?> index.php 0000644 00000000000 15024755751 0006365 0 ustar 00 ticket_class.php 0000644 00000131123 15024755751 0007741 0 ustar 00 <?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Ticket{ function create_ticket($user_id,$sub_category_id,$priority_id,$title,$description,$status,$utility_class,$db){ $query = "INSERT INTO `tickets`(`user_id`, `sub_category_id`, `priority_level_id`, `title`, `description`, `date_added`, `status`) VALUES (NULLIF('$user_id',''),'$sub_category_id','$priority_id','$title','$description',NOW(),'$status')"; // echo $query;exit; return $db->sql_query_id($query); } function update_ticket($ticket_id,$user_id,$sub_category_id,$priority_id,$title,$description,$utility_class,$db){ $query = "UPDATE `tickets` SET `sub_category_id`=$sub_category_id,`priority_level_id`=$priority_id,`title`='$title',`description`='$description' WHERE 1 AND id = $ticket_id"; return $db->sql_query_id($query); } function create_reply_ticket($user_id,$ticket_id,$description,$status,$final_status,$utility_class,$db){ $query = "INSERT INTO `ticket_replies`(`user_id`, `ticket_id`, `description`, `ticket_status_id`, `ticket_final_status_id`,`date_added`, `status`) VALUES (NULLIF('$user_id',''),$ticket_id,NULLIF('$description',''),$status,NULLIF('$final_status',''),NOW(),1)"; return $db->sql_query_id($query); } function create_ticket_attachment($ticket_id,$attachment_change_name,$attachment_orig_name,$utility_class,$db){ $query = "INSERT INTO `ticket_attachments`(`ticket_id`, `attachment_name`, `original_name`, `date_added`, `status`) VALUES ($ticket_id,'$attachment_change_name','$attachment_orig_name',NOW(),1)"; return $db->sql_query_id($query); } function update_ticket_attachment_status($ids,$status,$utility_class,$db){ $query = "UPDATE `ticket_attachments` SET status = $status WHERE 1 AND `id` IN ($ids)"; return $db->sql_query_id($query); } function update_all_ticket_attachment_status($ticket_id,$status,$utility_class,$db){ $query = "UPDATE `ticket_attachments` SET status = $status WHERE 1 AND `ticket_id` = $ticket_id"; return $db->sql_query_id($query); } function remove_all_ticket_attachment_status($ticket_id,$utility_class,$db){ $query = "DELETE FROM `ticket_attachments` WHERE 1 AND ticket_id = $ticket_id"; return $db->sql_query_id($query); } function create_reply_ticket_attachment($ticket_reply_id,$attachment_change_name,$attachment_orig_name,$utility_class,$db){ $query = "INSERT INTO `ticket_reply_attachments`(`ticket_reply_id`, `attachment_name`, `original_name`, `status`) VALUES ($ticket_reply_id,'$attachment_change_name','$attachment_orig_name',1)"; // echo $query;exit; return $db->sql_query_id($query); } function create_vehicle_type_ticket($ticket_id,$model_id,$model_variant_id,$plate_cs,$vin,$year_model,$utility_class,$db){ $query = "INSERT INTO `ticket_type_vehicles`( `ticket_id`, `model_id`, `plate_cs`, `vin`, `year_model`, `model_variant_id`,`status`) VALUES ('$ticket_id','$model_id',NULLIF('$plate_cs',''),NULLIF('$vin',''),NULLIF('$year_model',''),NULLIF('$model_variant_id',''),1)"; return $db->sql_query_id($query); } function create_vehicle_type_ticket_v2($ticket_id,$model_id,$model_variant_id,$plate_cs,$vin,$year_model,$mileage,$breakdown,$on_site,$workshop_visit,$status,$utility_class,$db){ $query = "INSERT INTO `ticket_type_vehicles`( `ticket_id`, `model_id`, `plate_cs`, `vin`, `year_model`, `model_variant_id`,`mileage`,`breakdown`,`on_site`,`workshop_visit_count`,`status`) VALUES ('$ticket_id','$model_id',NULLIF('$plate_cs',''),NULLIF('$vin',''),NULLIF('$year_model',''),NULLIF('$model_variant_id',''),NULLIF('$mileage',''),NULLIF('$breakdown',''),NULLIF('$on_site',''),NULLIF('$workshop_visit',''),'$status')"; // echo $query; return $db->sql_query_id($query); } function update_vehicle_type_ticket($ticket_id,$model_id,$model_variant_id,$plate_cs,$vin,$year_model,$status,$utility_class,$db){ $query = "UPDATE `ticket_type_vehicles` SET `model_id`=$model_id,`plate_cs`=NULLIF('$plate_cs',''),`vin`=NULLIF('$vin',''),`year_model`=NULLIF('$year_model',''),`model_variant_id`=NULLIF('$model_variant_id',''),status = '$status' WHERE 1 AND ticket_id = $ticket_id"; return $db->sql_query($query); } function update_vehicle_type_ticket_v2($ticket_id,$model_id,$model_variant_id,$plate_cs,$vin,$year_model,$mileage,$breakdown,$on_site,$workshop_visit,$status,$utility_class,$db){ $query = "UPDATE `ticket_type_vehicles` SET `model_id`=$model_id,`plate_cs`=NULLIF('$plate_cs',''),`vin`=NULLIF('$vin',''),`year_model`=NULLIF('$year_model',''),`model_variant_id`=NULLIF('$model_variant_id',''),`mileage`=NULLIF('$mileage',''),`breakdown`=NULLIF('$breakdown',''),`on_site`=NULLIF('$on_site',''),`workshop_visit_count`=NULLIF('$workshop_visit',''),status = '$status' WHERE 1 AND ticket_id = $ticket_id"; return $db->sql_query($query); } function update_ticket_customer($ticket_id,$complaint,$work_performed,$fault_codes,$utility_class,$db){ $query = "UPDATE `tickets` SET `complaint`=NULLIF('$complaint',''),`work_performed`=NULLIF('$work_performed',''),`fault_codes`=NULLIF('$fault_codes','') WHERE 1 AND id = $ticket_id"; return $db->sql_query($query); } function update_vehicle_type_ticket_status($ticket_id,$status,$utility_class,$db){ $query = "UPDATE `ticket_type_vehicles` SET status = $status WHERE 1 AND ticket_id = $ticket_id"; return $db->sql_query($query); } function read_vehicle_type_ticket($ticket_id,$utility_class,$db){ $query = "SELECT * FROM `ticket_type_vehicles` WHERE 1 AND ticket_id = $ticket_id"; return $db->sql_query($query); } function read_sub_categories($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `sub_categories` WHERE name LIKE '%$search%' AND status = 1 ORDER BY position ASC;"; return $db->sql_query($query); } function read_sections($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `sections` WHERE name LIKE '%$search%' AND status = 1 ORDER BY name ASC;"; return $db->sql_query($query); } function read_final_status($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `ticket_final_status` WHERE name LIKE '%$search%' AND status = 1 ORDER BY id,name ASC;"; return $db->sql_query($query); } function read_priority_level($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `priority_levels` WHERE name LIKE '%$search%' AND status = 1 ORDER BY level ASC;"; return $db->sql_query($query); } function read_ticket_status($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `ticket_status` WHERE name LIKE '%$search%' AND status = 1 ORDER BY level ASC;"; return $db->sql_query($query); } function read_ticket_available_status($exclude_ids,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `ticket_status` WHERE 1 AND id NOT IN ($exclude_ids) AND status = 1 ORDER BY level ASC;"; return $db->sql_query($query); } function read_sub_category_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `sub_categories` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_section_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `sections` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_category_id_by_sub_category_id($sub_category_id,$utility_class,$db){ $query = "SELECT sc.`category_id`,c.show_vehicle FROM `sub_categories` sc INNER JOIN categories c ON sc.category_id = c.id WHERE sc.id = '$sub_category_id' AND sc.status = 1 LIMIT 1;"; // echo $query;exit; // return $db->select($query); return $db->sql_query($query); } function read_priority_level_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `priority_levels` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_sub_category_count($db){ $ticket_query = $this->universal_ticket_query(); // START TICKET SECTION $ticket_fields = " sc.id, sc.name, COUNT(sc.id) as sub_category_count "; $ticket_counts = " COUNT(1) "; $ticket_query = $ticket_query." AND tfs.id IS NOT NULL /*remove not close ticket*/ AND t.status = 1 AND sc.status = 1 AND c.status = 1 GROUP BY sc.id ORDER BY sc.name ASC "; $ticket_query_formatted = sprintf( $ticket_query, $ticket_fields, ); return $db->sql_query($ticket_query_formatted); } function universal_ticket_query(){ return " SELECT %s FROM `tickets` t LEFT OUTER JOIN sub_categories sc ON t.sub_category_id = sc.id LEFT OUTER JOIN categories c ON sc.category_id = c.id /*LEFT OUTER JOIN ticket_type_vehicles ttv ON t.id = ttv.ticket_id*/ LEFT OUTER JOIN ticket_type_vehicles ttv ON ttv.id = (SELECT ttvs.id FROM ticket_type_vehicles ttvs WHERE ttvs.ticket_id = t.id /*AND ttvs.status = 1*/) LEFT OUTER JOIN vehicle_models vm ON ttv.model_id = vm.id LEFT OUTER JOIN vehicle_brands vb ON vm.brand_id = vb.id LEFT OUTER JOIN vehicle_model_variants vmv ON ttv.model_variant_id = vmv.id LEFT OUTER JOIN ticket_progress_status tps ON tps.id = ( SELECT MAX(trs.id) AS maxsign FROM ticket_progress_status trs WHERE trs.ticket_id = t.id GROUP BY trs.ticket_id ) LEFT OUTER JOIN priority_levels pl ON t.priority_level_id = pl.id LEFT OUTER JOIN ticket_status ts ON tps.ticket_status_id = ts.id LEFT OUTER JOIN users u ON t.user_id = u.id LEFT OUTER JOIN user_contacts uc ON u.id = uc.user_id LEFT OUTER JOIN ticket_ratings trg ON trg.id = ( SELECT MAX(trgs.id) AS maxsign FROM ticket_ratings trgs WHERE trgs.ticket_id = t.id ) LEFT OUTER JOIN ticket_expert_reminder ter ON ter.id = ( SELECT MAX(ters.id) AS maxsign FROM ticket_expert_reminder ters WHERE ters.ticket_id = t.id ) WHERE 1 "; } function read_ticket_list($source,$user_id, $owned_ticket_only, $category_ids_str, $status_ids_str, // $status_ids_str_null, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $brand_id, $model_id, $brand_access_arr, $search, $offset, $limit, $utility_class,$db){ $category_ids_str = $utility_class->isNotEmpty($category_ids_str) ? " AND t.sub_category_id IN ($category_ids_str) " : '' ; $status_ids_str = $utility_class->isNotEmpty($status_ids_str) ? " AND ts.id IN ($status_ids_str) " : '' ; // $final_status_ids_str = $utility_class->isNotEmpty($final_status_ids_str) ? " AND tfs.id IN ($final_status_ids_str) " : '' ; // $filter_escalated_status = $utility_class->isNotEmpty($filter_escalated_status) ? " AND tes.type IN ($filter_escalated_status) " : '' ; $priority_ids_str = $utility_class->isNotEmpty($priority_ids_str) ? " AND t.priority_level_id IN ($priority_ids_str) " : '' ; $brand = $utility_class->isNotEmpty($brand_id) ? " AND vb.id IN ($brand_id) " : "" ; $model = $utility_class->isNotEmpty($model_id) ? " AND vm.id IN ($model_id) " : "" ; if($utility_class->isNotEmpty($start_date) && $utility_class->isNotEmpty($end_date)){ $dates = " AND DATE_FORMAT(t.date_added, '%Y-%m-%d') BETWEEN '$start_date' AND '$end_date' "; }else{ $dates = ""; } if($owned_ticket_only){ $my_ticket_only = " AND t.user_id = $user_id " ; }else{ $my_ticket_only = "" ; } if($utility_class->isNotEmpty($search)){ $reference_no = " OR (t.reference_no = '$search' OR t.reference_no = replace('$search', '#', '')) "; }else{ $reference_no = ""; } // $filter_brands = (count($brand_access_arr) > 0) ? " AND (ttv.brand_id IN (".implode(",",$brand_access_arr).") OR ttv.brand_id IS NULL) " : "" ; $filter_brands_ids = (count($brand_access_arr) > 0) ? implode(",",$brand_access_arr) : "0" ; $filter_brands = " AND (vb.id IN ($filter_brands_ids) OR vb.id IS NULL) "; //REMOVE closed in default list $no_display_close = ""; if(!$utility_class->isNotEmpty($status_ids_str) && !$utility_class->isNotEmpty($category_ids_str) && // !$utility_class->isNotEmpty($final_status_ids_str) && // !$utility_class->isNotEmpty($filter_escalated_status) && !$utility_class->isNotEmpty($priority_ids_str) && !$utility_class->isNotEmpty($search) && !$utility_class->isNotEmpty($brand) && !$utility_class->isNotEmpty($model) && !$utility_class->isNotEmpty($my_ticket_only) ){ $no_display_close = " AND (ts.id NOT IN (3,5) OR ts.id IS NULL) "; } $final_data = null; if($source === 1 ){ $final_data = $this->read_ticket_list_table( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $status_ids_str_null, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $reference_no, $no_display_close, $search, $offset, $limit, $utility_class,$db); }else if($source === 2){ $final_data = $this->read_ticket_list_countings( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db); }else if($source === 3){ $final_data = $this->read_ticket_list_brand_count( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db); }else if($source === 4){ $final_data = $this->read_ticket_list_graph_open( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db); }else if($source === 5){ $final_data = $this->read_ticket_list_graph_close( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db); } return $final_data; } function read_ticket_list_countings( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $field = " 1 "; $query = $ticket_query." %s /*sub category*/ %s /*ticket status*/ %s /*priority */ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*own*/ %s /*dates*/ AND t.status = 1 GROUP BY t.id "; $query_formatted = "SELECT COUNT(1) FROM (".sprintf( $query, $field, $category_ids_str, $status_ids_str, // $final_status_ids_str, $priority_ids_str, $brand, $model, $filter_brands, $my_ticket_only, $dates ).") t1"; return $db->select($query_formatted); } function read_ticket_list_brand_count( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $field = " vb.id,vb.name "; $query = $ticket_query." %s /*sub category*/ %s /*ticket status*/ %s /*priority */ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*own*/ %s /*dates*/ AND ts.id IN (1,2) AND t.status = 1 AND vb.id IS NOT NULL GROUP BY t.id "; $query_formatted = "SELECT t1.id,COUNT(1) as count FROM (".sprintf( $query, $field, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $brand, $model, $filter_brands, $my_ticket_only, $dates ).") t1 GROUP BY t1.id"; return $db->sql_query($query_formatted); } function read_open_ticket_w_brand($utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $field = " t.id,t.title,t.reference_no,sc.name as sub_category,pl.name as priority_level,t.date_added,u.id AS user_id, u.firstname, u.lastname,IF(ter.id IS NULL,t.date_added,ter.date_added) as last_reminder,vb.id as brand_id,vb.name as brand,vm.name as model,vmv.description as model_variant "; $query = $ticket_query." AND ts.id IN (1,2) AND t.status = 1 AND vb.id IS NOT NULL GROUP BY t.id "; $query_formatted = sprintf( $query, $field ); return $db->sql_query($query_formatted); } function read_ticket_list_graph_open( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $field = " YEAR(t.date_added) as data_year,MONTH(t.date_added) as data_month,t.date_added "; $query = $ticket_query." %s /*sub category*/ %s /*ticket status*/ %s /*priority */ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*own*/ %s /*dates*/ AND t.status = 1 GROUP BY t.id "; $query_formatted = "SELECT t1.data_year,t1.data_month,COUNT(1) as count,DATE_FORMAT(t1.date_added,'%b %Y') as data_monthw FROM (".sprintf( $query, $field, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $brand, $model, $filter_brands, $my_ticket_only, $dates ).") t1 GROUP BY t1.data_month, t1.data_year ORDER BY t1.data_year ASC, t1.data_month ASC "; return $db->sql_query($query_formatted); } function read_ticket_list_graph_close( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $field = " YEAR(t.date_added) as data_year,MONTH(t.date_added) as data_month,t.date_added "; $query = $ticket_query." %s /*sub category*/ %s /*ticket status*/ %s /*priority */ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*own*/ %s /*dates*/ AND t.status = 1 AND ts.id IN (3) GROUP BY t.id "; $query_formatted = "SELECT t1.data_year,t1.data_month,COUNT(1) as count,DATE_FORMAT(t1.date_added,'%b %Y') as data_monthw FROM (".sprintf( $query, $field, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $brand, $model, $filter_brands, $my_ticket_only, $dates ).") t1 GROUP BY t1.data_month, t1.data_year ORDER BY t1.data_year ASC, t1.data_month ASC "; return $db->sql_query($query_formatted); } function read_ticket_list_table( $brand, $model, $filter_brands, $dates, $my_ticket_only, $category_ids_str, $status_ids_str, // $status_ids_str_null, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $start_date, $end_date, $reference_no, $no_display_close, $search, $offset, $limit, $utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $offset_limit = "LIMIT ".$offset.",".$limit." "; $field = " t.id,t.title,t.`date_added`,t.reference_no, DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf, DATE_FORMAT(t.date_added,'%b. %d, %Y %h:%i %p') date_addedw, vb.name as brand,vm.name as model,ttv.plate_cs, pl.name as priority_level,sc.name as sub_category, IF(ts.id IS NOT NULL, ts.name , (SELECT name FROM ticket_status WHERE level = 1 AND status = 1 LIMIT 1) ) as status, u.firstname, u.lastname "; $field_count = " COUNT(1) "; // abs($db->server_info()) $left_regex = "\\\\b"; $right_regex = "\\\\b"; if(abs($db->server_info()) < 8){ $left_regex = "[[:<:]]"; $right_regex = "[[:>:]]"; } $search = " AND (CONCAT(t.title,' ',IF(ttv.id IS NULL,'',CONCAT(IFNULL(ttv.plate_cs,''),' ',IFNULL(ttv.vin,'')))) LIKE '%$search%' OR t.fault_codes RLIKE '$left_regex".$search."$right_regex' $reference_no ) "; $query = $ticket_query." %s /*search*/ %s /*no_display_close*/ %s /*sub category*/ %s /*ticket status*/ %s /*priority */ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*dates*/ %s /*my ticket*/ AND t.status = 1 GROUP BY t.id ORDER BY t.date_added DESC %s "; $query_formatted = sprintf( $query, $field, $search, $no_display_close, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $brand, $model, $filter_brands, $dates, $my_ticket_only, $offset_limit ); // echo $query_formatted;exit; $query_formatted_count = 'SELECT COUNT(1) FROM ('.sprintf( $query, $field_count, $search, $no_display_close, $category_ids_str, $status_ids_str, // $final_status_ids_str, // $filter_escalated_status, $priority_ids_str, $brand, $model, $filter_brands, $dates, $my_ticket_only, '' ).') as t1'; // echo $query_formatted;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_ticket_information($ticket_id,$utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $field = " t.id,t.title,t.description,t.`date_added`,t.reference_no,t.type,trg.rating, /*DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf,*/ DATE_FORMAT(t.date_added,'%b. %d, %Y %h:%i%p') as date_addedf, t.user_id,c.name as category, vb.id as brand_id,vb.name as brand,vm.id as model_id,vm.name as model,ttv.plate_cs,ttv.vin,ttv.mileage,ttv.workshop_visit_count, ttv.breakdown,ttv.on_site,t.complaint,t.work_performed,t.fault_codes, ts.id as ticket_status_id,ts.name as ticket_status, sc.id as sub_category_id,sc.name as sub_category,vmv.id as model_variant_id,vmv.description as model_variant, pl.id as priority_level_id,pl.name as priority_level,ttv.year_model,sc.category_id,c.show_vehicle, u.firstname, u.lastname,uc.mobile,uc.email "; $query = $ticket_query." AND t.id = $ticket_id "; $query_formatted = sprintf($query,$field); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_ticket_attachments($ticket_id,$utility_class,$db){ $query = "SELECT *,DATE_FORMAT(date_added, '%M %d, %Y') as date_addedf FROM `ticket_attachments` WHERE 1 AND `ticket_id` = $ticket_id AND status = 1"; return $db->sql_query($query); } function remove_role($id,$utility_class,$db){ $query = "UPDATE `lms2_roles` SET `status`=0 WHERE id = $id"; $affected_rows = $db->sql_query_affected_rows($query); return intval($affected_rows); } function read_ticket_replies($ticket_id,$offset,$limit,$order,$utility_class,$db){ $query = "SELECT tr.id,tr.ticket_id,t.user_id as owner_id,u.id as from_user,u.firstname,u.lastname,tr.description,ts.name as ticket_status, /*IF(DATE_FORMAT(tr.date_added,'%Y') = DATE_FORMAT(NOW(),'%Y') , DATE_FORMAT(tr.date_added,'%b. %d %h:%i%p'),DATE_FORMAT(tr.date_added,'%b. %d, %Y %h:%i%p')) as date_addedf*/ DATE_FORMAT(tr.date_added,'%b. %d, %Y %h:%i%p') as date_addedf FROM ticket_replies tr LEFT OUTER JOIN tickets t ON tr.ticket_id = t.id LEFT OUTER JOIN users u ON tr.user_id = u.id LEFT OUTER JOIN ticket_status ts ON tr.ticket_status_id = ts.id WHERE 1 AND tr.ticket_id = $ticket_id AND tr.status = 1 ORDER BY tr.date_added $order /*LIMIT $offset,$limit*/ "; // echo $query;exit; return $db->sql_query($query); } function read_ticket_activities($ticket_id,$offset,$limit,$order,$utility_class,$db){ // $query = "SELECT tr.id,tr.ticket_id,t.user_id as owner_id,u.id as from_user,u.firstname,u.lastname,tr.description,ts.name as ticket_status, // /*IF(DATE_FORMAT(tr.date_added,'%Y') = DATE_FORMAT(NOW(),'%Y') , DATE_FORMAT(tr.date_added,'%b. %d %h:%i%p'),DATE_FORMAT(tr.date_added,'%b. %d, %Y %h:%i%p')) as date_addedf*/ // DATE_FORMAT(tr.date_added,'%b. %d, %Y %h:%i%p') as date_addedf // FROM ticket_replies tr // LEFT OUTER JOIN tickets t // ON tr.ticket_id = t.id // LEFT OUTER JOIN users u // ON tr.user_id = u.id // LEFT OUTER JOIN ticket_status ts // ON tr.ticket_status_id = ts.id // WHERE 1 // AND tr.ticket_id = $ticket_id // AND tr.status = 1 // ORDER BY tr.date_added $order // /*LIMIT $offset,$limit*/ // "; $query = "SELECT l.*,u.id_number,u.firstname,u.lastname, DATE_FORMAT(l.date_added,'%b. %d, %Y %h:%i%p') as date_addedf FROM `log` l LEFT OUTER JOIN users u ON l.user_id = u.id WHERE 1 AND type IN (2,3,4,5) AND target_id = $ticket_id ORDER BY `date_added` $order LIMIT $offset,$limit "; // echo $query;exit; return $db->sql_query($query); } function create_reopen_ticket($reply_id,$db){ $query = "INSERT INTO `ticket_reopen_status`(`ticket_reply_id`, `status`) VALUES ('$reply_id',1) "; $db->sql_query($query); } function create_escalated_ticket($reply_id,$type,$db){ $query = "INSERT INTO `ticket_escalated_status`(`ticket_reply_id`, `type`,`status`) VALUES ('$reply_id',$type,1) "; $db->sql_query($query); } function read_ticket_reply_attachments($ticket_reply_id,$utility_class,$db){ $query = "SELECT tra.id,tra.ticket_reply_id,tra.attachment_name,tra.original_name FROM ticket_replies tr LEFT OUTER JOIN tickets t ON tr.ticket_id = t.id LEFT OUTER JOIN users u ON tr.user_id = u.id LEFT OUTER JOIN ticket_status ts ON tr.ticket_status_id = ts.id LEFT OUTER JOIN ticket_reply_attachments tra ON tr.id = tra.ticket_reply_id WHERE 1 AND tra.ticket_reply_id = $ticket_reply_id AND tr.status = 1 AND tra.status = 1 ORDER BY tra.original_name ASC "; // echo $query ;exit; return $db->sql_query($query); } function read_ticket_list_autocomplete( $search, $offset, $limit, $utility_class,$db){ $ticket_query = $this->universal_ticket_query(); $offset_limit = "LIMIT ".$offset.",".$limit." "; $field = " t.id,t.title "; $query = $ticket_query." AND t.title LIKE '%%%s%%' AND t.status = 1 GROUP BY t.title ORDER BY t.date_added DESC %s "; $query_formatted = sprintf( $query, $field, $search, $offset_limit ); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_ticket_sub_category_ids_by_names($names,$utility_class,$db){ $query = "SELECT * FROM sub_categories WHERE name IN ($names) AND status = 1"; // echo $query;exit; return $db->sql_query($query); } function read_ticket_status_ids_by_names($names,$utility_class,$db){ $query = "SELECT * FROM ticket_status WHERE name IN ($names) AND status = 1"; // echo $query;exit; return $db->sql_query($query); } function read_ticket_final_status_ids_by_names($names,$utility_class,$db){ $query = "SELECT * FROM ticket_final_status WHERE name IN ($names) AND status = 1"; // echo $query;exit; return $db->sql_query($query); } function read_ticket_priority_ids_by_names($names,$utility_class,$db){ $query = "SELECT * FROM priority_levels WHERE name IN ($names) AND status = 1"; // echo $query;exit; return $db->sql_query($query); } function delete_ticket_reply($ticket_reply_id,$status,$db){ $query = "UPDATE `ticket_replies` SET `status`= $status WHERE 1 AND `id` = $ticket_reply_id "; // echo $query;exit; return $db->sql_query($query); } // START DASHBOARD FUNCTIONS function read_ticket_count_by_progress($status,$db){ if($status === 1){ $status_ids_str = " AND (ts.id IN ($status) OR ts.id IS NULL) "; }else{ $status_ids_str = " AND ts.id IN ($status) "; } $ticket_query = $this->universal_ticket_query(); $field = " 1 "; $query = $ticket_query." %s /*ticket status*/ AND t.status = 1 GROUP BY t.id "; $query_formatted = "SELECT COUNT(1) FROM (".sprintf($query,$field,$status_ids_str).") t1"; return $db->select($query_formatted); } function read_ticket_count_by_final_status($status,$db){ $status_ids_str = " AND tfs.id IN ($status) "; $ticket_query = $this->universal_ticket_query(); $field = " 1 "; $query = $ticket_query." %s /*ticket status*/ AND t.status = 1 GROUP BY t.id "; $query_formatted = "SELECT COUNT(1) FROM (".sprintf($query,$field,$status_ids_str).") t1"; return $db->select($query_formatted); } function read_ticket_active_support_count_per_brand($db){ $ticket_query = $this->universal_ticket_query(); $field = " vb.id,vb.name "; $query = $ticket_query." AND vb.id IS NOT NULL AND t.status = 1 GROUP BY t.id "; $query_formatted = "SELECT t1.id,COUNT(1) as count FROM (".sprintf($query,$field).") t1 GROUP BY t1.id"; return $db->sql_query($query_formatted); } function read_open_close_graph_open($db){ $ticket_query = $this->universal_ticket_query(); $field = " YEAR(t.date_added) as data_year,MONTH(t.date_added) as data_month,t.date_added "; $query = $ticket_query." AND t.status = 1 GROUP BY t.id "; $query_formatted = "SELECT t1.data_year,t1.data_month,COUNT(1) as count,DATE_FORMAT(t1.date_added,'%b') as data_monthw FROM (".sprintf($query,$field).") t1 GROUP BY t1.data_month, t1.data_year ORDER BY t1.data_year ASC, t1.data_month ASC "; return $db->sql_query($query_formatted); } function read_open_close_graph_close($db){ $ticket_query = $this->universal_ticket_query(); $field = " YEAR(t.date_added) as data_year,MONTH(t.date_added) as data_month,t.date_added "; $query = $ticket_query." AND ts.id IN (3) AND t.status = 1 GROUP BY t.id "; $query_formatted = "SELECT t1.data_year,t1.data_month,COUNT(1) as count,DATE_FORMAT(t1.date_added,'%b') as data_monthw FROM (".sprintf($query,$field).") t1 GROUP BY t1.data_month, t1.data_year ORDER BY t1.data_year ASC, t1.data_month ASC "; return $db->sql_query($query_formatted); } // END DASHBOARD FUNCTIONS function update_ticket_type($ticket_id,$type,$utility_class,$db){ $query = "UPDATE `tickets` SET `type`=$type WHERE 1 AND id = $ticket_id"; $db->sql_query($query); } function update_ticket_status($ticket_id,$status,$utility_class,$db){ $query = "UPDATE `tickets` SET `status`=$status WHERE 1 AND id = $ticket_id"; $db->sql_query($query); } function create_ticket_progress_status($ticket_id,$user_id,$status,$utility_class,$db){ $query = "INSERT INTO `ticket_progress_status`(`ticket_id`, `user_id`, `ticket_status_id`, `date_added`, `status`) VALUES ($ticket_id,$user_id,$status,NOW(),1)"; $db->sql_query($query); } function update_ticket_date_creation($ticket_id,$utility_class,$db){ $query = "UPDATE `tickets` SET `date_added`=NOW() WHERE 1 AND id = $ticket_id"; $db->sql_query($query); } function create_ticket_ref_no($ticket_id,$ref_no,$db){ $query = "UPDATE tickets SET reference_no = '$ref_no' WHERE id = $ticket_id"; $db->sql_query($query); } function create_reply_ticket_v2($user_id,$ticket_id,$description,$status,$utility_class,$db){ $query = "INSERT INTO `ticket_replies`(`user_id`, `ticket_id`, `description`, `ticket_status_id`,`date_added`, `status`) VALUES (NULLIF('$user_id',''),$ticket_id,NULLIF('$description',''),$status,NOW(),1)"; return $db->sql_query_id($query); } function read_ticket_status_id_by_name($name,$utility_class,$db){ $query = "SELECT id FROM ticket_status WHERE name = '$name' AND status = 1"; // echo $query;exit; return $db->select($query); } function read_latest_progress_status_id($ticket_id,$db){ $query = "SELECT MAX(id) FROM ticket_progress_status WHERE ticket_id = $ticket_id AND ticket_status_id IN (3,5) AND status = 1"; // echo $query;exit; return $db->select($query); } function create_ticket_rating($user_id,$ticket_id,$progress_id,$rating,$utility_class,$db){ $query = "INSERT INTO `ticket_ratings`( `user_id`,`ticket_id` ,`rating`, `progress_status_id`,`rating_comment`, `date_added`, `status`) VALUES ($user_id,$ticket_id,$rating,$progress_id,NULLIF('',''),NOW(),1)"; $db->sql_query($query); } function create_expert_reminder($ticket_id,$utility_class,$db){ $query = "INSERT INTO `ticket_expert_reminder`( `ticket_id`, `date_added`, `type`) VALUES ($ticket_id,NOW(),1)"; $db->sql_query($query); } } ?> company_class.php 0000644 00000003753 15024755751 0010133 0 ustar 00 <?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Company{ function read_company_by_source_id($source_id,$utility_class,$db){ $query = "SELECT * FROM `companies` WHERE 1 AND source_id = $source_id LIMIT 1"; return $db->sql_query($query); } function create_company($user_id,$company_source_id,$company_name,$company_code,$utility_class,$db){ $query = "INSERT INTO `companies`( `name`, `code`, `user_id`, `date_added`, `status`, `source_id`) VALUES (NULLIF('$company_name',''),NULLIF('$company_code',''),NULLIF('$user_id',''),NOW(),1,NULLIF('$company_source_id',''))"; return $db->sql_query_id($query); } function update_company($company_id,$user_id,$company_source_id,$company_name,$company_code,$utility_class,$db){ $query = "UPDATE `companies` SET `name`=NULLIF('$company_name',''),`code`=NULLIF('$company_code',''),`user_id`=NULLIF('$user_id','') WHERE 1 AND id= $company_id"; $db->sql_query($query); } function read_dealer_by_source_id($source_id,$utility_class,$db){ $query = "SELECT * FROM `dealers` WHERE 1 AND source_id = $source_id LIMIT 1"; return $db->sql_query($query); } function create_dealer($user_id,$company_id,$dealer_source_id,$dealer_name,$dealer_code,$utility_class,$db){ $query = "INSERT INTO `dealers`( `name`, `company_id`,`code`, `user_id`, `date_added`, `status`, `source_id`) VALUES (NULLIF('$dealer_name',''),NULLIF('$company_id',''),NULLIF('$dealer_code',''),NULLIF('$user_id',''),NOW(),1,NULLIF('$dealer_source_id',''))"; return $db->sql_query_id($query); } function update_dealer($company_id,$dealer_id,$user_id,$dealer_source_id,$dealer_name,$dealer_code,$utility_class,$db){ $query = "UPDATE `dealers` SET `company_id`=NULLIF('$company_id',''),`name`=NULLIF('$dealer_name',''),`code`=NULLIF('$dealer_code',''),`user_id`=NULLIF('$user_id','') WHERE 1 AND id= $dealer_id"; $db->sql_query($query); } } ?> utility.php 0000644 00000042245 15024755751 0007002 0 ustar 00 <?php class Utility { function test() { return "Test101"; } function generate_uuid($db) { return $db->select("SELECT UUID_SHORT()"); } function isValidEmail($email) { return (filter_var($email, FILTER_VALIDATE_EMAIL)); } function isPostMethod($request) { if ($request != "POST") { return false; } return true; } function time_elapsed_string($datetime, $full = false) { $now = new DateTime; $ago = new DateTime($datetime); $diff = $now->diff($ago); $diff->w = floor($diff->d / 7); $diff->d -= $diff->w * 7; $string = array( 'y' => 'year', 'm' => 'month', 'w' => 'week', 'd' => 'day', 'h' => 'hour', 'i' => 'minute', 's' => 'second', ); foreach ($string as $k => &$v) { if ($diff->$k) { $v = $diff->$k . ' ' . $v . ($diff->$k > 1 ? 's' : ''); } else { unset($string[$k]); } } if (!$full) $string = array_slice($string, 0, 1); return $string ? implode(', ', $string) . '' : 'just now'; } function toArrayInt($array_data) { $array_data = array_map( function ($value) { return (int)$value; }, $array_data ); return $array_data; } function isJson($string) { json_decode($string); return json_last_error() === JSON_ERROR_NONE; } function getGenderID($gender) { $gender = strtolower($gender); $gender_id = "0"; if ($this->isNotEmpty($gender)) { if (substr($gender, 0, 1) == "m") { $gender_id = "1"; } else if (substr($gender, 0, 1) == "f") { $gender_id = "2"; } } return $gender_id; } function getFileIcon($extension) { // $valid_ext_doc = array('pdf','doc','docx','txt','html','htm','ppt','pptx','xls','csv','xlsx'); // $valid_ext_img = array('png','jpeg','jpg'); // $valid_ext_vid = array('mp4','mkv','mov','avi','wmv'); switch ($extension) { case "jpg": case "jpeg": case "png": return "<i class='fa fa-file-image text-primary' aria-hidden='true'></i>"; break; case "mp4": case "mkv": case "mov": case "avi": case "wmv": return "<i class='fa fa-play text-danger' aria-hidden='true'></i>"; break; case "pdf": return "<i class='fa fa-file-pdf text-danger' aria-hidden='true'></i>"; break; case "txt": return "<i class='fa fa-file-text' aria-hidden='true'></i>"; break; case "doc": case "docx": return "<i class='fa fa-file-word text-primary ' aria-hidden='true'></i>"; break; case "ppt": case "pptx": return "<i class='fa fa-file-powerpoint text-warning' aria-hidden='true'></i>"; break; case "xls": case "csv": case "xlsx": return "<i class='fa fa-file-excel text-success' aria-hidden='true'></i>"; break; default: return "<i class='fa fa-file text-info'></i>"; } } function humanFileSize($size, $unit = "") { if ((!$unit && $size >= 1 << 30) || $unit == "GB") return number_format($size / (1 << 30), 2) . "GB"; if ((!$unit && $size >= 1 << 20) || $unit == "MB") return number_format($size / (1 << 20), 2) . "MB"; if ((!$unit && $size >= 1 << 10) || $unit == "KB") return number_format($size / (1 << 10), 2) . "KB"; return number_format($size) . " bytes"; } function isGetMethod($request) { if ($request != "GET") { return false; } return true; } function implodeQoutation(array $data) { if (count($data) <= 0) { return ''; } return implode(",", array_map(array($this, 'quoteString'), $data)); } function quoteString($string) { return sprintf("'%s'", $string); } function isNotEmpty($data) { return preg_match('/\S/', $data); } function convert_sql_date($data, $current_format) { if ($current_format == 'mm/dd/yyyy') { $parts = explode('/', $data); $yyyy_mm_dd = $parts[2] . '-' . $parts[0] . '-' . $parts[1]; return $yyyy_mm_dd; } else if ($current_format == 'dd/mm/yyyy') { $date = str_replace('/', '-', $data); return date('Y-m-d', strtotime($date)); } else { return ""; } } function alphaNumericOnly($s) { return preg_replace("/[^a-zA-Z0-9]+/", "", $s); } function fix_date($data, $format, $utility) { if ($utility->isNotEmpty($data)) { $fix_date = ""; if (count(explode("/", $data)) == 3) { $fix_date = $data; } else { if ($utility->isNotEmpty(strtotime($data))) { $fix_date = date("m/d/Y", strtotime($data)); //aha word date } } if ($utility->isNotEmpty($fix_date)) { // 01/23/2020 false // 23/01/2020 true $array_date = explode("/", explode(" ", $fix_date)[0]); if ($format) { //if format == true swap index 0 and 1 $return_date = $array_date[2] . '-' . $array_date[1] . '-' . $array_date[0]; } else { $return_date = $array_date[2] . '-' . $array_date[0] . '-' . $array_date[1]; } $return_date = date("Y-m-d", strtotime($return_date)); if ($this->validateDate($return_date)) { return $return_date; } } } return ""; } function upperCaseNestedArray($value) { if (is_array($value)) { return array_map(array($this, 'upperCaseNestedArray'), $value); } return trim(mb_strtoupper($value)); } // function removeEmptyValueArray($value) { // if (is_array($value)) { // return array_map(array($this, 'removeEmptyValueArray'), $value); // } // if($this->isNotEmpty()){ // } // return trim(strtoupper($value)); // } function lowerCaseNestedArray($value) { if (is_array($value)) { return array_map(array($this, 'lowerCaseNestedArray'), $value); } return trim(strtolower($value)); } function convert_sql_date_to_date_picker($value) { if (trim($value) == '') { return ''; } return date("m/d/Y", strtotime($value)); } function fix_mobile_format($data) { if (strlen($data) < 5) { return ""; } $final_data = ""; //if area code equal to 639xx it will change to 09xxxxxxxxx if (substr($data, 0, 2) === "09") { $final_data = "+639" . substr($data, 2, strlen($data)); } else if (substr($data, 0, 3) === "639") { $final_data = "+639" . substr($data, 3, strlen($data)); } else if (substr($data, 0, 1) === "9" && strlen($data) == 10) { $final_data = "+639" . substr($data, 1, strlen($data)); } else { $final_data = $data; } //if number start with 09xxx, check the length, if length is not 11 return blank, if not 09xxx return it if (substr($final_data, 0, 4) === "+639") { if (strlen($final_data) == 13) { return $final_data; } else { return (strlen($final_data) > 13) ? substr($final_data, 0, 13) : $final_data; } } return $final_data; } function fix_mobile_format_v2($data) { if (strlen($data) < 5) { return ""; } $final_data = ""; //if area code equal to 639xx it will change to 09xxxxxxxxx if (substr($data, 0, 2) === "09") { $final_data = "9" . substr($data, 2, strlen($data)); } else if (substr($data, 0, 3) === "639") { $final_data = "9" . substr($data, 3, strlen($data)); } else if (substr($data, 0, 1) === "9" && strlen($data) == 10) { $final_data = "9" . substr($data, 1, strlen($data)); } else { $final_data = $data; } //if number start with 09xxx, check the length, if length is not 11 return blank, if not 09xxx return it if (substr($final_data, 0, 1) === "9") { if (strlen($final_data) == 10) { return $final_data; } else { return (strlen($final_data) > 10) ? substr($final_data, 0, 10) : $final_data; } } return ''; } function remove_non_numeric($data) { return preg_replace("/[^0-9]/", "", $data); } function cleanStr($string) { $string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens. return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars. } function mask($str, $first, $last) { $str = $this->cleanStr($str); $len = strlen($str); $toShow = $first + $last; return substr($str, 0, $len <= $toShow ? 0 : $first) . str_repeat("*", $len - ($len <= $toShow ? 0 : $toShow)) . substr($str, $len - $last, $len <= $toShow ? 0 : $last); } function mask_email($email) { if (!$this->isNotEmpty($email)) { return ""; } $mail_parts = explode("@", $email); $domain_parts = explode('.', $mail_parts[1]); $mail_parts[0] = $this->mask($mail_parts[0], 2, 1); // show first 2 letters and last 1 letter $mail_parts[1] = implode('.', $domain_parts); return implode("@", $mail_parts); } function make_thumb($src, $dest, $desired_width) { /* read the source image */ $imgInfo = getimagesize($src); $mime = $imgInfo['mime']; // Create a new image from file switch ($mime) { case 'image/jpeg': $source_image = imagecreatefromjpeg($src); break; case 'image/png': $source_image = imagecreatefrompng($src); break; case 'image/gif': $source_image = imagecreatefromgif($src); break; default: $source_image = imagecreatefromjpeg($src); } $width = imagesx($source_image); $height = imagesy($source_image); /* find the "desired height" of this thumbnail, relative to the desired width */ $desired_height = floor($height * ($desired_width / $width)); /* create a new, "virtual" image */ $virtual_image = imagecreatetruecolor($desired_width, $desired_height); /* copy source image at a resized size */ imagecopyresampled($virtual_image, $source_image, 0, 0, 0, 0, $desired_width, $desired_height, $width, $height); /* create the physical thumbnail image to its destination */ switch ($mime) { case 'image/jpeg': imagejpeg($virtual_image, $dest); break; case 'image/png': imagepng($virtual_image, $dest); break; case 'image/gif': imagegif($virtual_image, $dest); break; default: imagejpeg($virtual_image, $dest); } } function curl_me($url, $params, $method, $headers = "[]") { $method = strtoupper($method); $ch = curl_init(); $headers = json_decode($headers, true); switch ($method) { case 'POST': curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($params)); break; case 'GET': break; default: curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($params)); } curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); if (count($headers) > 0) { curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); } $server_output = curl_exec($ch); curl_close($ch); return $server_output; } function curl_me_async($url, $params, $method) { $method = strtoupper($method); $ch = curl_init(); switch ($method) { case 'POST': curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($params)); break; case 'GET': break; default: curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($params)); } curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_FRESH_CONNECT, true); curl_setopt($ch, CURLOPT_TIMEOUT_MS, 500); // curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $server_output = curl_exec($ch); curl_close($ch); return $server_output; } function validateDate($date, $format = 'Y-m-d') { $d = DateTime::createFromFormat($format, $date); // The Y ( 4 digits year ) returns TRUE for any integer with any number of digits so changing the comparison from == to === fixes the issue. return $d && $d->format($format) === $date; } function arrayNullToBlank($array) { foreach ($array as $key => $value) { if (is_null($value)) { $array[$key] = ""; } } return $array; } function stringStartsWith($haystack, $needle, $case = true) { if ($case) { return strpos($haystack, $needle, 0) === 0; } return stripos($haystack, $needle, 0) === 0; } function stringEndsWith($haystack, $needle, $case = true) { $expectedPosition = strlen($haystack) - strlen($needle); if ($case) { return strrpos($haystack, $needle, 0) === $expectedPosition; } return strripos($haystack, $needle, 0) === $expectedPosition; } function encrypt($value) { //secured params //*domain as key //*url as token paramter //*unique encrypted id e.g.: userid 2 //*unique token given by source $plaintext = $value; $password = $_SERVER['HTTP_HOST']; //domain $method = 'aes-256-cbc'; $key = password_hash($password, PASSWORD_BCRYPT, ['cost' => 12]); // echo "Key:" . $key . "<br>"; // IV must be exact 16 chars (128 bit) $iv = chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0); // av3DYGLkwBsErphcyYp+imUW4QKs19hUnFyyYcXwURU= $encrypted = base64_encode(openssl_encrypt($plaintext, $method, $key, OPENSSL_RAW_DATA, $iv)); if (!$encrypted) { $arr['key'] = null; $arr['value'] = null; $arr['status'] = 0; $arr['message'] = "Error has occured, check your character encoding."; return json_encode($arr); } $arr['key'] = bin2hex($key); $arr['value'] = bin2hex($encrypted); $arr['message'] = "Successfully encrypted."; $arr['status'] = 1; return json_encode($arr); } function decrypt($key, $value) { //secured params //*domain as key //*url as token paramter //*unique encrypted id e.g.: userid 2 //*unique token given by source $plaintext = $value; $password = $_SERVER['HTTP_HOST']; //domain $method = 'aes-256-cbc'; $key = hex2bin($key); // echo "Key:" . $key . "<br>"; // IV must be exact 16 chars (128 bit) $iv = chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0) . chr(0x0); // av3DYGLkwBsErphcyYp+imUW4QKs19hUnFyyYcXwURU= $encrypted = hex2bin($value); //base64_encode(openssl_encrypt($plaintext, $method, $key, OPENSSL_RAW_DATA, $iv)); // My secret message 1234 $decrypted = openssl_decrypt(base64_decode($encrypted), $method, $key, OPENSSL_RAW_DATA, $iv); // $arr['key'] = bin2hex($key); if (!$decrypted) { $arr['value'] = null; $arr['status'] = 0; $arr['message'] = "Error has occured, check your key."; return json_encode($arr); } $arr['value'] = $decrypted; $arr['message'] = "Successfully decrypted."; $arr['status'] = 1; return json_encode($arr); } } sms_class.php 0000644 00000004514 15024755751 0007263 0 ustar 00 <?php class Sms { function iTextMo($array_data) { $array_data['body'] = $array_data['data']['json_parameters']; $array_data['http_header'] = $array_data['data']['headers']; $array_data['uri'] = $array_data['data']['base_url']; // $array_data['message'] = addslashes($array_data['message']); $array_data['message'] = strtr($array_data['message'], array("\n" => "\\n", "\r" => "\\r")); //clean $replace_parameter = array( '[no]' => $array_data['mobile'], '[msg]' => $array_data['message'], ); $final_template = strtr($array_data['body'], $replace_parameter); // $headers = json_decode($array_data['http_header'], true); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $array_data['uri']); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, json_decode($final_template, true)); // if (count($headers) > 0) { // curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); // } $result = curl_exec($ch); return $result; } function PhilSMS($array_data) { $array_data['body'] = $array_data['data']['json_parameters']; $array_data['http_header'] = $array_data['data']['headers']; $array_data['uri'] = $array_data['data']['base_url']; $array_data['message'] = strtr($array_data['message'], array("\n" => "\\n", "\r" => "\\r")); //clean $replace_parameter = array( '[no]' => $array_data['mobile'], '[msg]' => $array_data['message'], ); $final_template = strtr($array_data['body'], $replace_parameter); $headers = json_decode($array_data['http_header'], true); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $array_data['uri']); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $final_template); if (count($headers) > 0) { curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); } $result = curl_exec($ch); $response = json_decode($result, true); return $response['status'] == 201 ? 0 : $result; } function test($array_data) { return $array_data; } } brand_class.php 0000644 00000002132 15024755751 0007541 0 ustar 00 <?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Brand{ function read_brands($search,$brand_access_arr,$utility_class,$db){ $filter_brands_ids = (count($brand_access_arr) > 0) ? implode(",",$brand_access_arr) : "0" ; $filter_brands = " AND id IN ($filter_brands_ids) "; $query = "SELECT `id`, `name` FROM `vehicle_brands` WHERE name LIKE '%$search%' AND status = 1 $filter_brands ORDER BY name ASC;"; return $db->sql_query($query); } function read_brand_by_name($brand_name,$utility_class,$db){ $query = "SELECT * FROM `vehicle_brands` WHERE name = '$brand_name' AND status = 1 ORDER BY name ASC LIMIT 1;"; return $db->sql_query($query); } function read_brand_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `vehicle_brands` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function read_brand_ids($db){ $query = "SELECT id FROM `vehicle_brands` WHERE 1 AND `status` = 1"; return $db->sql_query($query); } } ?> user_class.php 0000644 00000104227 15024755751 0007441 0 ustar 00 <?php class User{ function read_id_number_count($id_no,$utility_class,$db){ return $db->sql_query_num_rows("SELECT id FROM lms2_users WHERE id_number = '$id_no' AND status = 1"); } function read_email_count($email,$utility_class,$db){ return $db->sql_query_num_rows("SELECT lu.id FROM lms2_user_contacts luc INNER JOIN lms2_users lu ON luc.user_id = lu.id WHERE luc.email = '$email' AND lu.status = 1"); } function read_mobile_count($mobile,$utility_class,$db){ return $db->sql_query_num_rows("SELECT lu.id FROM lms2_user_contacts luc INNER JOIN lms2_users lu ON luc.user_id = lu.id WHERE luc.mobile = '$mobile' AND lu.status = 1"); } function read_position_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `user_positions` WHERE name = '$name' AND status = 1 LIMIT 1;"; return $db->select($query); } function insert_user_details($array_data,$utility_class,$db){ $query = "INSERT INTO `lms2_users`( `id_number`,`default_position_id`, `default_dealer_id`, `firstname`, `lastname`, `date_added`, `status`) VALUES ('".$array_data['id_no']."','".$array_data['position']."','".$array_data['dealer']."','".$array_data['firstname']."','".$array_data['lastname']."',NOW(),'1')"; $inserted_user_id = $db->sql_query_id($query); $query_contact = "INSERT INTO `lms2_user_contacts`(`user_id`, `mobile`, `email`) VALUES ('$inserted_user_id','".$array_data['mobile']."','".$array_data['email']."')"; $inserted_user_contact_count = $db->sql_query_affected_rows($query_contact); $hash_password = password_hash(md5($array_data['password']), PASSWORD_DEFAULT); $query_account = "INSERT INTO `lms2_user_accounts`( `user_id`, `username`, `password`, `is_active_account`) VALUES ('$inserted_user_id','".$array_data['id_no']."','$hash_password','0')"; $inserted_user_account_count = $db->sql_query_affected_rows($query_account); return intval($inserted_user_contact_count + $inserted_user_account_count); } function read_user_status($array_data,$utility_class,$db){ } function read_user_account_status($array_data,$utility_class,$db){ } function insert_temporary_role($array_data,$user_id,$utility_class,$db){ $query_insert_role = "INSERT INTO `lms2_roles`( `status`) VALUES (0)"; $role_id = $db->sql_query_id($query_insert_role); $query_insert_role_access = "INSERT INTO `lms2_role_access`( `role_id`, `json_dealers`, `json_menus`) VALUES ($role_id,'[]','[]')"; $db->sql_query($query_insert_role_access); return $role_id; } function delete_temporary_role($array_data,$user_id,$utility_class,$db){ $query_remove_role_access = "DELETE FROM `lms2_role_access` WHERE role_id = ".$array_data['id'].""; $db->sql_query($query_remove_role_access); $query_remove_role = "DELETE FROM `lms2_roles` WHERE id = ".$array_data['id'].""; return $db->sql_query_affected_rows($query_remove_role); } function update_role($user_id,$role_id,$name,$utility_class,$db){ $query_update_role = "UPDATE `cnf_roles` SET `name`=NULLIF('".$name."','') WHERE id = $role_id"; $db->sql_query_affected_rows($query_update_role); } function update_role_access($role_id,$role_data,$brand_data,$json_dealer,$category_id,$utility_class,$db){ $query = "UPDATE `cnf_role_access` SET `json_access`= NULLIF('$role_data',''), `json_brand`= NULLIF('$brand_data',''), `json_dealer`= NULLIF('$json_dealer',''), `user_category_id`= NULLIF('$category_id','') WHERE `role_id` = $role_id"; return $db->sql_query_affected_rows($query); } function read_role_dealers($role_id ,$utility_class,$db){ $query = "SELECT `json_dealers` FROM `lms2_role_access` WHERE `role_id` = $role_id LIMIT 1"; return $db->select($query); } function update_role_dealers($role_id,$role_dealers,$utility_class,$db){ $query = "UPDATE `lms2_role_access` SET `json_dealers`= '$role_dealers' WHERE `role_id` = $role_id"; return $db->sql_query_affected_rows($query); } function update_role_menus($role_id,$role_menus,$utility_class,$db){ $query = "UPDATE `lms2_role_access` SET `json_menus`= '$role_menus' WHERE `role_id` = $role_id"; return $db->sql_query_affected_rows($query); } function role_dealer_list($array_data,$utility_class,$db){ // $offset_limit = "LIMIT ".$array_data['offset'].",".$array_data['limit']." "; $offset_limit = ""; $field = " c.id as c_id, c.code as c_code, c.name as c_name, d.id as d_id, d.code as d_code, d.name as d_name "; $field_count = " COUNT(1) "; $query = "SELECT %s FROM `lms2_companies` c INNER JOIN lms2_dealers d ON c.id = d.company_id WHERE 1 AND (CONCAT(c.code,' ',c.name) LIKE '%%%s%%' OR CONCAT(d.code,' ',d.name) LIKE '%%%s%%') AND c.status = 1 AND d.status = 1 ORDER BY d.name ASC %s "; $query_formatted = sprintf( $query, $field, $array_data['search'], $array_data['search'], $offset_limit ); $query_formatted_count = sprintf( $query, $field_count, $array_data['search'], $array_data['search'], '' ); // echo $query_formatted;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function get_user_notification_info($user_id,$utility_class,$db){ $query = " SELECT nt.id,COUNT(nt.id) as total,nt.name , MAX(nl.date_added) ago_time FROM `lms2_notification_type` nt INNER JOIN lms2_notification_list nl ON nt.id = nl.notification_type_id WHERE 1 AND nt.status = 1 AND nl.status = 1 AND nl.is_read = 0 AND nl.to_user = $user_id GROUP BY nt.id ORDER BY nl.date_added DESC"; return $db->sql_query($query); } function read_user_notification($user_id,$offset,$limit,$utility_class,$db){ $offset_limit = "LIMIT 0,".$limit." "; // $offset_limit = "LIMIT ".$offset.",".$limit." "; $is_read = " AND cl.`is_read` = 0 "; $fields = " cl.`id`, cl.target_id, cl.`template_id`, cl.`from_user_id`, cl.`to_user_id`, cl.`date_added`, cl.is_read, cl.type, cnt.description "; $count = " COUNT(1) "; $query = " SELECT %s FROM `cnf_notification_list` cl INNER JOIN cnf_notification_templates cnt ON cl.`template_id` = cnt.id WHERE 1 %s AND cl.`status` = 1 AND `to_user_id` = $user_id ORDER BY cl.date_added DESC %s "; $query_formatted = sprintf($query,$fields,$is_read,$offset_limit); // echo $query_formatted;exit; // $query_formatted_count = sprintf($query,$count,'',''); $query_formatted_count = sprintf($query,$count,$is_read,$offset_limit); // // echo $query_formatted;exit; // return $db->sql_query($query_formatted); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_notification_template_by_id($id,$utility_class,$db){ $query = "SELECT description FROM `cnf_notification_templates` WHERE 1 AND id = $id LIMIT 1"; return $db->select($query); } function read_user_notification_count($user_id,$utility_class,$db){ $query = " SELECT COUNT(1) FROM `cnf_notification_list` cl INNER JOIN cnf_notification_templates cnt ON cl.`template_id` = cnt.id WHERE 1 AND cl.`is_read` = 0 AND cl.`status` = 1 AND `to_user_id` = $user_id ORDER BY cl.date_added DESC "; return $db->select($query); } function get_user_notification_list($user_id,$type_id,$offset,$limit,$utility_class,$db){ $notif_type = ""; if(intval($type_id)){ $notif_type = " AND nl.`notification_type_id` = $type_id "; } $query = "SELECT u1.firstname,u1.lastname,nl.`id` as notif_id, nl.`notification_type_id`, nl.`description`, nl.`date_added`, nl.`is_read`, nl.target_id, DATE_FORMAT(nl.date_added,'%%M %%d, %%Y %%h:%%i %%p') as date_addedf FROM `lms2_notification_list` nl INNER JOIN lms2_users u1 ON nl.`from_user` = u1.id WHERE 1 AND nl.status = 1 AND nl.`to_user` = %s %s /*type_id*/ ORDER BY nl.`date_added` DESC LIMIT %s,%s"; $query_final = sprintf($query,$user_id,$notif_type,$offset,$limit); // echo $query; return $db->sql_query($query_final); } function mark_as_read_notification($user_id,$type_id,$utility_class,$db){ $notif_type = ""; if(intval($type_id)){ $notif_type = " AND `notification_type_id` = $type_id "; } $query = "UPDATE `lms2_notification_list` SET `is_read`=1 WHERE 1 AND `to_user` = %s %s"; $query_final = sprintf($query,$user_id,$notif_type); // echo $query_final; return $db->sql_query($query_final); } function read_active_api($utility_class,$db){ $query = "SELECT * FROM `cnf_sms_api` WHERE `is_activated` = 1 AND `status` = 1"; return $db->sql_query($query); } function read_user_by_category_id_and_brand_id($category_id,$brand_id,$db){ $query = "SELECT u.*,uc.mobile,uc.email FROM users u INNER JOIN user_accounts ua ON u.id = ua.user_id INNER JOIN user_contacts uc ON u.id = uc.user_id INNER JOIN cnf_roles cr ON ua.role_id = cr.id INNER JOIN cnf_role_access cra ON cr.id = cra.role_id WHERE 1 AND cra.user_category_id = $category_id AND JSON_CONTAINS(cra.json_brand,'\"$brand_id\"','$') = 1 AND cra.json_brand IS NOT NULL GROUP BY u.id "; return $db->sql_query($query); } function read_positions($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `user_positions` WHERE name LIKE '%$search%' AND status = 1 ORDER BY name ASC;"; return $db->sql_query($query); } function read_notification_type_if_active($type_id,$db){ $query = "SELECT is_active FROM `cnf_notification_templates` WHERE 1 AND id = $type_id LIMIT 1"; return intval($db->select($query)); } function create_user_notification($notification_type_id,$from_user_id,$to_user_id,$target_id,$type,$utility_class,$db){ $query = "INSERT INTO `cnf_notification_list`(`template_id`, `from_user_id`, `to_user_id`, `target_id`, `date_added`, `is_read`, `status`,`type`) VALUES (NULLIF('$notification_type_id',''),NULLIF('$from_user_id',''),NULLIF('$to_user_id',''),NULLIF('$target_id',''),NOW(),0,1,NULLIF('$type',''))"; return $db->sql_query_id($query); } function role_list($array_data,$utility_class,$db){ // $offset_limit = "LIMIT ".$array_data['offset'].",".$array_data['limit']." "; $offset_limit = ""; $field = " r.`id`, r.`name`, (SELECT COUNT(1) FROM lms2_users su INNER JOIN lms2_user_accounts sus ON su.id = sus.user_id WHERE sus.role_id = r.id AND su.status = 1 AND sus.is_active_account = 1) as user_count,ra.json_menus "; $field_count = " COUNT(1) "; $query = "SELECT %s FROM `lms2_roles` r LEFT OUTER JOIN lms2_role_access ra ON r.id = ra.role_id WHERE 1 AND r.name LIKE '%%%s%%' AND r.status = 1 ORDER BY r.name ASC %s "; $query_formatted = sprintf( $query, $field, $array_data['search'], $offset_limit ); $query_formatted_count = sprintf( $query, $field_count, $array_data['search'], '' ); // echo $query_formatted_count;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function update_notification_status($target_id,$to_user_id,$is_read,$db){ $query = "UPDATE cnf_notification_list SET is_read = $is_read WHERE target_id = $target_id AND to_user_id = $to_user_id"; $db->sql_query($query); } function read_user_information($user_id,$db){ $query = "SELECT u.* FROM `users` u WHERE 1 AND u.id = $user_id "; return $db->sql_query($query); } function system_user_security($where_statement,$array_data,$source,$utility_class,$db){ //check user status $query = "SELECT u.`id`, u.`gender_id`, u.`id_number`, u.`position_id`, CONCAT(u.`firstname`, ' ', u.`lastname`) as fullname ,u.`firstname`, u.`middlename`, u.`lastname`, u.`birthday`, u.`avatar`, u.`date_added`, u.`status`, uc.`mobile`, uc.`email`, uc.`address`, uc.`city_id`, uc.`facebook`, uc.`instagram`, uc.`whatsapp`, uc.`viber`, uc.`linkedin`, ua.`username`, ua.`password`, ua.`is_active`,cra.json_access,cra.json_brand,ua.role_id FROM users u INNER JOIN user_contacts uc ON u.id = uc.user_id INNER JOIN user_accounts ua ON u.id = ua.user_id LEFT OUTER JOIN cnf_roles cr ON ua.role_id = cr.id LEFT OUTER JOIN cnf_role_access cra ON cr.id = cra.role_id WHERE 1 %s "; // echo sprintf($query,$where_statement);exit; $user_information_obj = $db->sql_query(sprintf($query,$where_statement)); $user_information = array(); foreach($user_information_obj as $row){ // print_r($row);exit; $user_information = $row; } if(count($user_information) > 0){ //check password if($source == 'login'){ $md5_password = md5($array_data['password']); if (!password_verify($md5_password, $user_information['password'])) { $return_arr['message'] = "Invalid password."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } } if (intval($user_information['status']) !== 1) { $return_arr['message'] = "Your account is deactivated."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } if (intval($user_information['is_active']) !== 1) { $return_arr['message'] = "Your account is not yet approved."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } // $json_dealers = array(); // //merge dealers // if($utility_class->isJson($user_information['json_dealers'])){ // $json_dealers = json_decode($user_information['json_dealers']); // } // if($utility_class -> isNotEmpty($user_information['default_dealer_id'])){ // $json_dealers = array_merge($json_dealers,array($user_information['default_dealer_id'])); // } // $json_dealers = $utility_class -> toArrayInt($json_dealers); $json_access = array(); if($utility_class->isJson($user_information['json_access'])){ $json_access = json_decode($user_information['json_access'],true); } $json_brand = array(); if($utility_class->isJson($user_information['json_brand'])){ $json_brand = json_decode($user_information['json_brand'],true); } $json_brand = $utility_class -> toArrayInt($json_brand); //merge dealers to session // $user_information = array_merge($user_information,array('dealer_access'=>$json_dealers),array('menu_access'=>$json_menus)); $user_information = array_merge($user_information,array('json_brand'=>$json_brand),array('json_access'=>$json_access)); $_SESSION['cc_user'] = $user_information; // echo ($_SESSION['cc_user']['role_id']);exit; $display_name = $user_information['firstname']. ' '.substr($user_information['lastname'],0,1); // echo ; // if($source == 'login'){ $return_arr['id'] = $user_information['id']; $return_arr['message'] = "Welcome ".ucwords(strtolower($display_name))."."; // $return_arr['data'] = $user_information; $return_arr['status'] = 1; return $return_arr; // echo json_encode($return_arr); // exit; // } }else{ $return_arr['message'] = "No account associated with this credentials."; $return_arr['status'] = 0; return $return_arr; // echo json_encode($return_arr); // exit; } } function update_all_sms_config_api_status($status,$utility_class,$db){ $query = "UPDATE `cnf_sms_api` SET `is_activated`=$status WHERE 1"; $db->sql_query($query); } function update_sms_config_api_status($sms_api_id,$status,$utility_class,$db){ $query = "UPDATE `cnf_sms_api` SET `is_activated`=$status WHERE 1 AND id = $sms_api_id"; $db->sql_query($query); } function update_sms_config_template($template_id,$value,$utility_class,$db){ $query = "UPDATE `cnf_sms_templates` SET `description`=NULLIF('$value','') WHERE 1 AND id = $template_id"; $db->sql_query($query); } function update_notification_template($template_id,$name,$value,$is_active,$utility_class,$db){ $query = "UPDATE `cnf_notification_templates` SET `name` = NULLIF('$name',''),`description`=NULLIF('$value',''),`is_active`=NULLIF('$is_active','') WHERE 1 AND id = $template_id"; $db->sql_query($query); } function read_notification_by_id($id,$db){ $query = "SELECT * FROM `cnf_notification_templates` WHERE 1 AND `id` = $id"; return $db->sql_query($query); } function insert_notification_template($template_id,$name,$value,$is_active,$utility_class,$db){ $query = "INSERT INTO `cnf_notification_templates`(`id`, `name`, `description`, `is_active`,`status`) VALUES ($template_id,NULLIF('$name',''),NULLIF('$value',''),NULLIF('$is_active',''),1)"; $db->sql_query($query); } function read_system_config($utility_class,$db){ $query = "SELECT * FROM `cnf_system` WHERE 1"; return $db->sql_query($query); } function read_sms_templates($utility_class,$db){ $query = "SELECT * FROM `cnf_sms_templates` WHERE 1 AND status = 1"; return $db->sql_query($query); } function read_notification_template($utility_class,$db){ $query = "SELECT * FROM `cnf_notification_templates` WHERE 1 AND status = 1"; return $db->sql_query($query); } function read_notification_reminder($utility_class,$db){ $query = "SELECT * FROM `cnf_reminder_times` WHERE 1 "; return $db->sql_query($query); } function read_notification_reminder_by_type($type,$utility_class,$db){ $query = "SELECT * FROM `cnf_reminder_times` WHERE 1 AND type=$type"; return $db->sql_query($query); } function remove_role($id,$utility_class,$db){ $query = "UPDATE `cnf_roles` SET `status`=0 WHERE id = $id"; $affected_rows = $db->sql_query_affected_rows($query); return intval($affected_rows); } function update_system_config($array_data,$utility_class,$db){ $url = $array_data['url']; $url = ($utility_class->stringStartsWith($url,'http://') || $utility_class->stringStartsWith($url,'https://')) ? $url : 'https://'.$url ; $url = $utility_class->stringEndsWith($url,'/') ? $url : $url.'/' ; $query = "UPDATE `cnf_system` SET `value`='$url' WHERE `name` = 'url' "; $db->sql_query($query); //NAME $name = $array_data['name']; $query = "UPDATE `cnf_system` SET `value`='$name' WHERE `name` = 'name' "; $db->sql_query($query); } function role_universal_query(){ return "SELECT %s FROM `cnf_roles` cr INNER JOIN cnf_role_access cra ON cr.id = cra.role_id LEFT OUTER JOIN user_categories uc ON cra.user_category_id = uc.id WHERE 1 "; } function read_role_information($role_id,$utility_class,$db){ $role_universal_query = $this->role_universal_query(); $fields = " cr.id,cr.name,(SELECT COUNT(1) FROM users su INNER JOIN user_accounts sus ON su.id = sus.user_id WHERE sus.role_id = cr.id AND su.status = 1 AND sus.is_active = 1) as user_count, cra.json_access, cra.json_dealer, uc.name as user_category "; $query = $role_universal_query." AND cr.id = %s AND cr.status = 1"; $query_formatted = sprintf($query,$fields,$role_id); return $db->sql_query($query_formatted); } function read_role_list($user_id,$search,$offset,$limit,$utility_class,$db){ $role_universal_query = $this->role_universal_query(); $offset_limit = "LIMIT ".$offset.",".$limit." "; $fields = " cr.id,cr.name,(SELECT COUNT(1) FROM users su INNER JOIN user_accounts sus ON su.id = sus.user_id WHERE sus.role_id = cr.id AND su.status = 1 AND sus.is_active = 1) as user_count, cra.json_access, cra.json_dealer, cra.json_brand, uc.name as user_category "; $count = " COUNT(1) "; $query = $role_universal_query." AND cr.name LIKE '%%%s%%' AND cr.status = 1 ORDER BY name ASC %s"; $query_formatted = sprintf($query,$fields,$search,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_role_brand_list($user_id,$search,$offset,$limit,$utility_class,$db){ $offset_limit = "LIMIT ".$offset.",".$limit." "; $fields = " `id`, `name` "; $count = " COUNT(1) "; $query = "SELECT %s FROM `vehicle_brands` WHERE 1 AND name LIKE '%%%s%%' AND status = 1 ORDER BY name ASC %s"; $query_formatted = sprintf($query,$fields,$search,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_position_list($user_id,$search,$offset,$limit,$utility_class,$db){ $offset_limit = "LIMIT ".$offset.",".$limit." "; $fields = " `id`, `name` "; $count = " COUNT(1) "; $query = "SELECT %s FROM `user_positions` WHERE 1 AND name LIKE '%%%s%%' AND status = 1 ORDER BY name ASC %s"; $query_formatted = sprintf($query,$fields,$search,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_category_id_by_name($name,$utility_class,$db){ $query = "SELECT `id` FROM `user_categories` WHERE 1 AND name = '$name' AND status = 1 LIMIT 1"; return $db->select($query); } function read_role_count_by_name($name,$utility_class,$db){ $query = "SELECT COUNT(1) FROM `cnf_roles` WHERE 1 AND name = '$name' AND status = 1"; return $db->select($query); } function create_role($user_id,$name,$utility_class,$db){ $query = "INSERT INTO `cnf_roles`(`name`, `user_id`, `date_added`, `status`) VALUES ('$name',$user_id,NOW(),1)"; return $db->sql_query_id($query); } function create_role_access($role_id,$role_data,$brand_data,$json_dealer,$category_id,$utility_class,$db){ $query = "INSERT INTO `cnf_role_access`( `role_id`, `json_access`, `json_brand`, `json_dealer`, `user_category_id`) VALUES ($role_id,NULLIF('$role_data',''),NULLIF('$brand_data',''),NULLIF('$json_dealer',''),NULLIF('$category_id',''))"; return $db->sql_query_id($query); } function read_user_categories($search,$utility_class,$db){ $query = "SELECT `id`, `name` FROM `user_categories` WHERE name LIKE '%$search%' AND status = 1 ORDER BY id ASC;"; return $db->sql_query($query); } function read_sms_apis($search,$utility_class,$db){ $query = "SELECT * FROM `cnf_sms_api` WHERE 1 AND `status` = 1 ORDER BY `name` ASC"; return $db->sql_query($query); } function read_user_by_source_id($user_source_id,$utility_class,$db){ $query = "SELECT * FROM `users` WHERE 1 AND `source_id` = $user_source_id"; return $db->sql_query($query); } function create_user_api($user_source_id,$user_source,$id_number,$position_id,$dealer_id,$firstname,$middlename,$lastname,$utility_class,$db){ $query = "INSERT INTO `users`(`id_number`, `position_id`,`dealer_id`, `firstname`, `middlename`, `lastname`, `date_added`, `status`, `source`, `source_id`) VALUES (NULLIF('$id_number',''),NULLIF('$position_id',''),NULLIF('$dealer_id',''),NULLIF('$firstname',''),NULLIF('$middlename',''),NULLIF('$lastname',''),NOW(),1,NULLIF('$user_source',''),NULLIF('$user_source_id',''))"; return $db->sql_query_id($query); } function create_user_contact_api($user_id,$mobile,$email,$utility_class,$db){ $query = "INSERT INTO `user_contacts`(`user_id`, `mobile`, `email`) VALUES (NULLIF('$user_id',''),NULLIF('$mobile',''),NULLIF('$email',''))"; $db->sql_query($query); } function create_user_account_api($user_id,$username,$password,$utility_class,$db){ $query = "INSERT INTO `user_accounts`(`user_id`, `username`, `password`, `is_active`) VALUES (NULLIF('$user_id',''),NULLIF('$username',''),NULLIF('$password',''),1)"; $db->sql_query($query); } function update_user_api($user_id,$user_source_id,$user_source,$id_number,$position_id,$dealer_id,$firstname,$middlename,$lastname,$utility_class,$db){ $query = "UPDATE `users` SET `id_number`=NULLIF('$id_number',''),`position_id` = NULLIF('$position_id',''),`dealer_id`=NULLIF('$dealer_id',''),`firstname`=NULLIF('$firstname',''),`middlename`=NULLIF('$middlename',''),`lastname`=NULLIF('$lastname','') WHERE 1 AND id = $user_id"; return $db->sql_query_id($query); } function update_user_contact_api($user_id,$mobile,$email,$utility_class,$db){ $query = "UPDATE `user_contacts` SET `mobile`=NULLIF('$mobile',''),`email`=NULLIF('$email','') WHERE 1 AND user_id = $user_id "; $db->sql_query($query); } function update_user_account_api($user_id,$username,$password,$utility_class,$db){ $query = "UPDATE `user_accounts` SET `username`=NULLIF('$username',''),`password`=NULLIF('$password','') WHERE 1 AND user_id = $user_id"; $db->sql_query($query); } function create_user_login_token($user_id,$added_by_user_id,$source_id,$token,$type,$utility_class,$db){ $query = "INSERT INTO `user_login_token`(`added_by_user_id`,`user_id`, `source_id`, `token`, `type`, `date_added`, `status`) VALUES ($added_by_user_id,$user_id,$source_id,'$token',$type,NOW(),1)"; $db->sql_query($query); } function read_roles($search,$no_admin,$utility_class,$db){ $query = "SELECT * FROM `cnf_roles` WHERE 1 AND name LIKE '%$search%' AND status = 1 $no_admin ORDER BY name"; return $db->sql_query($query); } function read_role_id_by_name($name,$utility_class,$db){ return $db->select("SELECT id FROM `cnf_roles` WHERE 1 AND name = '$name' AND status = 1 LIMIT 1"); } function user_universal_query(){ return "SELECT %s FROM `users` u INNER JOIN user_contacts uc ON u.id = uc.user_id INNER JOIN user_accounts ua ON u.id = ua.user_id LEFT OUTER JOIN cnf_roles r ON ua.role_id = r.id LEFT OUTER JOIN user_positions up ON u.position_id = up.id WHERE 1"; } function create_api_notifications($array_data,$utility_class,$db){ $target_json = $array_data['target_json']; $target_id = $array_data['target_id']; $api_type = $array_data['api_type']; $data_type = $array_data['data_type']; $query="INSERT INTO `cnf_api_notifications`(`target_json`, `target_id`, `api_type`, `data_type`, `date_added`, `status`) VALUES (NULLIF('$target_json',''),NULLIF('$target_id',''),NULLIF('$api_type',''),NULLIF('$data_type',''),NOW(),1)"; $db->sql_query($query); } function update_user_role($user_id,$role_id,$db){ $query = "UPDATE `user_accounts` SET `role_id`=NULLIF('$role_id','') WHERE 1 AND user_id = $user_id"; $db->sql_query($query); } function read_user_list($user_id,$role_id,$no_admin,$search,$offset,$limit,$utility_class,$db){ $user_universal_query = $this->user_universal_query(); $offset_limit = "LIMIT ".$offset.",".$limit." "; if($utility_class->isNotEmpty($role_id)){ if($role_id === 0){ $role_filter = $utility_class->isNotEmpty($role_id) ? " AND r.id IS NULL " : '' ; }else{ $role_filter = $utility_class->isNotEmpty($role_id) ? " AND r.id IN ($role_id) " : '' ; } }else{ $role_filter = ''; } $fields = " u.id,CONCAT(u.firstname,' ',u.lastname) as name,u.id_number,uc.mobile,uc.email,r.id as role_id, r.name as role,up.name as position"; $count = " COUNT(1) "; $query = $user_universal_query." AND CONCAT(u.id_number,' ',u.firstname,' ',u.lastname,' ',uc.mobile,' ',uc.email) LIKE '%%%s%%' %s /*role_filter*/ %s /*filter admin*/ AND u.status = 1 %s /*offset Limit*/"; $query_formatted = sprintf($query,$fields,$search,$role_filter,$no_admin,$offset_limit); // echo $query_formatted;exit; $query_formatted_count = sprintf($query,$count,$search,$role_filter,$no_admin,''); return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function read_user_position_by_name($name,$utility_class,$db){ $query = "SELECT * FROM `user_positions` WHERE 1 AND name = '$name' LIMIT 1"; return $db->sql_query($query); } function create_user_position($user_id,$name,$code,$rank_level,$utility_class,$db){ $query = "INSERT INTO `user_positions`( `name`, `rank`,`code`, `user_id`, `date_added`, `status`) VALUES (NULLIF('$name',''),NULLIF('$rank_level',''),NULLIF('$code',''),NULLIF('$user_id',''),NOW(),1)"; return $db->sql_query_id($query); } function update_user_position($user_id,$position_id,$name,$code,$rank_level,$utility_class,$db){ $query = "UPDATE `user_positions` SET `name`=NULLIF('$name','') WHERE 1 AND id = $position_id"; $db->sql_query($query); } function update_reminder_times($reminder_data,$utility_class,$db){ $q = 'INSERT INTO `cnf_reminder_times`(`type`, `minutes`, `hours`, `days`) VALUES '.implode(",",$reminder_data).' ON DUPLICATE KEY UPDATE minutes = VALUES (minutes), hours = VALUES (hours), days = VALUES (days) '; return $db->sql_query_affected_rows($q); } function update_user_login_token_status($user_id,$status,$type,$utility_class,$db){ $query = "UPDATE user_login_token SET status = $status WHERE user_id = $user_id AND type = $type"; $db->sql_query($query); } function read_user_login_token($token,$type,$status,$db){ $query = "SELECT * FROM `user_login_token` WHERE `token` = '$token' AND `type` = $type AND `status` = $status LIMIT 1"; return $db->sql_query($query); } function read_viber_subscription($user_id,$utility_class,$db){ $query = "SELECT * FROM `cnf_api_token_ids` WHERE 1 AND `status` = 1 AND `is_subscribe` = 1 AND `user_id` = $user_id AND type = 1 LIMIT 1"; return $db->sql_query($query); } } knowledgebase_class.php 0000644 00000120344 15024755751 0011273 0 ustar 00 <?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Knowledgebase{ function create_knowledgebase($user_id,$sub_category_id,$section_id,$title,$description,$codes,$utility_class,$db){ $query = "INSERT INTO `knowledgebase`( `user_id`, `sub_category_id`,`section_id`, `title`, `description`,`fault_codes`, `date_added`, `status`) VALUES (NULLIF('$user_id',''),'$sub_category_id',NULLIF('$section_id',''),'$title','$description',NULLIF('$codes',''),NOW(),1)"; return $db->sql_query_id($query); } function read_vehicle_type_knowledgebase($knowledgebase_id,$utility_class,$db){ $query = "SELECT * FROM `knowledgebase_type_vehicles` WHERE 1 AND knowledgebase_id = $knowledgebase_id"; return $db->sql_query($query); } function update_knowledgebase($knowledgebase_id,$user_id,$sub_category_id,$section_id,$title,$description,$codes,$utility_class,$db){ $query = "UPDATE `knowledgebase` SET `sub_category_id`=$sub_category_id,section_id = NULLIF('$section_id',''),`title`='$title',`description`='$description',`fault_codes`=NULLIF('$codes','') WHERE 1 AND id = $knowledgebase_id"; // echo $query;exit; $db->sql_query($query); } function update_knowledgebase_attachment_status($ids,$status,$utility_class,$db){ $query = "UPDATE `knowledgebase_attachments` SET status = $status WHERE 1 AND `id` IN ($ids)"; return $db->sql_query_id($query); } function update_video_attachment_status($ids,$status,$utility_class,$db){ $query = "UPDATE `video_attachments` SET status = $status WHERE 1 AND `id` IN ($ids)"; return $db->sql_query_id($query); } function update_vehicle_type_knowledgebase($knowledgebase_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db){ $query = "UPDATE `knowledgebase_type_vehicles` SET `brand_id`=NULLIF('$brand_id',''),`model_id`=NULLIF('$model_id',''),`model_variant_id`=NULLIF('$model_variant_id',''),`status`=1 WHERE 1 AND knowledgebase_id = $knowledgebase_id "; // echo $query;exit; $db->sql_query($query); } function update_vehicle_type_knowledgebase_status($knowledgebase_id,$status,$utility_class,$db){ $query = "UPDATE `knowledgebase_type_vehicles` SET status = $status WHERE 1 AND knowledgebase_id = $knowledgebase_id"; $db->sql_query($query); } function read_video_attachments($video_id,$utility_class,$db){ $query = "SELECT *,DATE_FORMAT(date_added, '%M %d, %Y') as date_addedf FROM `video_attachments` WHERE 1 AND `video_id` = $video_id AND status = 1"; // echo $query;exit; return $db->sql_query($query); } function create_vehicle_type_knowledgebase($knowledgebase_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db){ $query = "INSERT INTO `knowledgebase_type_vehicles`( `knowledgebase_id`, `brand_id`, `model_id`,`model_variant_id`,`status`) VALUES ('$knowledgebase_id',NULLIF('$brand_id',''),NULLIF('$model_id',''),NULLIF('$model_variant_id',''),1)"; // echo $query;exit; return $db->sql_query_id($query); } function create_knowledgebase_attachment($knowledgebase_id,$attachment_change_name,$attachment_orig_name,$utility_class,$db){ $query = "INSERT INTO `knowledgebase_attachments`(`knowledgebase_id`, `attachment_name`, `original_name`, `date_added`, `status`) VALUES ($knowledgebase_id,'$attachment_change_name','$attachment_orig_name',NOW(),1)"; // echo $query;exit; return $db->sql_query_id($query); } function create_video_attachment($video_id,$attachment_change_name,$attachment_orig_name,$utility_class,$db){ $query = "INSERT INTO `video_attachments`(`video_id`, `attachment_name`, `original_name`, `date_added`, `status`) VALUES ($video_id,'$attachment_change_name','$attachment_orig_name',NOW(),1)"; // echo $query;exit; return $db->sql_query_id($query); } function create_video($user_id,$sub_category_id,$section_id,$title,$description,$codes,$original_name,$attachment_name,$utility_class,$db){ $query = "INSERT INTO `videos`( `user_id`, `sub_category_id`,section_id, `title`, `description`,`fault_codes`, `original_name`, `attachment_name`, `date_added`, `status`) VALUES (NULLIF('$user_id',''),'$sub_category_id',NULLIF('$section_id',''),'$title','$description',NULLIF('$codes',''),'$original_name','$attachment_name',NOW(),1)"; return $db->sql_query_id($query); } function create_vehicle_type_video($video_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db){ $query = "INSERT INTO `video_type_vehicles`( `video_id`, `brand_id`, `model_id`,`model_variant_id`,`status`) VALUES ('$video_id',NULLIF('$brand_id',''),NULLIF('$model_id',''),NULLIF('$model_variant_id',''),1)"; // echo $query;exit; return $db->sql_query_id($query); } function update_video($video_id,$user_id,$sub_category_id,$section_id,$title,$description,$codes,$utility_class,$db){ $query = "UPDATE `videos` SET `sub_category_id`=$sub_category_id,section_id = NULLIF('$section_id',''),`title`='$title',`description`='$description',`fault_codes`=NULLIF('$codes','') WHERE 1 AND id = $video_id"; // echo $query;exit; $db->sql_query($query); } function update_vehicle_type_video($video_id,$brand_id,$model_id,$model_variant_id,$utility_class,$db){ $query = "UPDATE `video_type_vehicles` SET `brand_id`=NULLIF('$brand_id',''),`model_id`=NULLIF('$model_id',''),`model_variant_id`=NULLIF('$model_variant_id',''),`status`=1 WHERE 1 AND video_id = $video_id "; // echo $query;exit; $db->sql_query($query); } function update_vehicle_type_video_status($video_id,$status,$utility_class,$db){ $query = "UPDATE `video_type_vehicles` SET status = $status WHERE 1 AND video_id = $video_id"; $db->sql_query($query); } function read_vehicle_type_video($video_id,$utility_class,$db){ $query = "SELECT * FROM `video_type_vehicles` WHERE 1 AND video_id = $video_id"; return $db->sql_query($query); } function read_video_list($user_id,$array_data,$position_id_arr,$owned_video_only,$category_ids_str,$brand_id, $model_id,$section_id,$brand_access_arr,$search,$offset,$limit,$utility_class,$db){ $category_ids_str = $utility_class->isNotEmpty($category_ids_str) ? " AND v.sub_category_id IN ($category_ids_str) " : '' ; $brand = $utility_class->isNotEmpty($brand_id) ? " AND vtv.brand_id IN ($brand_id) " : "" ; $model = $utility_class->isNotEmpty($model_id) ? " AND vtv.model_id IN ($model_id) " : "" ; $section = $utility_class->isNotEmpty($section_id) ? " AND ks.id IN ($section_id) " : "" ; $section_remove_has_section = (isset($array_data['all_null_section']) && !$owned_video_only) ? " AND ks.id IS NULL " : "" ; if($owned_video_only){ $my_video_only = " AND v.user_id = $user_id " ; }else{ $my_video_only = "" ; } $filter_brands_ids = (count($brand_access_arr) > 0) ? implode(",",$brand_access_arr) : "0" ; $filter_brands = " AND (vb.id IN ($filter_brands_ids) OR vb.id IS NULL) "; $video_query = $this->universal_video_query(); $left_regex = "\\\\b"; $right_regex = "\\\\b"; if(abs($db->server_info()) < 8){ $left_regex = "[[:<:]]"; $right_regex = "[[:>:]]"; } $search = "AND (CONCAT(v.title,' ',v.description) LIKE '%$search%' OR v.fault_codes RLIKE '$left_regex".$search."$right_regex' ) "; if(count($position_id_arr) > 1){ $user_position_id = $position_id_arr[0]; $filter_position_id = $position_id_arr[1]; $position_filter = ' AND JSON_CONTAINS(va.json_data,\'"'.$filter_position_id.'"\',"$") = 1 '; }else{ if($owned_video_only){ $position_filter = ""; }else{ $user_position_id = $position_id_arr[0]; $position_filter = ' AND (JSON_CONTAINS(va.json_data,\'"'.$user_position_id.'"\',"$") = 1 OR va.id IS NULL OR va.json_data = "[]" OR v.user_id = '.$user_id.') '; } } // REPLACE("SQL Tutorial", "SQL", "HTML"); $offset_limit = "LIMIT ".$offset.",".$limit." "; $fields = " v.id,v.original_name,v.attachment_name,v.title, REPLACE(CONCAT(SUBSTRING(v.description,1,30),'…'),'<br>',' ') as description, v.description as descriptionf, vb.id as brand_id,vb.name as brand,vm.id as model_id,vm.name as model,vmv.description as model_variant,vmv.id as model_variant_id, v.date_added,DATE_FORMAT(v.date_added, '%M %d, %Y') AS date_addedf "; $count = " COUNT(1) "; $query = $video_query." %s /*search*/ %s /*brand*/ %s /*model*/ %s /*section filter*/ %s /*brand access*/ %s /*sub categoryt*/ %s /*owner*/ %s /*position filter*/ %s /*section remove*/ AND v.status = 1 ORDER BY /*v.`title` ASC,*/v.`date_added` DESC %s "; $query_formatted_count = sprintf( $query, $count, $search, $brand, $model, $section, $filter_brands, $category_ids_str, $my_video_only, $position_filter, $section_remove_has_section, '' ); // echo $query_formatted_count;exit; $query_formatted = sprintf( $query, $fields, $search, $brand, $model, $section, $filter_brands, $category_ids_str, $my_video_only, $position_filter, $section_remove_has_section, $offset_limit ); // echo $query_formatted;exit; return array(intval($db->select($query_formatted_count)),$db->sql_query($query_formatted)); } function update_video_status($video_id,$status,$utility_class,$db){ $query = "UPDATE `videos` SET `status`=$status WHERE 1 AND id = $video_id "; // echo $query;exit; return $db->sql_query_affected_rows($query); } function read_knowledgebase_list($user_id, $array_data, $src_type, $owned_kb_only, $short_description, $category_ids_str, $brand_id, $model_id, $section_id, $brand_access_arr, $search, $start_date, $end_date, $offset, $limit, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db){ $category_ids_str = $utility_class->isNotEmpty($category_ids_str) ? " AND t.sub_category_id IN ($category_ids_str) " : '' ; // $final_status_ids_str = $utility_class->isNotEmpty($final_status_ids_str) ? " AND tfs.id IN ($final_status_ids_str) " : '' ; // $filter_escalated_status = $utility_class->isNotEmpty($filter_escalated_status) ? " AND tes.type IN ($filter_escalated_status) " : '' ; $brand = $utility_class->isNotEmpty($brand_id) ? " AND vb.id IN ($brand_id) " : "" ; $model = $utility_class->isNotEmpty($model_id) ? " AND vm.id IN ($model_id) " : "" ; $section = $utility_class->isNotEmpty($section_id) ? " AND ks.id IN ($section_id) " : "" ; $section_remove_has_section = (isset($array_data['all_null_section']) && !$owned_kb_only) ? " AND ks.id IS NULL " : "" ; if($utility_class->isNotEmpty($start_date) && $utility_class->isNotEmpty($end_date)){ $dates = " AND DATE_FORMAT(t.date_added, '%Y-%m-%d') BETWEEN '$start_date' AND '$end_date' "; }else{ $dates = ""; } if($owned_kb_only){ $my_kb_only = " AND t.user_id = $user_id " ; }else{ $my_kb_only = "" ; } $offset_limit = "LIMIT ".$offset.",".$limit." "; if($display_union_count > 0){ $union_offset_limit = "LIMIT $display_union_count "; }else{ $union_offset_limit = ""; } $filter_brands_ids = (count($brand_access_arr) > 0) ? implode(",",$brand_access_arr) : "0" ; $filter_brands = " AND (vb.id IN ($filter_brands_ids) OR vb.id IS NULL) "; $left_regex = "\\\\b"; $right_regex = "\\\\b"; if(abs($db->server_info()) < 8){ $left_regex = "[[:<:]]"; $right_regex = "[[:>:]]"; } $search = "AND (CONCAT(t.title,' ',t.description) LIKE '%$search%' OR t.fault_codes RLIKE '$left_regex".$search."$right_regex' ) "; // START TICKET SECTION $ticket_fields = " '2' as source, t.id, t.title, CONCAT(SUBSTRING(t.description, 1, 30),' ',SUBSTRING(t.complaint, 1, 30)) as descriptionf, /*t.description,*/ t.`date_added`, DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf, vb.id as brand_id, vb.name as brand, vm.id as model_id, vm.name as model, ts.name as status, sc.id as sub_category_id, sc.name as sub_category, vmv.id as model_variant_id, vmv.description as model_variant, sc.category_id, u.id_number, u.firstname, u.lastname "; $ticket_counts = " COUNT(1) "; $ticket_query = $universal_ticket_query." %s /*search*/ %s /*sub category*/ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*dates*/ %s /*my kb*/ AND ts.id IN (3,4,5) /*close and escalated*/ AND (t.type NOT IN (1) OR t.type IS NULL) AND t.status = 1 GROUP BY t.id ORDER BY t.date_added DESC %s "; if($utility_class->isNotEmpty($my_kb_only) || $src_type == '2' || $utility_class->isNotEmpty($section)){ $ticket_query_formatted = " SELECT '','','','','','','','','','','','','','','','','','','' LIMIT 0"; }else{ $ticket_query_formatted = sprintf( $ticket_query, $ticket_fields, $search, $category_ids_str, $brand, $model, $filter_brands, $dates, $my_kb_only, $union_offset_limit, ); } // END TICKET SECTION // START KB SECTION $knowledgebase_fields = " '1' as source, t.id, t.title, SUBSTRING(t.description, 1, 30) as descriptionf, /*t.description,*/ t.`date_added`, DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf, vb.id as brand_id, vb.name as brand, vm.id as model_id, vm.name as model, '' as status, sc.id as sub_category_id, sc.name as sub_category, vmv.id as model_variant_id, vmv.description as model_variant, sc.category_id, u.id_number, u.firstname, u.lastname "; $knowledgebase_counts = " COUNT(1) "; $knowledgebase_query = $universal_knowledgebase_query." %s /*search*/ %s /*sub category*/ /* percentS final status for ticket query only*/ %s /*brand */ %s /*model */ %s /* kb section*/ %s /*brand access*/ %s /*dates*/ %s /*my kb*/ %s /* exclude has section */ AND t.status = 1 GROUP BY t.id ORDER BY t.date_added DESC %s "; if($src_type == '1' ){ $knowledgebase_query_formatted = " SELECT '','','','','','','','','','','','','','','','','','','' LIMIT 0"; }else{ $knowledgebase_query_formatted = sprintf( $knowledgebase_query, $knowledgebase_fields, $search, $category_ids_str, $brand, $model, $section, $filter_brands, $dates, $my_kb_only, $section_remove_has_section, $union_offset_limit, ); } // END KB SECTION // MERGE QUERIES if( $src_type == '1'){ $knowledgebase_ticket_union = "(".$ticket_query_formatted.") UNION ALL (".$knowledgebase_query_formatted.")"; }else if($utility_class->isNotEmpty($my_kb_only) || $src_type == '2' || $utility_class->isNotEmpty($section)){ $knowledgebase_ticket_union = "(".$knowledgebase_query_formatted.") UNION ALL (".$ticket_query_formatted.")"; }else{ $knowledgebase_ticket_union = "(".$ticket_query_formatted.") UNION ALL (".$knowledgebase_query_formatted.")"; } $final_query = "SELECT * FROM (".$knowledgebase_ticket_union.") t1 ORDER BY t1.date_added DESC ".$offset_limit; $final_query_count = "SELECT COUNT(1) FROM (".$knowledgebase_ticket_union.") t1 "; // echo $final_query ;exit; // echo $ticket_query_formatted ;exit; return array(intval($db->select($final_query_count)),$db->sql_query($final_query)); // echo $final_query_count ;exit; // echo $final_query ;exit; } function read_knowledgebase_list_autocomplete( $search, $offset, $limit, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db){ $offset_limit = "LIMIT ".$offset.",".$limit." "; if($display_union_count > 0){ $union_offset_limit = "LIMIT $display_union_count "; }else{ $union_offset_limit = ""; } // START TICKET SECTION $ticket_fields = " t.id, t.title "; $ticket_query = $universal_ticket_query." AND t.title LIKE '%%%s%%' AND ts.id IN (3,4,5) /*close and escalated*/ AND (t.type NOT IN (1) OR t.type IS NULL) AND t.status = 1 GROUP BY t.title ORDER BY t.date_added DESC %s "; $ticket_query_formatted = sprintf( $ticket_query, $ticket_fields, $search, $union_offset_limit, ); // END TICKET SECTION // START KB SECTION $knowledgebase_fields = " t.id, t.title "; $knowledgebase_query = $universal_knowledgebase_query." AND t.title LIKE '%%%s%%' AND t.status = 1 GROUP BY t.id ORDER BY t.date_added DESC %s "; $knowledgebase_query_formatted = sprintf( $knowledgebase_query, $knowledgebase_fields, $search, $union_offset_limit, ); // END KB SECTION // MERGE QUERIES $knowledgebase_ticket_union = "(".$ticket_query_formatted.") UNION ALL (".$knowledgebase_query_formatted.")"; $final_query = "SELECT * FROM (".$knowledgebase_ticket_union.") t1 ORDER BY t1.title DESC ".$offset_limit; // echo $final_query; exit; // $final_query_count = "SELECT COUNT(1) FROM (".$knowledgebase_ticket_union.") t1 "; return $db->sql_query($final_query); } function read_related_articles( $title, $fault_codes, $sub_category_id, $brand_id, $model_id, $model_variant_id, $brand_access_arr, $offset, $limit, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db){ // format each of search keywords into the db query to be run $search = " AND (("; $keywords = explode(' ', $title); $keywords = array_unique($keywords); foreach ($keywords as $word){ $search .= " CONCAT(t.title,' ',t.description) LIKE '%%".$word."%%' OR "; } $search = substr($search, 0, strlen($search)-4).") %s )"; //remove last OR $fault_codes_s = ""; if($utility_class->isNotEmpty($fault_codes)){ $fault_codes_s = " OR ("; $fault_codes_kw = explode(',', $fault_codes); $fault_codes_kw = array_unique($fault_codes_kw); $left_regex = "\\\\b"; $right_regex = "\\\\b"; if(abs($db->server_info()) < 8){ $left_regex = "[[:<:]]"; $right_regex = "[[:>:]]"; } foreach ($fault_codes_kw as $word){ $fault_codes_s .= " t.fault_codes RLIKE '$left_regex".$word."$right_regex' OR "; } $fault_codes_s = substr($fault_codes_s, 0, strlen($fault_codes_s)-4).")"; //remove last OR } $search = sprintf($search,$fault_codes_s); // $category_ids_str = $utility_class->isNotEmpty($sub_category_id) ? " AND t.sub_category_id IN ($sub_category_id) " : '' ; // $brand = $utility_class->isNotEmpty($brand_id) ? " AND vb.id IN ($brand_id) " : "" ; // $model = $utility_class->isNotEmpty($model_id) ? " AND vm.id IN ($model_id) " : "" ; // $model_variant = $utility_class->isNotEmpty($model_variant_id) ? " AND vmv.id IN ($model_variant_id) " : "" ; $category_ids_str = ""; $brand =""; $model =""; $model_variant = ""; $offset_limit = "LIMIT ".$offset.",".$limit." "; if($display_union_count > 0){ $union_offset_limit = "LIMIT $display_union_count "; }else{ $union_offset_limit = ""; } $filter_brands_ids = (count($brand_access_arr) > 0) ? implode(",",$brand_access_arr) : "0" ; $filter_brands = " AND (vb.id IN ($filter_brands_ids) OR vb.id IS NULL) "; // START TICKET SECTION $ticket_fields = " '2' as source, t.id, t.title, CONCAT(SUBSTRING(t.description, 1, 30),' ',SUBSTRING(t.complaint, 1, 30)) as descriptionf, /*SUBSTRING(t.description, 1, 100) as descriptionf,*/ /*t.description,*/ t.`date_added`, DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf, vb.id as brand_id, vb.name as brand, vm.id as model_id, vm.name as model, IF(ts.id IS NOT NULL, ts.name, (SELECT name FROM ticket_status WHERE level = 1 AND status = 1 LIMIT 1) ) as status, sc.id as sub_category_id, sc.name as sub_category, vmv.id as model_variant_id, vmv.description as model_variant, sc.category_id "; $ticket_counts = " COUNT(1) "; $ticket_query = $universal_ticket_query." %s /*search*/ %s /*sub category*/ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*mvariant*/ AND ts.id IN (3,4,5) /*close and escalated*/ AND (t.type NOT IN (1) OR t.type IS NULL) AND t.status = 1 GROUP BY t.id ORDER BY t.date_added DESC %s "; $ticket_query_formatted = sprintf( $ticket_query, $ticket_fields, $search, $category_ids_str, $brand, $model, $filter_brands, $model_variant, $union_offset_limit, ); // echo $ticket_query_formatted;exit; // END TICKET SECTION // START KB SECTION $knowledgebase_fields = " '1' as source, t.id, t.title, SUBSTRING(t.description, 1, 100) as descriptionf, /*t.description,*/ t.`date_added`, DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf, vb.id as brand_id, vb.name as brand, vm.id as model_id, vm.name as model, '' as status, sc.id as sub_category_id, sc.name as sub_category, vmv.id as model_variant_id, vmv.description as model_variant, sc.category_id "; $knowledgebase_counts = " COUNT(1) "; $knowledgebase_query = $universal_knowledgebase_query." %s /*search*/ %s /*sub category*/ %s /*brand */ %s /*model */ %s /*brand access*/ %s /*mvariant*/ AND t.status = 1 GROUP BY t.id ORDER BY t.date_added DESC %s "; $knowledgebase_query_formatted = sprintf( $knowledgebase_query, $knowledgebase_fields, $search, $category_ids_str, $brand, $model, $filter_brands, $model_variant, $union_offset_limit, ); // END KB SECTION // MERGE QUERIES $knowledgebase_ticket_union = "(".$ticket_query_formatted.") UNION ALL (".$knowledgebase_query_formatted.")"; $final_query = "SELECT * FROM (".$knowledgebase_ticket_union.") t1 ORDER BY t1.date_added DESC ".$offset_limit; // echo $final_query;exit; $final_query_count = "SELECT COUNT(1) FROM (".$knowledgebase_ticket_union.") t1 "; return array(intval($db->select($final_query_count)),$db->sql_query($final_query)); } function read_knowledgebase_video_autocomplete( $search, $offset, $limit, $utility_class,$db){ $knowledgebase_query = $this->universal_video_query(); $offset_limit = "LIMIT ".$offset.",".$limit." "; $field = " v.id,v.title "; $query = $knowledgebase_query." AND v.title LIKE '%%%s%%' AND v.status = 1 GROUP BY v.title ORDER BY v.title ASC %s "; $query_formatted = sprintf( $query, $field, $search, $offset_limit ); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_knowledgebase_attachments($knowledgebase_id,$utility_class,$db){ $query = "SELECT *,DATE_FORMAT(date_added, '%M %d, %Y') as date_addedf FROM `knowledgebase_attachments` WHERE 1 AND `knowledgebase_id` = $knowledgebase_id AND status = 1"; return $db->sql_query($query); } function read_knowledgebase_information($knowledgebase_id,$utility_class,$db){ $knowledgebase_query = $this->universal_knowledgebase_query(); $fields = " t.id, t.title, t.description, t.fault_codes, t.`date_added`, DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf, vb.id as brand_id, vb.name as brand, vm.id as model_id, vm.name as model, sc.id as sub_category_id, sc.name as sub_category, vmv.id as model_variant_id, vmv.description as model_variant, sc.category_id, /*ks.id as section_id,*/ ks.name as section, c.show_vehicle, ttv.id as knowledgebase_vehicle_id, u.firstname, u.lastname "; $query = $knowledgebase_query." AND t.id = $knowledgebase_id "; $query_formatted = sprintf($query,$fields); return $db->sql_query($query_formatted); } function universal_knowledgebase_query(){ return " SELECT %s FROM `knowledgebase` t LEFT OUTER JOIN sub_categories sc ON t.sub_category_id = sc.id LEFT OUTER JOIN categories c ON sc.category_id = c.id LEFT OUTER JOIN knowledgebase_type_vehicles ttv ON ttv.id = (SELECT ttvs.id FROM knowledgebase_type_vehicles ttvs WHERE ttvs.knowledgebase_id = t.id AND ttvs.status = 1) LEFT OUTER JOIN vehicle_models vm ON ttv.model_id = vm.id LEFT OUTER JOIN vehicle_brands vb ON ttv.brand_id = vb.id LEFT OUTER JOIN vehicle_model_variants vmv ON ttv.model_variant_id = vmv.id LEFT OUTER JOIN users u ON t.user_id = u.id LEFT OUTER JOIN sections ks ON t.section_id = ks.id WHERE 1 "; } function universal_video_query(){ return " SELECT %s FROM `videos` v LEFT OUTER JOIN video_type_vehicles vtv ON v.id = vtv.video_id LEFT OUTER JOIN sub_categories sc ON v.sub_category_id = sc.id LEFT OUTER JOIN vehicle_models vm ON vtv.model_id = vm.id LEFT OUTER JOIN vehicle_brands vb ON vtv.brand_id = vb.id LEFT OUTER JOIN vehicle_model_variants vmv ON vtv.model_variant_id = vmv.id LEFT OUTER JOIN users u ON v.user_id = u.id LEFT OUTER JOIN video_access va ON v.id = va.video_id LEFT OUTER JOIN sections ks ON v.section_id = ks.id WHERE 1 "; } function read_video_information($video_id,$utility_class,$db){ $video_query = $this->universal_video_query(); // $field = " t.id,t.title,t.description,t.`date_added`, // DATE_FORMAT(t.date_added,'%Y-%m-%d') date_addedf, // vb.id as brand_id,vb.name as brand,vm.id as model_id,vm.name as model,ttv.plate_cs, // ts.id as ticket_status_id,ts.name as ticket_status,ts.name as ticket_status, // sc.id as sub_category_id,sc.name as sub_category,vmv.id as model_variant_id,vmv.description as model_variant, // pl.id as priority_level_id,pl.name as priority_level,ttv.year_model,sc.category_id "; $fields = "v.id,v.original_name,v.attachment_name,v.title,sc.name as sub_category,u.firstname,u.lastname,v.fault_codes, vb.id as brand_id,vb.name as brand,vm.id as model_id,vm.name as model,vmv.description as model_variant,vmv.id as model_variant_id, /*CONCAT(SUBSTRING(v.description,1,30),'...') as description,*/ v.description, v.date_added,DATE_FORMAT(v.date_added, '%M %d, %Y') AS date_addedf, va.json_data, ks.name as section "; $query = $video_query." AND v.id = $video_id "; $query_formatted = sprintf($query,$fields); // echo $query_formatted;exit; return $db->sql_query($query_formatted); } function read_sub_category_count($db){ $knowledgebase_query = $this->universal_knowledgebase_query(); // START knowledgebase SECTION $knowledgebase_fields = " sc.id, sc.name, COUNT(sc.id) as sub_category_count "; $knowledgebase_counts = " COUNT(1) "; $knowledgebase_query = $knowledgebase_query." AND t.status = 1 AND sc.status = 1 AND c.status = 1 GROUP BY sc.id ORDER BY sc.name ASC "; $knowledgebase_query_formatted = sprintf( $knowledgebase_query, $knowledgebase_fields, ); return $db->sql_query($knowledgebase_query_formatted); } function read_sub_category_count_v2( $session_access, $brand_access_arr, $universal_knowledgebase_query, $universal_ticket_query, $display_union_count, $utility_class, $db){ $filter_brands_ids = (count($brand_access_arr) > 0) ? implode(",",$brand_access_arr) : "0" ; $filter_brands = " AND (vb.id IN ($filter_brands_ids) OR vb.id IS NULL) "; // START TICKET SECTION $ticket_fields = " sc.id, sc.name, COUNT(sc.id) as sub_category_count "; $ticket_query = $universal_ticket_query." AND ts.id IN (3,4,5) /*close and escalated*/ AND (t.type NOT IN (1) OR t.type IS NULL) AND t.status = 1 AND sc.status = 1 AND c.status = 1 %s /*brand access*/ GROUP BY sc.id ORDER BY sc.name ASC "; $ticket_query_formatted = sprintf( $ticket_query, $ticket_fields, $filter_brands ); // echo $ticket_query_formatted; // END TICKET SECTION // START KB SECTION if(isset($session_access['4']) && in_array('4_3', $session_access['4'])){ $ait_access= ""; }else{ $ait_access= " AND ks.id IS NULL"; } $knowledgebase_fields = " sc.id, sc.name, COUNT(sc.id) as sub_category_count "; $knowledgebase_query = $universal_knowledgebase_query." AND t.status = 1 AND sc.status = 1 AND c.status = 1 %s /*brand access*/ %s /*ait kb access */ GROUP BY sc.id ORDER BY sc.name ASC "; $knowledgebase_query_formatted = sprintf( $knowledgebase_query, $knowledgebase_fields, $filter_brands, $ait_access ); // END KB SECTION // MERGE QUERIES $knowledgebase_ticket_union = "(".$ticket_query_formatted.") UNION ALL (".$knowledgebase_query_formatted.")"; $final_query = "SELECT t1.id,t1.name,SUM(t1.sub_category_count) as sub_category_count FROM (".$knowledgebase_ticket_union.") t1 GROUP BY t1.id "; return $db->sql_query($final_query); } function read_watched_video($video_id,$user_id,$utility_class,$db){ $query = "SELECT id FROM `video_views` WHERE 1 AND status = 1 AND `video_id` = $video_id AND `user_id` = $user_id LIMIT 1"; return $db->select($query); } function create_watched_video($video_id,$user_id,$utility_class,$db){ $query = "INSERT INTO `video_views`(`user_id`, `date_added`, `status`, `video_id`) VALUES ($user_id,NOW(),1,$video_id)"; // echo $query;exit; return $db->sql_query($query); } function read_video_viewers($video_id,$search,$offset,$limit,$order,$utility_class,$db){ $query = "SELECT vv.*,u.id_number,u.firstname,u.lastname, DATE_FORMAT(vv.date_added,'%b. %d, %Y %h:%i%p') as date_addedf FROM `video_views` vv LEFT OUTER JOIN users u ON vv.user_id = u.id WHERE 1 AND (u.id_number = '$search' OR CONCAT(u.firstname,' ',u.lastname,' ',u.firstname) LIKE '%$search%') AND vv.video_id = $video_id ORDER BY vv.`date_added` $order LIMIT $offset,$limit "; // echo $query;exit; return $db->sql_query($query); } function create_video_access($video_id,$json_data,$utility_class,$db){ $query = "INSERT INTO `video_access`(`json_data`, `video_id`, `status`) VALUES ('$json_data',$video_id,1) ON DUPLICATE KEY UPDATE json_data = VALUES (json_data) "; return $db->sql_query($query); } } ?> upload_class.php 0000644 00000013770 15024755751 0007751 0 ustar 00 <?php /** * use CRUD for class naming * example: create_ and read_and update_ and delete_ */ class Upload{ function create_attachment($file,$target_dir,$utility_class,$db){ if($utility_class->isNotEmpty($file['name'])){ // $target_dir = dirname(__FILE__) . '../../../dist/attachments'; // Create Dir if (!file_exists($target_dir)) { mkdir($target_dir, 0777, true); } // Getting file name $filename = $file['name']; $filesize = $file['size']; $gen_filename = $db->select('SELECT UUID()'); // file extension $file_extension = pathinfo($filename, PATHINFO_EXTENSION); $file_extension = strtolower($file_extension); //Valid extension $valid_ext_doc = array('pdf','doc','docx','txt','html','htm','ppt','pptx','xls','csv','xlsx'); $valid_ext_img = array('png','jpeg','jpg'); $valid_ext_vid = array('mp4','mkv','mov','avi','wmv'); if(in_array($file_extension,$valid_ext_doc)){ switch($file_extension){ case 'pdf': $location = $target_dir."/".$gen_filename; break; default: $location = $target_dir."/".$gen_filename.".".$file_extension; } $maxsize = 9097152; $minsize = 300000; if (move_uploaded_file($_FILES["file"]["tmp_name"], $location)) { $return_arr["status"]=1; $return_arr["change_name"]= $gen_filename.".".$file_extension; $return_arr["orig_name"]= $filename; $return_arr["message"]=" File Uploaded."; } else { $return_arr["status"]=0; $return_arr["orig_name"]= $filename; $return_arr["message"]=" File Not Uploaded."; } }else if(in_array($file_extension,$valid_ext_img)){ // $location = $target_dir."/".$gen_filename.".".$file_extension; $location = $target_dir."/".$gen_filename; $maxsize = 9097152; $minsize = 300000; if($filesize >= $maxsize || $filesize == 0 ){ $return_arr["status"]=0; $return_arr["orig_name"]= $filename; $return_arr["message"]=" File file too large. File must less than ".round(($maxsize/1000000), 0)." megabytes."; echo json_encode($return_arr); return; } if($filesize >= $minsize ){ $quality = 60; if($filesize >= $maxsize/2){ $quality = 30; } }else{ $quality = 60; } // Compress Image $this->compressImage($file['tmp_name'],$location,$quality); $return_arr["status"]=1; $return_arr["change_name"] = $gen_filename.".".$file_extension; $return_arr["orig_name"]= $filename; $return_arr["message"]=" Image Uploaded."; }else if(in_array($file_extension,$valid_ext_vid)){ $location = $target_dir."/".$gen_filename.".".$file_extension; $maxsize = 9097152; $minsize = 300000; if (move_uploaded_file($_FILES["file"]["tmp_name"], $location)) { $return_arr["status"]=1; $return_arr["change_name"] = $gen_filename.".".$file_extension; $return_arr["orig_name"]= $filename; $return_arr["message"]=" File Uploaded."; } else { $return_arr["status"]=0; $return_arr["orig_name"]= $filename; $return_arr["message"]=" File Not Uploaded."; } }else{ $return_arr["status"]=0; $return_arr["orig_name"]= $filename; $return_arr["message"]=" Invalid file type."; } }else{ $return_arr["status"]=0; $return_arr["message"]=" Error has occured."; } // echo json_encode($return_arr); return $return_arr; } function compressImage($source, $destination, $quality) { // Get image info $imgInfo = getimagesize($source); $mime = $imgInfo['mime']; // Create a new image from file switch($mime){ case 'image/jpeg': $image = imagecreatefromjpeg($source); break; case 'image/png': $image = imagecreatefrompng($source); break; case 'image/gif': $image = imagecreatefromgif($source); break; default: $image = imagecreatefromjpeg($source); } // Save image imagejpeg($image, $destination, $quality); // Return compressed image return $destination; } function delete_attachment($files,$target_dir){ // $target_dir = dirname(__FILE__) . '../../../dist/attachments/'; foreach($files as $file){ echo $file['change_name']."\n<br>"; unlink($target_dir.$file['change_name']); } } } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings