1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / orders.eltorofashions.com / application / controllers /
Filename : Web.php
back
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Web extends CI_Controller {
    public function __construct(){
          parent::__construct();
		  $this->load->model('common_model');
		   
			
	   }
	
	public function index()
	{
		$this->load->view('web/login');
	}

	public function logincheck(){

		$username = $this->input->post("username");
		$password = $this->input->post("password");
		$remember = $this->input->post("remember");

		
		$exists = $this->Common_model->get_record("login","id, status",array("username"=>$username, "password"=>$password));

		if(isset($exists->status) && $exists->status == 1){

			$userdata = array('uid'=>$exists->id, 'username'=>$username, 'remember'=>$remember);

			$this->session->set_userdata($userdata);

			redirect('web/dashboard');


		}else{

			$this->session->set_flashdata("login_error","Account is not active");

			redirect('web/index');
		}

	}

	public function logout(){
		$userdata = array('uid'=>'', 'username'=>'', 'remember'=>'');

		$this->session->set_userdata($userdata);

		redirect('web/index');
	}


	public function dashboard($status = '')
	{

		$sql = '';
		if($status){
			$sql = ' and o.order_status = '.$status;
		}

		$data['order_status'] = $status;

		$sql = "select o.*, (select sum(p.quantity) from order_products p where p.order_id = o.oid) as quantity, (select name from sources s where s.id = o.source) as source_name, (select username from login l where l.id = o.modified_by) as edited_by from orders o where o.status = 1 $sql order by o.order_date desc";	
		$orders = $this->db->query($sql);

		$data['orders'] = $orders->result();

		$this->load->view('web/dashboard', $data);
	}

	public function createOrder(){

		$data['sources'] = $this->Common_model->get_records('sources', '*', array('status'=>1));

		$this->load->view('web/createOrder', $data);
	}

	public function saveOrder(){
	

		$values['order_date'] = date("Y-m-d", strtotime($this->input->post('order_date')));
		$values['dispatch_date'] = date("Y-m-d", strtotime($this->input->post('dispatch_date')));
		$values['order_number'] = $this->input->post('order_number');
		$values['source'] = $this->input->post('source');
		$values['payment_type'] = $this->input->post('payment_type');
		$values['order_status'] = $this->input->post('order_status');
		//$values['return_status'] = $this->input->post('return_status');
		$values['modified_by'] = get_user();
		$values['modified_time'] = date("Y-m-d H:i:s");



		if(isset($_FILES['shipping_label']['name']) && $_FILES['shipping_label']['name']){
	        $config['upload_path']          = "assets/upload/shipping_label";
	    	$config['allowed_types']        = 'pdf';
	    	$config['file_name'] = time().rand();        
	        
	        $this->load->library('upload', $config);
	        $this->upload->initialize($config);        
	        
	        if($this->upload->do_upload('shipping_label')){                
	            $fileData = $this->upload->data();

	            $ext = pathinfo($_FILES['shipping_label']['name'], PATHINFO_EXTENSION);
	            $values['shipping_label'] = $config['file_name'].".".$ext;	            
	        }

			
        }	

		if(isset($_FILES['invoice']['name']) && $_FILES['invoice']['name']){
	        $config['upload_path']          = "assets/upload/invoice";
	    	$config['allowed_types']        = 'pdf';
	    	$config['file_name'] = time().rand();        
	        
	        $this->load->library('upload', $config);
	        $this->upload->initialize($config);        
	        
	        if($this->upload->do_upload('invoice')){                
	            $fileData = $this->upload->data();

	            $ext = pathinfo($_FILES['invoice']['name'], PATHINFO_EXTENSION);
	            $values['invoice'] = $config['file_name'].".".$ext;	            
	        }

			
        }	

		
		
		$order_id = $this->Common_model->insert_record('orders', $values);
		unset($values);

		$values['order_id'] = $order_id;
		$values['order_status'] = $this->input->post('order_status');
		$values['modified_by'] = get_user();
		$values['modified_time'] = date("Y-m-d H:i:s");

		$this->Common_model->insert_record('order_status_history', $values);
		unset($values);


		$image = $this->input->post('image');
		$name = $this->input->post('name');
		$variation = $this->input->post('variation');
		$quantity = $this->input->post('quantity');
		$sku = $this->input->post('sku');
		if(!empty($image)){
			foreach($image as $key => $tmp){
				$values['order_id'] = $order_id;
				$values['product_name'] = $name[$key];
				$values['sku'] = $sku[$key];
				$values['product_image'] = $tmp;
				$values['quantity'] = $quantity[$key];

				$vararr = array();
				if(isset($variation[$key])){
					foreach($variation[$key] as $op => $var){
						$vararr[] = $op.': '.$var;
					}
				}
				if(!empty($vararr)){
					$vararr = implode("<br>",$vararr);
					$values['variation'] = $vararr;
				}
				

				$this->Common_model->insert_record('order_products', $values);
				unset($values);
			}
		}


		redirect("web/dashboard");
		
	}


	public function update_order_status(){

		$where['oid'] = $this->input->post('oid');
		$values['order_status'] = $this->input->post('order_status');

		$values['modified_by'] = get_user();
		$values['modified_time'] = date("Y-m-d H:i:s");
		$this->Common_model->update_record('orders', $values, $where);
		unset($where);
		unset($values);

		$values['order_id'] = $this->input->post('oid');
		$values['order_status'] = $this->input->post('order_status');
		$values['modified_by'] = get_user();
		$values['modified_time'] = date("Y-m-d H:i:s");
		$this->Common_model->insert_record('order_status_history', $values);

		echo json_encode(array('edited_by'=>get_username()));
	}


	public function upload_order_pdf(){

		$type = $this->input->post('type');


		if(isset($_FILES['pdf']['name']) && $_FILES['pdf']['name']){
			
			if($type == 1)
	        	$config['upload_path']          = "assets/upload/shipping_label";
			else
				$config['upload_path']          = "assets/upload/invoice";


	    	$config['allowed_types']        = 'pdf';
	    	$config['file_name'] = time().rand();        
	        
	        $this->load->library('upload', $config);
	        $this->upload->initialize($config);        
	        
	        if($this->upload->do_upload('pdf')){                
	            $fileData = $this->upload->data();

	            $ext = pathinfo($_FILES['pdf']['name'], PATHINFO_EXTENSION);

				if($type == 1)
					$filename = $values['shipping_label'] = $config['file_name'].".".$ext;	            
				else
					$filename = $values['invoice'] = $config['file_name'].".".$ext;	            

	        }

			
        }	


		$where['oid'] = $this->input->post('oid');

		if(isset($values)){
			$this->Common_model->update_record('orders', $values, $where);

			if($type == 1)
				echo json_encode(array('type'=>'shipping_label', 'filename'=>base_url().'assets/upload/shipping_label/'.$filename));
			else
				echo json_encode(array('type'=>'invoice', 'filename'=>base_url().'assets/upload/invoice/'.$filename));
		}

	}



	public function get_order_status_history(){
		$oid = $this->input->post('oid');

		$sql = "select oh.*, l.username from order_status_history oh, login l where oh.order_id = $oid and oh.modified_by = l.id order by oh.modified_time desc";
		$history = $this->db->query($sql);

		$historyarr = array();
		foreach($history->result() as $tmp){
			$values['status'] = get_order_status($tmp->order_status);
			$values['modified_by'] = $tmp->username;
			$values['modified_time'] = date("d-m-Y H:i", strtotime($tmp->modified_time));


			array_push($historyarr, $values);
		}

		echo json_encode($historyarr);

	}






	public function delete_order($oid){
		$where['oid'] = $oid;

		$values['status'] = 0;
		$this->Common_model->update_record('orders', $values, $where);

		redirect("web/dashboard");
	}





	public function dispatch_list($date = '')
	{

		if($date == '')
			$date = date("d-m-Y");

		
		$dispatch_date = date("Y-m-d", strtotime($date));
		$sql = $this->db->query("select * from orders where status = 1 and dispatch_date = '$dispatch_date'");	
		
		$data['dispatch_date'] = $date;

		$orders = array();
		foreach($sql->result_array() as $tmp){
			$subarray['order_date'] = $tmp['order_date'];

			$sqls = $this->db->query("select * from sources where id = '".$tmp['source']."'");
			$source = $sqls->row_array();
			$subarray['source'] = $source['name'];

			$subarray['dispatch_date'] = $tmp['dispatch_date'];
			$subarray['order_number'] = $tmp['order_number'];

			$products = $this->db->query('select * from order_products where order_id = '.$tmp['oid']);
			foreach($products->result_array() as $product){
				$subarrayproducts['product_image'] = $product['product_image'];
				$subarrayproducts['product_name'] = $product['product_name'];
				$subarrayproducts['sku'] = $product['sku'];
				$subarrayproducts['variation'] = $product['variation'];
				$subarrayproducts['quantity'] = $product['quantity'];

				$subarray['products'][] = $subarrayproducts;
			}


			array_push($orders, $subarray);
		}

		$data['orders'] = $orders;

		$this->load->view('web/dispatch_list', $data);
	}




	public function createOfflineOrder(){

		$this->load->view('web/createOfflineOrder');
	}
	
	public function saveOfflineOrder(){
		
		$order_id = $this->input->post("order_id");
		
		
		$values['order_date'] = $this->input->post('order_date');
		$values['delivery_date'] = $this->input->post('delivery_date');
		$values['expiry_date'] = $this->input->post('expiry_date');	
		$values['extended_date'] = $this->input->post('extended_date');	
		$values['order_num'] = $this->input->post('order_num');
		$values['delivery_address'] = $this->input->post('delivery_address');
		$values['place'] = trim($this->input->post('place'));
		$values['appointment'] = 0;
		
		
		
		if(isset($_FILES['purchase_order']['name']) && $_FILES['purchase_order']['name']){
	        $config['upload_path']          = "assets/upload/purchase_order";
	    	$config['allowed_types']        = 'pdf';
	    	$config['file_name'] = time().rand();        
	        
	        $this->load->library('upload', $config);
	        $this->upload->initialize($config);        
	        
	        if($this->upload->do_upload('purchase_order')){                
	            $fileData = $this->upload->data();

	            $ext = pathinfo($_FILES['purchase_order']['name'], PATHINFO_EXTENSION);
	            $values['purchase_order'] = $config['file_name'].".".$ext;	            
	        }			
        }	
		
		
	
		if($order_id){
			
			
			
			$this->Common_model->update_record('offline_orders', $values, array('order_id'=>$order_id));
			
		}else{			
			$values['status'] = 1;
			$values['created_by'] = get_user();
			$values['created_time'] = date("Y-m-d H:i:s");
			
			$order_id = $this->Common_model->insert_record('offline_orders', $values);
		}
	
			
		unset($values);


		$sku = $this->input->post('sku');
		$sku_desc = $this->input->post('sku_desc');
		$ean = $this->input->post('ean');
		$quantity = $this->input->post('quantity');
		$mrp = $this->input->post('mrp');
		$unit_price = $this->input->post('unit_price');
		$total_price = $this->input->post('total_price');
		if(!empty($sku)){
			
			$this->Common_model->delete_record('offline_order_products', array('order_id'=>$order_id));
			
			foreach($sku as $key => $tmp){
				if($tmp){
					$values['order_id'] = $order_id;
					$values['sku'] = trim($tmp);
					$values['sku_desc'] = trim($sku_desc[$key]);
					$values['ean'] = trim($ean[$key]);
					$values['quantity'] = trim($quantity[$key]);
					$values['mrp'] = trim($mrp[$key]);
					$values['unit_price'] = trim($unit_price[$key]);
					$values['total_price'] = trim($total_price[$key]);


					$this->Common_model->insert_record('offline_order_products', $values);
					unset($values);
				}
			}
		}
		
		redirect("web/offlineOrders");
	}
	
	
	public function offlineOrders($start = '',$end='',$ordernumber ='',$place ='',$status ='')
	{

		$sqldate = '';
		if($start && $end){
			$sqldate .= ' and o.order_date BETWEEN "'.(date("Y-m-d", strtotime($start))).'" and "'.(date("Y-m-d", strtotime($end))).'"';
		}
		
		if($ordernumber){
			$sqldate .= " and o.order_num = '$ordernumber'";
		}
		
		if($place){
			$sqldate .= " and o.place = '".str_replace("%20"," ",$place)."'";
		}
		if($status){
			$sqldate .= " and o.status = '$status'";
		}
		
		$data['start'] = $data['end'] = '';

		if($start)
			$data['start'] = $start;
		
		if($end)
			$data['end'] = $end;
		
		$data['ordernumber'] = $ordernumber;
		$data['place'] = $place;
		$data['status'] = $status;
		

		$sql = "select o.order_id as id, o.order_date, o.order_num,o.expiry_date,o.appointment,o.appointment_date_time,o.place,o.status,o.delivery_date,o.extended_date,o.factory_date, o.delivery_address, sum(op.quantity) as quantity, sum(op.total_price) as total from offline_orders
		o, offline_order_products op where o.status != 0 and o.order_id = op.order_id $sqldate group by o.order_id order by o.order_id desc;";	
		$orders = $this->db->query($sql);
		
      //$orders = $this->db->query($sql, [':place' => $place]);
		$data['orders'] = $orders->result();
		
			$data['delivery_place'] 	= $this->db->select('order_id,place')->group_by('place')->get('offline_orders')->result_array();
			
			$data['status_s'] 	= $this->db->select('order_id,status')->group_by('status')->get('offline_orders')->result_array();
			
		$this->load->view('web/offlineOrders', $data);
	}
	
	
	public function editOfflineOrder($id){
		
		$data['order'] = $this->Common_model->get_record('offline_orders','*',array('order_id'=>$id));
		$data['order_products'] = $this->Common_model->get_records('offline_order_products', '*', array('order_id'=>$id));

		$this->load->view('web/createOfflineOrder', $data);
	}
	
	public function deleteOfflineOrder($order_id){
		
		
		$this->Common_model->update_record('offline_orders', array('status'=>0), array('order_id'=>$order_id));
		
		redirect("web/offlineOrders");
	}
	
	public function viewOfflineOrder($id){
		
		$data['order'] = $this->Common_model->get_record('offline_orders', '*', array('order_id'=>$id));
		$data['grn'] = $this->Common_model->get_records('grn_files', '*', array('order_id'=>$id));
		$data['grn_number'] = $this->Common_model->get_records('grn_files', '*');
	    $data['fund'] = $this->Common_model->get_records('tbl_fund', '*', array('order_id'=>$id));
		
		$data['order_products'] = $this->Common_model->get_records('offline_order_products', '*', array('order_id'=>$id));

		$this->load->view('web/viewOfflineOrder', $data);
	}
	
	public function editviewOfflineOrder($order_id){
		
		$data['order'] = $this->Common_model->get_record('offline_orders', '*', array('order_id'=>$order_id));
		$data['order_products'] = $this->Common_model->get_records('offline_order_products', '*', array('order_id'=>$order_id));

		$this->load->view('web/viewOfflineOrder', $data);
		
	}
	
	
	public function savedispatch(){
		
		$where['order_id'] = $this->input->post('order_id');
		
		$values['dispatch_date'] = $this->input->post('dispatch_date');
		$values['status'] = 2;
		
		
		
		if(isset($_FILES['delivery_chalan']['name']) && $_FILES['delivery_chalan']['name']){
	        $config['upload_path']          = "assets/upload/purchase_order";
	    	$config['allowed_types']   = 'jpg|png|jpeg|pdf';
	    	$config['file_name'] = time().rand();        
	        
	        $this->load->library('upload', $config);
	        $this->upload->initialize($config);        
	        
	        if($this->upload->do_upload('delivery_chalan')){                
	            $fileData = $this->upload->data();

	            $ext = pathinfo($_FILES['delivery_chalan']['name'], PATHINFO_EXTENSION);
	            $values['delivery_chalan'] = $config['file_name'].".".$ext;	            
	        }			
			
			//echo "<pre>";
			//print_r($values['delivery_chalan']);
			//exit;
			 
        }	
		
		
		
		
		$this->Common_model->update_record('offline_orders', $values,$where);
		
		redirect("web/offlineOrders");
		
	}
	
	
	  public function saveappointment(){
		  
		$where['order_id'] = $this->input->post('order_id');
		
		$values['appointment'] = $this->input->post('yesno');
		
		$values['appointment_date_time'] = $this->input->post('appointment_date_time'); 

       //$values['appointment_date_time'] = date("Y-m-d", strtotime($values['appointment_date_time']));		
		  
		 $this->Common_model->update_record('offline_orders', $values ,$where);
		  
		  //echo"<pre>";
		 // print_r($values['appointment_date_time'] );
		  //exit;
		  
		  redirect("web/offlineOrders");
		  
	  }
	  
	  
	  public function savegrn(){ 
		  
					
			$grn_date = (!empty($this->input->post('grn_date'))) ? date('Y-m-d', strtotime($this->input->post('grn_date'))) : '';

			$values = array(
				'order_id' => $this->input->post('order_id'),
				'grn_name' => $this->input->post('grn_name'),
				'grn_number' => $this->input->post('grn_number'),
				'grn_date' => $grn_date,
			);

			$test_con = 0;
			$small_image = "";
			$output = array();

			if (isset($_FILES["grn_file"]["name"]) && !empty($_FILES["grn_file"]["name"])) {
				$image_info = getimagesize($_FILES["grn_file"]["tmp_name"]);
				$imageData1['imageName'] = 'grn_file';
				$extension = pathinfo($_FILES["grn_file"]["name"], PATHINFO_EXTENSION);
				$random_filename = uniqid() . '.' . $extension; // Generate a random filename
				$config['upload_path'] = "assets/upload/purchase_grn";
				$config['allowed_types'] = 'pdf';
				$config['file_name'] = $random_filename;
				$this->load->library('upload', $config);

				if (!$this->upload->do_upload('grn_file')) {
					$test_con = 1;
					$error = $this->upload->display_errors();
					$output = array(
						'status' => 'Error',
						'msg' => $error,
					);
				} else {
					$data = array('upload_data' => $this->upload->data());
					$test_con = 0;
					$values['grn_file'] = $random_filename; // Store the random filename in the database
				}
			}

			if ($test_con == 0) {
				$values['created_at'] = date('Y-m-d h:i:s');

				$this->Common_model->insert_record('grn_files', $values);

				$output = array(
					'status' => 'Success',
					'msg' => 'GRN File Updated Successfully',
				);
			} else {
				$output = array(
					'status' => 'Error',
					'msg' => $error,
				);
			}

				  
		}
				  
				  
	   public function factory(){
		  
		$where['order_id'] = $this->input->post('order_id');
		
		$values['factory_date'] = $this->input->post('factory_date'); 

		 $this->Common_model->update_record('offline_orders', $values ,$where);
		  
		 
		  redirect("web/offlineOrders");
		  
	  }
	  
	  
	    public function fund(){
		  
		$values['order_id'] = $this->input->post('order_id');
		
		$values['fund'] = $this->input->post('yesno');
		
		$values['grn_id'] = $this->input->post('grn_id');
		
		$values['fund_date'] = $this->input->post('fund_date'); 

		$values['amount'] = $this->input->post('amount'); 

       	
		 $this->Common_model->insert_record('tbl_fund', $values);
		  
		 
		  redirect("web/offlineOrders");
		  
	  }
	  
	  public function exceldownload(){

		  //echo "<pre>";
		 // print_r($array);
		 // exit;
		  
		  $array = array();
		  
		  $header = array('S.no','Order Date','Order Number','Delivery Date','Expiry Date','Address','SKU','SKU DESC','EAN','Quantity','MRP','UNIT PRICE','TOTAL PRICE','Dispatch Date','Appointment Date & Time');
		  
		  $array[] = $header;
		  
		   $filename = "export.csv";
		   $delimiter=",";
		   
		  // open raw memory as file so no temp files needed, you might run out of memory though
    $f = fopen('php://memory', 'w'); 
    // loop over the input array
	
   $offline_orders = $this->db->query("select o.order_id,o.order_date,o.order_num,o.delivery_date,o.expiry_date,o.delivery_address,op.sku,op.sku_desc,op.ean,op.quantity,op.mrp,op.unit_price,op.total_price,o.dispatch_date,o.appointment_date_time from offline_orders o, offline_order_products op where o.order_id = op.order_id and o.status <> 0");
   
     $offline_orders = $offline_orders->result_array();
		
		foreach($offline_orders as $order){
			
		$array[] = $order;
			
		}
		 
		   //$array = array(array($array));
		  
	
    foreach ($array as $line) { 
        // generate csv lines from the inner arrays
        fputcsv($f, $line, $delimiter); 
    }
    // reset the file pointer to the start of the file
    fseek($f, 0);
    // tell the browser it's going to be a csv file
    header('Content-Type: text/csv');
    // tell the browser we want to save it instead of displaying it
    header('Content-Disposition: attachment; filename="'.$filename.'";');
    // make php send the generated csv lines to the browser
    fpassthru($f);
	
	

		  
		  
	  }
	  
	  
	
	

	public function adminuser(){

			
		$data['keys'] = $this->Common_model->get_records('login', '*', array("id <>"=>1));
		$this->load->view('web/adminuser',$data);
	}
	
	
	public function submit_admin(){
		
		$row_id	 = $this->input->post('row_id');
		//echo "<pre>";
		//print_r($_POST);
		//exit;
		$data_arr = array(
			'username' 	=> $this->input->post('username'),
			'password' 	=> $this->input->post('password'),
			'status' => $this->input->post('status'),
		);
		/*if(!empty($password)){
				$password = password_hash($password,PASSWORD_BCRYPT);
				$data_arr['password'] = $password;
			}*/
		if(empty($row_id)){
			$data_arr['created_at'] = date('Y-m-d h:i:s');
			 $this->Common_model->insert_record('login',$data_arr);
			 
			 $user_id = $this->db->insert_id();
			 $output = array(
				'status'	=> 'Success',
				'msg'		=> 'Form Added Successfully',
			);
		}else{
			//$data_arr['updated_at'] = date('Y-m-d h:i:s');
			
			$where = "id='$row_id'";
			$this->Common_model->update_record('login',$data_arr,$where);
			
			$user_id = $row_id;
			$output = array(
				'status'	=> 'Success',
				'msg'		=> 'Updated Successfully',
			);
					
		}
		
		
		//echo "<pre>";
		//print_r($user_id);
		//exit;
	
		
		$values['user_id'] = $user_id ;
		$result = $this->common_model->delete_record('user_role',$values);
		$menu = $this->input->post("menu");
		$menu_id = $this->input->post("menu_id");
		$menu_permission_add = $this->input->post("menu_permission_add");
		$menu_permission_edit = $this->input->post("menu_permission_edit");
		$menu_permission_delete = $this->input->post("menu_permission_delete");
		$menu_permission_view = $this->input->post("menu_permission_view");
		
		foreach($menu_id as $m){
			

			
			$values['user_id'] = $user_id;
			
			$menudata = $this->Common_model->get_record('tbl_menu', '*',array('id'=>$m));
			$values['menu_name'] = $menudata->menu_name;
			$values['menu_id'] = $m;
			$values['menu_permission_add'] = isset($menu_permission_add[$m])?1:0;
			$values['menu_permission_edit'] = isset($menu_permission_edit[$m])?1:0;
			$values['menu_permission_delete'] = isset($menu_permission_delete[$m])?1:0;
			$values['menu_permission_view'] = isset($menu_permission_view[$m])?1:0;
			
		
			
							
			 $this->common_model->insert_record('user_role',$values);
		
		
	}
	echo json_encode($output);
			
        }
		
	 public function login_delete($id) {

        $result = $this->Common_model->delete_form($id);
	redirect("web/adminuser");

	}
	
		 public function login_edit($id) {
		 $data['keys'] = $this->Common_model->get_records('login', '*');
		 $data['edit'] = $this->Common_model->get_product($id);

		$this->load->view('web/adminuser',$data);
		 
		 
		 }
		 
		 	public function check_permission(){
		
	
		
		$id = $this->input->post("id");
		
		
		$roles = $this->Common_model->get_records('user_role', '*', array('user_id'=>$id));
		
		echo json_encode($roles);
		
	}
	 
	 public function ordernumbervalid(){
		
	$orderno = $this->input->post('ordernum');   
		   
		   
		  // echo"<pre>";
		  // print_r($_POST);
		  // exit;
		   
       $result = $this->Common_model->search($orderno);
		
		if($result != "" ){
			
			echo "This Purchase Order Is Already Exit";
			//
		}                                      
		
     else {
		 
        echo " ";
		
		
		
      }
	}
	

	public function salesreport($start = '',$end='',$ordernumber ='',$place ='',$status =''){

		$sqldate = '';
		if($start && $end){
			$sqldate .= ' and o.order_date BETWEEN "'.(date("Y-m-d", strtotime($start))).'" and "'.(date("Y-m-d", strtotime($end))).'"';
		}
		
		if($ordernumber){
			$sqldate .= " and o.order_num = '$ordernumber'";
		}
		
		if($place){
			$sqldate .= " and o.place = '$place'";
		}
		if($status){
			$sqldate .= " and o.status = '$status'";
		}
		
		$data['start'] = $data['end'] = '';

		if($start)
			$data['start'] = $start;
		
		if($end)
			$data['end'] = $end;
		
		$data['ordernumber'] = $ordernumber;
		$data['place'] = $place;
		$data['status'] = $status;
		

		$sql = "select o.order_id as id, o.order_date, o.order_num,o.expiry_date,o.appointment,o.appointment_date_time,o.place, o.status,o.delivery_date,o.extended_date,o.factory_date, o.delivery_address, sum(op.quantity) as quantity, sum(op.total_price) as total from offline_orders
		o, offline_order_products op where o.status != 0 and o.order_id = op.order_id $sqldate group by o.order_id order by o.order_id desc;";	
		$orders = $this->db->query($sql);

		$data['orders'] = $orders->result();
		
			$data['delivery_place'] 	= $this->db->select('order_id,place')->group_by('place')->get('offline_orders')->result_array();
			
			$data['status_s'] 	= $this->db->select('order_id,status')->group_by('status')->get('offline_orders')->result_array();
			
		$this->load->view('web/salesreport', $data);
	
	}
	
	
	public function paymentreport($start = '',$end='',$ordernumber ='',$place ='',$status =''){

		$sqldate = '';
		if($start && $end){
			$sqldate .= ' and o.order_date BETWEEN "'.(date("Y-m-d", strtotime($start))).'" and "'.(date("Y-m-d", strtotime($end))).'"';
		}
		
		if($ordernumber){
			$sqldate .= " and o.order_num = '$ordernumber'";
		}
		
		if($place){
			$sqldate .= " and o.place = '$place'";
		}
		if($status){
			$sqldate .= " and o.status = '$status'";
		}
		
		
		$data['start'] = $data['end'] = '';

		if($start)
			$data['start'] = $start;
		
		if($end)
			$data['end'] = $end;
		
		$data['ordernumber'] = $ordernumber;
		$data['place'] = $place;
		$data['status'] = $status;
	
		

		$sql = "select o.order_id as id, o.order_date, o.order_num,o.expiry_date,o.appointment,o.appointment_date_time,o.place, o.status,o.delivery_date,o.extended_date,o.factory_date, o.delivery_address, sum(op.quantity) as quantity, sum(op.total_price) as total from offline_orders
		o, offline_order_products op , grn_files gf  where o.status != 0 and o.order_id = op.order_id  $sqldate group by o.order_id order by o.order_id desc;";	
		$orders = $this->db->query($sql);

		$data['orders'] = $orders->result();
		
			$data['delivery_place'] 	= $this->db->select('order_id,place')->group_by('place')->get('offline_orders')->result_array();
			
			$data['status_s'] 	= $this->db->select('order_id,status')->group_by('status')->get('offline_orders')->result_array();
			
			
			
		$this->load->view('web/paymentreport', $data);
	
	}
	
	
	public function grn_pending() {
    
    $sql = "select o.order_id as id, o.order_date, o.order_num,o.expiry_date,o.appointment,o.appointment_date_time,o.place,o.status,o.delivery_date,o.extended_date,o.factory_date, o.delivery_address, sum(op.quantity) as quantity, sum(op.total_price) as total from offline_orders
		o, offline_order_products op  where o.status != 0 and o.order_id = op.order_id group by o.order_id order by o.order_id desc;";	
			
	$data['orders'] = $this->db->query($sql)->result();

	$this->load->view('web/grn_pending', $data);

	}
	
	
	
	public function product_report($start = '', $end = ''){
    
   
    $data['start'] = $start;
    $data['end'] = $end;
	
    $sql = "SELECT sum(quantity) as quantity, sku_desc,order_date, sku FROM offline_orders o, offline_order_products op where o.order_date between '".date("Y-m-d", strtotime($start))."' and '".date("Y-m-d", strtotime($end))."' and o.order_id = op.order_id group by sku";
    
    $orders = $this->db->query($sql);
    
    $data['orders'] = $orders->result();
	
	//print_r($data);
    
    $this->load->view('web/product_report', $data);
  }

}