���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/adimi/application/modules/dashboard/models/ |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed'); class Delivery_system extends CI_Model { public function __construct() { parent::__construct(); } public function get_delivery_boys($per_page = null, $page = null){ $this->db->select('*'); $this->db->from('delivery_boy'); $this->db->limit($per_page, $page); $this->db->order_by('name','desc'); $result = $this->db->get()->result_array(); return $result; } public function delivery_boys_count(){ $this->db->select('*'); $this->db->from('delivery_boy'); $this->db->order_by('name','desc'); $query = $this->db->get(); if ($query->num_rows() > 0) { return $query->num_rows(); } return false; } public function get_delivery_boy_info_by_id($delivery_boy){ $this->db->select('*'); $this->db->from('delivery_boy'); $this->db->where('id',$delivery_boy); $result = $this->db->get()->row_array(); return $result; } public function delivery_boy_delete($delivery_boy){ $delivery_boy_info = $this->db->select('national_id, driving_license')->from('delivery_boy')->where('id',$delivery_boy)->get()->result(); if($delivery_boy_info){ @unlink(FCPATH.$delivery_boy_info->national_id); @unlink(FCPATH.$delivery_boy_info->driving_license); } $this->db->where('id', $delivery_boy); $this->db->delete('delivery_boy'); $this->session->set_userdata(array('message' => display('successfully_delete'))); redirect('dashboard/Cdelivery_system/index'); } public function get_time_slots($per_page = null, $page = null){ $this->db->select('*'); $this->db->from('delivery_time_slot'); $this->db->limit($per_page, $page); $this->db->order_by('id','desc'); $result = $this->db->get()->result_array(); return $result; } public function time_slots_count(){ $this->db->select('*'); $this->db->from('delivery_time_slot'); $this->db->order_by('id','desc'); $result = $this->db->get(); if($result->num_rows() > 0){ return $result->num_rows(); } return false; } public function get_delivery_time_slot_info_by_id($delivery_time_slot){ $this->db->select('*'); $this->db->from('delivery_time_slot'); $this->db->where('id',$delivery_time_slot); $result = $this->db->get()->row_array(); return $result; } public function time_slot_delete($time_slot){ $this->db->where('id', $time_slot); $this->db->delete('delivery_time_slot'); $this->session->set_userdata(array('message' => display('successfully_delete'))); redirect('dashboard/Cdelivery_system/manage_time_slot'); } public function get_delivery_boys_info(){ $this->db->select('id,name'); $this->db->from('delivery_boy'); $this->db->order_by('id','desc'); $result = $this->db->get()->result(); return $result; } public function get_delivery_zones($per_page = null, $page = null){ $this->db->select('*'); $this->db->from('delivery_zone'); $this->db->limit($per_page, $page); $this->db->order_by('id','desc'); $result = $this->db->get()->result_array(); return $result; } public function delivery_zones_count(){ $this->db->select('*'); $this->db->from('delivery_zone'); $this->db->order_by('id','desc'); $result = $this->db->get(); if($result->num_rows() > 0){ return $result->num_rows(); } return false; } public function get_delivery_zone_info_by_id($delivery_zone_id){ $this->db->select('*'); $this->db->from('delivery_zone'); $this->db->where('id',$delivery_zone_id); $result = $this->db->get()->row_array(); return $result; } public function delivery_zone_delete($delivery_zone_id){ $this->db->where('id', $delivery_zone_id); $this->db->delete('delivery_zone'); $this->session->set_userdata(array('message' => display('successfully_delete'))); redirect('dashboard/Cdelivery_system/manage_delivery_zone'); } public function get_active_delivery_zone(){ $this->db->select('id,delivery_zone'); $this->db->from('delivery_zone'); $this->db->where('status',1); $this->db->order_by('id','desc'); $result = $this->db->get()->result(); return $result; } public function get_active_delivery_boy(){ $this->db->select('id,name'); $this->db->from('delivery_boy'); $this->db->where('status',1); $this->db->order_by('id','desc'); $result = $this->db->get()->result(); return $result; } public function get_pending_orders(){ $this->db->select('*'); $this->db->from('order a'); $this->db->join('invoice b','a.order_id = b.order_id'); $this->db->where('b.invoice_status','4'); $this->db->or_where('b.invoice_status','5'); $result = $this->db->get()->result(); return $result; } public function get_assigned_deliveries($per_page = null, $page = null){ $this->db->select('a.*,b.name,c.delivery_zone,d.title'); $this->db->from('delivery_assign a'); $this->db->join('delivery_boy b','a.delivery_boy_id = b.id'); $this->db->join('delivery_zone c','a.delivery_zone_id = c.id'); $this->db->join('delivery_time_slot d','a.time_slot_id = d.id'); $this->db->limit($per_page, $page); $this->db->order_by('delivery_id','desc'); $result = $this->db->get()->result_array(); return $result; } public function assigned_deliveries_count(){ $this->db->select('a.*,b.name,c.delivery_zone,d.title'); $this->db->from('delivery_assign a'); $this->db->join('delivery_boy b','a.delivery_boy_id = b.id'); $this->db->join('delivery_zone c','a.delivery_zone_id = c.id'); $this->db->join('delivery_time_slot d','a.time_slot_id = d.id'); $this->db->order_by('delivery_id','desc'); $result = $this->db->get(); if($result->num_rows() > 0){ return $result->num_rows(); } return false; } public function get_active_time_slots(){ $this->db->select('*'); $this->db->from('delivery_time_slot'); $this->db->where('status',1); $this->db->order_by('id','desc'); $result = $this->db->get()->result(); return $result; } public function get_assigned_orders($delivery_id){ $this->db->select('*'); $this->db->from('delivery_orders'); $this->db->where('delivery_id',$delivery_id); $this->db->order_by('delivery_id','desc'); $result = $this->db->get()->result_array(); return $result; } public function get_assigned_delivery_info_by_id($delivery_id) { $this->db->select('*'); $this->db->from('delivery_assign'); $this->db->where('delivery_id',$delivery_id); $result = $this->db->get()->row_array(); return $result; } public function get_assigned_delivery_order_info_by_id($delivery_id) { $this->db->select('order_no'); $this->db->from('delivery_orders'); $this->db->where('delivery_id',$delivery_id); $result = $this->db->get()->result(); return $result; } public function assigned_delivery_delete($delivery_id){ $this->db->where('delivery_id', $delivery_id); $this->db->delete('delivery_assign'); $this->session->set_userdata(array('message' => display('successfully_delete'))); redirect('dashboard/Cdelivery_system/manage_assigned_delivery'); } }