/opensourcepos/application/controllers/procurement.php

Large files files are truncated, but you can click here to view the full file

<?php
require_once ("secure_area.php");

class Procurement extends Secure_area 
{
        private $user;
        private $username;
        
	function __construct()
	{
    		parent::__construct('procurement');
                $this->load->model('Purchase_order_master');
                $this->load->model('Purchase_invoice_master');
                $this->load->model('Purchase_invoice_item');
                $this->load->model('Purchase_order_item');
                $this->load->model('Purchase_quote_master');
                $this->load->model('Purchase_quote_item');
                $this->load->model('Receipt_master');
                $this->load->model('Receipt_item');
                $this->load->model('Delivery_point');
                $this->load->model('Product_price');
                $this->load->model('Outgoing_payment');
//                $this->load->model('acl/User','Userview');
                $this->user= $this->User->get_logged_in_employee_info();
                $this->username = $this->user->last_name." ".$this->user->first_name;
                $param = array('user' => $this->user->username);
                $this->load->library('acl-library/Acl',$param,'Acl');
                
	}
        
        /* PURCHASE QUOTE GRID START */
        
	function index()
	{
            $users = $this->User->getAllUsersByRole(null,array('field_name'=>'role_name',array('Everyone','Guest')));
            
            foreach($users as $user) { 
                $user_id=$user["person_id"]; 
                $username=$user["username"]; 
                //$value = $denom["denom_json"];
                if (!empty($user_id)){
                    $userOptions.="<OPTION VALUE=\"$user_id\">".$username; 
                }             
            } 
            $data['userOptions'] = $userOptions;
            $this->load->view("procurement/quote/purchase_quote_grid",$data);
	}
        
        
       /* common functions */
        function populateSuppliers(){
            $suppliers= $this->Supplier->getAll();
            foreach($suppliers as $supplier) { 

                $id=$supplier["id"]; 
                $thing=$supplier["supplier_name"]; 
                $supplieroptions.="<OPTION VALUE=\"$id\">".$thing; 
            } 
            echo $supplieroptions;
        }
        
        function getCostPrice(){
            $id = $_REQUEST['productid'];
            $productDetails = $this->Product_price->getByProductId($id);
            echo $productDetails->cost_price;
        }
        
        /* end common */
        
        /*start quote */
        
        function populateRFQ(){
           $page = $_REQUEST['page'];
           $limit = $_REQUEST['rows'];
           $sidx = $_REQUEST['sidx'];
           $sord = $_REQUEST['sord'];
           $searchOn = $_REQUEST['_search'];
           $status = $_REQUEST['status'];
           //$where = array('status'=>'rfq');
           if ($status!=self::ALL){
               $where['owner_id'] = $this->user->person_id;
               $where['status'] = $status;
           }
           
           
            
           //standard response parameters 
           $quotedata = array();
           $count = $this->Purchase_quote_master->totalNoOfRows($where);
           if( $count > 0 && $limit > 0) { 
               $total_pages = ceil($count/$limit); 
           } else { 
               $total_pages = 0; 
           } 
           if ($page > $total_pages) $page=$total_pages;

           $start = $limit*$page - $limit;
 
            // if for some reasons start position is negative set it to 0 
            // typical case is that the user type 0 for the requested page 
           if($start <0) $start = 0; 
           $clauses = array('orderBy'=>$sidx,'orderDir'=>$sord,'startLimit'=>$start,'limit'=>$limit);
            
           $data['total'] = $total_pages;
           $data['page'] = $page;
           $data['records'] = $count; 
           if($searchOn=='true') {
                
                $filters = json_decode($_REQUEST['filters'],true);
                $groupOp = $filters['groupOp'];
                $rules = $filters['rules'];
                $like_condition = array();
                foreach ($rules as $rule){
                    $field = $rule['field'];
                    $op= $rule['op'];
                    $input = $rule['data'];
                    $like_condition[$field] = trim($input);
                }
                $quotes = $this->Purchase_quote_master->getAll(false,$where,$clauses,$like_condition);
            }
            else {
                $quotes = $this->Purchase_quote_master->getAll(false,$where);
            }
           
           foreach ($quotes as $dp){
               if ($status==self::WAITING_FOR_APPROVAL){
                   /* we dont need actions column in approval grid . So not passing the blank */
                   array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['reference'],$dp['supplier_name'],$dp['estimated_value'],$dp['status'],$dp['raised_by_name'],$dp['owner_name'],$dp['needed_by_date'])));
               }
               else if ($status==self::REJECTED){
                   /* Add Extra Columns Rejected and Rejected Notes Remove Status */
                   array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['reference'],$dp['supplier_name'],$dp['estimated_value'],$dp['raised_by_name'],$dp['owner_name'],$dp['needed_by_date'],$dp['approved_by_name'],$dp['approval_notes'])));
               }
               else if ($status==self::OPEN){
                   array_push($quotedata, array('id'=> $dp['id'],'dprow' => array('',$dp['reference'],$dp['supplier_name'],$dp['estimated_value'],$dp['status'],$dp['raised_by_name'],$dp['owner_name'],$dp['needed_by_date'])));
               }
               else {
                   array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['reference'],$dp['supplier_name'],$dp['estimated_value'],$dp['status'],$dp['raised_by_name'],$dp['owner_name'],$dp['needed_by_date'],$dp['notes'],$dp['approved_by_name'],$dp['approval_notes'])));
               }
           }
           $data['quotedata'] = $quotedata;
           echo json_encode($data);
        }
        
        
        function createRFQ(){
            $id = $_REQUEST['quoteId'];
            $purchase_quote_data['supplier_id'] = $_REQUEST['supplierId'];
            $purchase_quote_data['warehouse_id'] = $_REQUEST['warehouseId'];
            $dateObj = DateTime::createFromFormat('d/m/Y', $_REQUEST['reqdate']);
            log_message('debug','converted '.$dateObj->format('Y-m-d'));
            $purchase_quote_data['needed_by_date'] = $dateObj->format('Y-m-d');
            $purchase_quote_data['notes'] = $_REQUEST['notes'];
            $purchase_quote_data['owner_id'] = $this->user->person_id;
            
            if (empty($id)){
                $purchase_quote_data['raised_by'] = $this->user->person_id;
                $id =  $this->Purchase_quote_master->createQuote($purchase_quote_data);
            }
            else {
                $where_clause = array('id'=>$id);
                $this->Purchase_quote_master->update($where_clause, $purchase_quote_data);
            }
            echo $id;
        }
        //this function validates the record after close button of dialog being pressed. If no items are aadded the record is deleted
        function closeValidate(){
            $id = $_REQUEST['id'];   
            
            if (!empty($id)){
                $ifExists = $this->Purchase_quote_master->exists($id);
                if ($ifExists){

                    $where_clause_quote = array('id'=>$id);
                    $this->Purchase_quote_master->update($where_clause_quote,array('status'=>self::CANCELLED));

                    $where_clause_quote_item = array('quote_id'=>$id);
                    $this->Purchase_quote_item->update($where_clause_quote_item,array('status'=>self::CANCELLED));
                }
            }
           
            
        }
        
        function modifyQuote (){
            $id = $_REQUEST['id'];
            
            $oper = $_REQUEST['oper'];
            $this->db->trans_start();
            if ($oper=='edit'){
                //$dateObj = DateTime::createFromFormat('d/m/Y', $_REQUEST['needed_by_date']);
                //log_message('debug','converted item date '.$dateObj->format('Y-m-d'));
                $purchase_quote_data['needed_by_date'] = $_REQUEST['needed_by_date'];
                //while editing the supplier id is passed.
                $purchase_quote_data['supplier_id'] = $_REQUEST['supplier_name'];
                $where_clause_quote = array('id'=>$id);
                
                $this->Purchase_quote_master->update($where_clause_quote,$purchase_quote_data);
                
            }
            else if ($oper=='del'){
                $idAraay =  explode(",", $id);
                foreach($idAraay as $tempId){
                    $where_clause_quote = array('id'=>$tempId);
                    $this->Purchase_quote_master->update($where_clause_quote,array('status'=>'cancelled'));

                    $where_clause_quote_item = array('quote_id'=>$tempId);
                    $this->Purchase_quote_item->update($where_clause_quote_item,array('status'=>'cancelled'));
                }
                
            }
            $this->db->trans_complete();
        }
//        
	function testdate(){
//            $date = '25/10/2012';
//            $dateObj = DateTime::createFromFormat('d/m/Y', $date);
//            $mysqldt =  $dateObj->format('Y-m-d');
            echo date("Y-m-d H:i:s", time());
        }
        
        function addQuoteItem (){
            //$id = $_REQUEST['quoteId'];
            $product_id = $_REQUEST['productid'];
            $purchase_quote_data['quote_id'] = $_REQUEST['quoteid'];
            $purchase_quote_data['product_id'] = $product_id;
            $dateObj = DateTime::createFromFormat('d/m/Y', $_REQUEST['needeedByDate']);
            log_message('debug','converted item date '.$dateObj->format('Y-m-d'));
            $purchase_quote_data['needed_by_date'] = $dateObj->format('Y-m-d');
            $purchase_quote_data['quoted_quantity'] = $_REQUEST['quantity'];
            $purchase_quote_data['expected_price'] = $_REQUEST['exprice'];
            $purchase_quote_data['estimated_value'] = $_REQUEST['quantity']*$_REQUEST['exprice'];
            $purchase_quote_data['comments'] = $_REQUEST['descItem'];
            $productDetails = $this->Product->getByProductId($product_id);
            $purchase_quote_data['sku'] = $productDetails->barcode;
            $purchase_quote_data['name'] = $productDetails->product_name;
            $id =  $this->createQuoteItem($purchase_quote_data);
        }
        //business logic
        function createQuoteItem($purchase_quote_data){
            $this->db->trans_start();
            /* insert into quote item */
            
            $this->Purchase_quote_item->insert($purchase_quote_data);
            log_message('debug','insert statement ='.$this->db->last_query());
            $id = $this->db->insert_id();
            /* end insert  */
            
            /* update reference number in  quote item */
            $where_clause = array('id'=>$id);
            $this->Purchase_quote_item->update($where_clause, array('reference' => 10000000 + $id));
            /* end update */
            
            /* update estimated value in quote master */
            $quote_id = $purchase_quote_data['quote_id'];
            $quote_details=$this->Purchase_quote_master->getById($quote_id);
            $estimated_value = $quote_details->estimated_value + $purchase_quote_data['estimated_value'];
            $this->Purchase_quote_master->update(array('id'=>$quote_id),array('estimated_value'=>$estimated_value));
            log_message('debug','update statement ='.$this->db->last_query());
            /* end update estimated value in quote master */
            
            $this->db->trans_complete();
            return $id;
        }
        function modifyQuoteItem (){
            $id = $_REQUEST['id'];
            $item_details=$this->Purchase_quote_item->getById($id);
            $quote_id = $item_details->quote_id;
            $current_est_value = $item_details->estimated_value;
            $oper = $_REQUEST['oper'];
            $this->db->trans_start();
            if ($oper=='edit'){
                //$dateObj = DateTime::createFromFormat('d/m/Y', $_REQUEST['needed_by_date']);
                //log_message('debug','converted item date '.$dateObj->format('Y-m-d'));
                $purchase_quote_data['needed_by_date'] = $_REQUEST['needed_by_date'];
                $purchase_quote_data['quoted_quantity'] = $_REQUEST['quoted_quantity'];
                $purchase_quote_data['expected_price'] = $_REQUEST['expected_price'];
                $purchase_quote_data['comments'] = $_REQUEST['comments'];
                $purchase_quote_data['estimated_value'] = $_REQUEST['quoted_quantity']*$_REQUEST['expected_price'];

                $where_clause = array('id'=>$id);
                
                $this->Purchase_quote_item->update($where_clause,$purchase_quote_data);
                
                $quote_details=$this->Purchase_quote_master->getById($quote_id);
                $estimated_value = $quote_details->estimated_value - $current_est_value + $purchase_quote_data['estimated_value'];
                $this->Purchase_quote_master->update(array('id'=>$quote_id),array('estimated_value'=>$estimated_value));
            }
            else if ($oper=='del'){
                $quote_details=$this->Purchase_quote_master->getById($quote_id);
                $estimated_value = $quote_details->estimated_value - $item_details->estimated_value;
                $this->Purchase_quote_master->update(array('id'=>$quote_id),array('estimated_value'=>$estimated_value));
                $where_clause = array('id'=>$id);
                
                $this->Purchase_quote_item->update($where_clause,array('status'=>'cancelled'));
            }
            $this->db->trans_complete();
            
        }
        
        function populateQuoteItems(){
            $quoteid = $_REQUEST['quoteId'];
            if (!empty($quoteid)){
                $page = $_REQUEST['page'];
                $limit = $_REQUEST['rows'];
                $sidx = $_REQUEST['sidx'];
                $sord = $_REQUEST['sord'];

                //standard response parameters 

                $quotedata = array();
                $where = array('quote_id' => $quoteid );
                $count = $this->Purchase_quote_item->totalNoOfRows($where);
                if( $count > 0 && $limit > 0) { 
                    $total_pages = ceil($count/$limit); 
                } else { 
                    $total_pages = 0; 
                } 
                if ($page > $total_pages) $page=$total_pages;

                $start = $limit*$page - $limit;

                 // if for some reasons start position is negative set it to 0 
                 // typical case is that the user type 0 for the requested page 
                if($start <0) $start = 0; 
                $clauses = array('orderBy'=>$sidx,'orderDir'=>$sord,'startLimit'=>$start,'limit'=>$limit);

                $data['total'] = $total_pages;
                $data['page'] = $page;
                $data['records'] = $count; 

                $quotes = $this->Purchase_quote_item->getAll(false,$where);

                foreach ($quotes as $dp){
                    array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['name'],$dp['quoted_quantity'],$dp['needed_by_date'],$dp['expected_price'],$dp['estimated_value'],$dp['comments'])));
                }
                $data['quoteitemdata'] = $quotedata;
                echo json_encode($data);
           }
           
        }
        
        function generatePOFromRFQ(){
            $ids= $_REQUEST['ids'];
            
            foreach($ids as $id){
                
                log_message('debug',' id '.$id);
                $quote_details=$this->Purchase_quote_master->getById($id,true);
                if ($quote_details['status']==self::OPEN ||$quote_details['status']==self::WAITING_FOR_APPROVAL ) {
                    $this->db->trans_start();
                    $this->Purchase_quote_master->update(array('id'=>$id),array('approved_by'=>$this->user->person_id));
                    $this->generatePOInternal($quote_details);
                    $this->db->trans_complete();
                }
                 
            }
           
        }
        /* PURCHASE QUOTE GRID END*/
        
        /* APPROVAL GRUD START */
        
        function approveOrReject(){
            $id= $_REQUEST['quoteId'];
            $action= $_REQUEST['action'];
            log_message('debug',' id '.$id);
            log_message('debug',' action '.$action);
            $quote_details=$this->Purchase_quote_master->getById($id,true);
            if ($quote_details['status']==self::WAITING_FOR_APPROVAL ) {
                if ($action == 'approve'){
                    $this->db->trans_start();
                    $this->Purchase_quote_master->update(array('id'=>$id),array('approved_by'=>$this->user->person_id,'approval_notes'=>$_REQUEST['quote_approval_notes']));
                    $this->generatePOInternal($quote_details);
                    $this->db->trans_complete();
                }
                else if ($action == 'reject'){
                    $this->db->trans_start();
                    $this->Purchase_quote_master->update(array('id'=>$id),array('status'=>self::REJECTED,'approved_by'=>$this->user->person_id,'approval_notes'=>$_REQUEST['quote_approval_notes']));
                    $item_details=$this->Purchase_quote_item->getByQuoteId($id);
                    foreach ($item_details as $item_data){
                        
                            $this->Purchase_quote_item->update(array('id'=>$item_data['id']),array('status'=>self::REJECTED));
                        
                    }
                    $this->db->trans_complete();
                }
                
            }
 
        }
        
        /* APPROVAL GRID END */
        
        /* REJECTED GRID START*/
        function reopenRFQ (){
            $ids= $_REQUEST['ids'];
            
            foreach($ids as $id){
                
                log_message('debug',' id '.$id);
                $quote_details=$this->Purchase_quote_master->getById($id,true);
                if ($quote_details['status']==self::REJECTED ) {
                    $this->db->trans_start();
                    $this->Purchase_quote_master->update(array('id'=>$id),array('status'=>self::OPEN,'last_updated_by'=>$this->user->person_id));
                    $item_details=$this->Purchase_quote_item->getByQuoteId($id);
                    foreach ($item_details as $item_data){
                        
                            $this->Purchase_quote_item->update(array('id'=>$item_data['id']),array('status'=>self::OPEN));
                        
                    }
                    $this->db->trans_complete();
                }
                 
            }
        }
        /* REJECTED GRID END*/
        
        /* COMMON FUNCTIONS FOR RFQ GRIDS  */
        private function generatePOInternal($quote_details){
            
            $id=$quote_details['id'];
            $order_data['owner_id'] = $quote_details['owner_id'];
            $order_data['needed_by_date'] = $quote_details['needed_by_date'];
            $order_data['generated_by'] = $this->user->person_id;
            $order_data['quote_id'] = $quote_details['id'];
            log_message('debug',json_encode($order_data));
            $order_id = $this->Purchase_order_master->createOrder($order_data);
            log_message('debug',$this->db->last_query());
            $this->Purchase_quote_master->update(array('id'=>$id),array('status'=>self::ORDERED,'order_id'=>$order_id));
            log_message('debug',$this->db->last_query());
            //now update line item status
            $item_details=$this->Purchase_quote_item->getByQuoteId($id);
            foreach ($item_details as $item_data){
                if ($item_data['status'] == self::OPEN || $item_data['status'] == self::WAITING_FOR_APPROVAL){
                    $order_item_data['name'] = $item_data['name'];
                    $order_item_data['sku'] = $item_data['sku'];
                    $order_item_data['product_id'] = $item_data['product_id'];
                    $order_item_data['estimated_value'] = $item_data['estimated_value'];
                    $order_item_data['needed_by_date'] = $item_data['needed_by_date'];
                    $order_item_data['quoted_quantity'] = $item_data['quoted_quantity'];
                    //repeatative ..as of now as no difference between quoted and ordered quantity
                    $order_item_data['ordered_quantity'] = $item_data['quoted_quantity'];
                    $order_item_data['expected_price'] = $item_data['expected_price'];
                    $order_item_data['order_id'] =$order_id;
                    $order_item_data['quote_line_id'] = $item_data['id'];
                    $order_line_id = $this->createOrderItem($order_item_data);
                    $this->Purchase_quote_item->update(array('id'=>$item_data['id']),array('status'=>self::ORDERED,'order_line_id'=>$order_line_id));
                }
            }
            
        }
        
        /*end quote */
        
        /* RECEIVING GRID START */
        
        function populatePOToReceive(){
            $person_id = $this->user->person_id;
            $in_where=array('field_name'=>'status','id_array'=>array(self::OPEN,self::RECEIVING)) ;
            $this->populatePOInternal($person_id,$in_where);
            
        }
        
        /* RECEIVING GRID END */
        
        function populatePayments(){
            $invoiceId = $_REQUEST['invoiceId'];
            if (!empty($invoiceId)){
                $page = $_REQUEST['page'];
                $limit = $_REQUEST['rows'];
                $sidx = $_REQUEST['sidx'];
                $sord = $_REQUEST['sord'];

                //standard response parameters 

                $quotedata = array();
                $where = array('invoice_id' => $invoiceId );
                $count = $this->Outgoing_payment->totalNoOfRows($where);
                if( $count > 0 && $limit > 0) { 
                    $total_pages = ceil($count/$limit); 
                } else { 
                    $total_pages = 0; 
                } 
                if ($page > $total_pages) $page=$total_pages;

                $start = $limit*$page - $limit;

                 // if for some reasons start position is negative set it to 0 
                 // typical case is that the user type 0 for the requested page 
                if($start <0) $start = 0; 
                $clauses = array('orderBy'=>$sidx,'orderDir'=>$sord,'startLimit'=>$start,'limit'=>$limit);

                $data['total'] = $total_pages;
                $data['page'] = $page;
                $data['records'] = $count; 

                $quotes = $this->Outgoing_payment->getAll(false,$where);

                foreach ($quotes as $dp){
                    array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['payment_reference'],$dp['payment_type'],$dp['amount'],$dp['comments'])));
                }
                $data['quoteitemdata'] = $quotedata;
                echo json_encode($data);
            }
        }
        
        
        function populateReceived(){
           $person_id = $this->user->person_id;
           
           $in_where=array('field_name'=>'status','id_array'=>array(self::RECEIVED)) ;
           // for Invoices to Pay Grid ..Override Status
           $invoice_id = $_REQUEST['invoiceId'];
           if (!empty($invoice_id)){
               $where['invoice_id'] = $invoice_id;
               $in_where=array('field_name'=>'status','id_array'=>array(self::INVOICED)) ;
           }
           
           
           $page = $_REQUEST['page'];
           $limit = $_REQUEST['rows'];
           $sidx = $_REQUEST['sidx'];
           $sord = $_REQUEST['sord'];
           $searchOn = $_REQUEST['_search'];
           
           if (!empty($person_id)){
                $where['owner_id'] = $person_id;
           }
           
           //standard response parameters 
           $quotedata = array();
           $count = $this->Receipt_master->totalNoOfRows($where);
           if( $count > 0 && $limit > 0) { 
               $total_pages = ceil($count/$limit); 
           } else { 
               $total_pages = 0; 
           } 
           if ($page > $total_pages) $page=$total_pages;

           $start = $limit*$page - $limit;
 
            // if for some reasons start position is negative set it to 0 
            // typical case is that the user type 0 for the requested page 
           if($start <0) $start = 0; 
           $clauses = array('orderBy'=>$sidx,'orderDir'=>$sord,'startLimit'=>$start,'limit'=>$limit);
            
           $data['total'] = $total_pages;
           $data['page'] = $page;
           $data['records'] = $count; 
           if($searchOn=='true') {
                
                $filters = json_decode($_REQUEST['filters'],true);
                $groupOp = $filters['groupOp'];
                $rules = $filters['rules'];
                $like_condition = array();
                foreach ($rules as $rule){
                    $field = $rule['field'];
                    $op= $rule['op'];
                    $input = $rule['data'];
                    if ($field == 'order_reference' ){
                        $orderDetails = $this->Purchase_order_master->getGridByReference($input);
                        $like_condition['order_id'] = $orderDetails['id'];
                    }
                    else if ($field == 'quote_reference'){
                        $orderDetails = $this->Purchase_order_master->getGridByQuoteReference($input);
                        $like_condition['order_id'] = $orderDetails['id'];
                    }
                    else if ($field == 'supplier_name'){
                        $supplierDetails = $this->Supplier->getByName($input);
                        $like_condition['supplier_id'] = $supplierDetails['id'];
                    }
                    else {
                        $like_condition[$field] = trim($input);
                    }
                    
                }
                $quotes = $this->Receipt_master->getAll(false,$where,null,$clauses,$like_condition,$in_where);
            }
            else {
                $quotes = $this->Receipt_master->getAll(false,$where,null,null,null,$in_where);
            }
           
           foreach ($quotes as $dp){
               $orderDetails = $this->Purchase_order_master->getGridById($dp['order_id']);
               array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['reference'],$dp['supplier_receipt_number'],$orderDetails['supplier_name'],$dp['status'],$dp['order_id'],$orderDetails['reference'],$orderDetails['quote_reference'])));
           }
           $data['quotedata'] = $quotedata;
           echo json_encode($data);
        }
        
       
        
        function populatePOInternal($person_id,$in_where){
           $page = $_REQUEST['page'];
           $limit = $_REQUEST['rows'];
           $sidx = $_REQUEST['sidx'];
           $sord = $_REQUEST['sord'];
           $searchOn = $_REQUEST['_search'];
           
           if (!empty($person_id)){
                $where['owner_id'] = $person_id;
           }
           
           //standard response parameters 
           $quotedata = array();
           $count = $this->Purchase_order_master->totalNoOfRows($where);
           if( $count > 0 && $limit > 0) { 
               $total_pages = ceil($count/$limit); 
           } else { 
               $total_pages = 0; 
           } 
           if ($page > $total_pages) $page=$total_pages;

           $start = $limit*$page - $limit;
 
            // if for some reasons start position is negative set it to 0 
            // typical case is that the user type 0 for the requested page 
           if($start <0) $start = 0; 
           $clauses = array('orderBy'=>$sidx,'orderDir'=>$sord,'startLimit'=>$start,'limit'=>$limit);
            
           $data['total'] = $total_pages;
           $data['page'] = $page;
           $data['records'] = $count; 
           if($searchOn=='true') {
                
                $filters = json_decode($_REQUEST['filters'],true);
                $groupOp = $filters['groupOp'];
                $rules = $filters['rules'];
                $like_condition = array();
                foreach ($rules as $rule){
                    $field = $rule['field'];
                    $op= $rule['op'];
                    $input = $rule['data'];
                    $like_condition[$field] = trim($input);
                }
                $quotes = $this->Purchase_order_master->getAll(false,$where,$clauses,$like_condition,$in_where);
            }
            else {
                $quotes = $this->Purchase_order_master->getAll(false,$where,null,null,$in_where);
            }
           
           foreach ($quotes as $dp){
               array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['reference'],$dp['supplier_id'],$dp['supplier_name'],$dp['estimated_value'],$dp['status'],$dp['raised_by_name'],$dp['needed_by_date'])));
           }
           $data['quotedata'] = $quotedata;
           echo json_encode($data);
        }
        
        
        function validateReceiving(){
            $order_id = $_REQUEST['order_id'];
            $receiving_notes = $_REQUEST['receiving_notes'];
            //check the no of order line items with status receiving. 
            $totalNoOfRowsByOrderIdReceived = $this->Purchase_order_item->totalNoOfRows(array('order_id'=>$order_id,'status'=>self::RECEIVED));
             $totalNoOfRowsByOrderIdTotal = $this->Purchase_order_item->totalNoOfRows(array('order_id'=>$order_id));
             if ($totalNoOfRowsByOrderIdReceived == $totalNoOfRowsByOrderIdTotal){
                 // all the order lines are received       
                 
                 $this->Purchase_order_master->update(array('id'=>$order_id,'status'=>self::RECEIVING),array('status'=>self::RECEIVED,'receiving_notes'=>$receiving_notes));
                 $this->Receipt_master->update(array('order_id'=>$order_id,'status'=>self::RECEIVING),array('status'=>self::RECEIVED));
             }
             else {
                  $this->Purchase_order_master->update(array('id'=>$order_id,'status'=>self::RECEIVING),array('receiving_notes'=>$receiving_notes));
             }
            

        }
//        function validateReceivingc
//            $order_id = $_REQUEST['order_id'];
//            $receiving_notes = $_REQUEST['receiving_notes'];
//            //check the no of order line items with status receiving. 
//            $totalNoOfRowsByOrderIdReceived = $this->Purchase_order_item->totalNoOfRows(array('order_id'=>$order_id,'status'=>self::RECEIVING));
//             $totalNoOfRowsByOrderIdOpen = $this->Purchase_order_item->totalNoOfRows(array('order_id'=>$order_id,'status'=>self::OPEN));
//             if ($totalNoOfRowsByOrderIdReceiving == 0 && $totalNoOfRowsByOrderIdOpen==0){
//                 // none of the line items are in Open or receiving State        
//                 
//                 $this->Purchase_order_master->update(array('id'=>$order_id,'status'=>self::RECEIVING),array('status'=>self::RECEIVED,'receiving_notes'=>$receiving_notes));
//                 $this->Receipt_master->update(array('order_id'=>$order_id,'status'=>self::RECEIVING),array('status'=>self::RECEIVED));
//             }
//             else {
//                  $this->Purchase_order_master->update(array('id'=>$order_id,'status'=>self::RECEIVING),array('receiving_notes'=>$receiving_notes));
//             }
//            
//
//        }
        
        function modifyOrder (){
            $id = $_REQUEST['id'];
            
            $oper = $_REQUEST['oper'];
            $this->db->trans_start();
            if ($oper=='edit'){
                //$dateObj = DateTime::createFromFormat('d/m/Y', $_REQUEST['needed_by_date']);
                //log_message('debug','converted item date '.$dateObj->format('Y-m-d'));
                $purchase_quote_data['needed_by_date'] = $_REQUEST['needed_by_date'];
                $purchase_quote_data['supplier_name'] = $_REQUEST['supplier_name'];
                $where_clause_quote = array('id'=>$id);
                
                $this->Purchase_quote_master->update($where_clause_quote,$purchase_quote_data);
                
            }
            else if ($oper=='del'){
                $idAraay =  explode(",", $id);
                foreach($idAraay as $tempId){
                    $where_clause_quote = array('id'=>$tempId);
                    $this->Purchase_quote_master->update($where_clause_quote,array('status'=>'cancelled'));

                    $where_clause_quote_item = array('quote_id'=>$tempId);
                    $this->Purchase_quote_item->update($where_clause_quote_item,array('status'=>'cancelled'));
                }
                
            }
            $this->db->trans_complete();
        }
        
        function addOrderItem (){
            //$id = $_REQUEST['quoteId'];
            $product_id = $_REQUEST['productid'];
            $purchase_quote_data['quote_id'] = $_REQUEST['orderId'];
            $purchase_quote_data['product_id'] = $product_id;
            $dateObj = DateTime::createFromFormat('d/m/Y', $_REQUEST['needeedByDate']);
            log_message('debug','converted item date '.$dateObj->format('Y-m-d'));
            $purchase_quote_data['needed_by_date'] = $dateObj->format('Y-m-d');
            $purchase_quote_data['quoted_quantity'] = $_REQUEST['quantity'];
            $purchase_quote_data['expected_price'] = $_REQUEST['exprice'];
            $purchase_quote_data['estimated_value'] = $_REQUEST['quantity']*$_REQUEST['exprice'];
            $purchase_quote_data['comments'] = $_REQUEST['descItem'];
            $productDetails = $this->Product->getByProductId($product_id);
            $purchase_quote_data['sku'] = $productDetails->barcode;
            $purchase_quote_data['name'] = $productDetails->product_name;
            $id =  $this->createQuoteItem($purchase_quote_data);
        }
        //business logic
        function createOrderItem($purchase_quote_data){
            $this->db->trans_start();
            /* insert into quote item */
            
            $this->Purchase_order_item->insert($purchase_quote_data);
            log_message('debug','insert statement ='.$this->db->last_query());
            $id = $this->db->insert_id();
            /* end insert  */
            
            /* update reference number in  quote item */
            $where_clause = array('id'=>$id);
            $this->Purchase_order_item->update($where_clause, array('reference' => 10000000 + $id));
            /* end update */
            
            $this->db->trans_complete();
            return $id;
        }
        function modifyOrderItem (){
            $id = $_REQUEST['id'];
            $item_details=$this->Purchase_quote_item->getById($id);
            $quote_id = $item_details->quote_id;
            $current_est_value = $item_details->estimated_value;
            $oper = $_REQUEST['oper'];
            $this->db->trans_start();
            if ($oper=='edit'){
                //$dateObj = DateTime::createFromFormat('d/m/Y', $_REQUEST['needed_by_date']);
                //log_message('debug','converted item date '.$dateObj->format('Y-m-d'));
                $purchase_quote_data['needed_by_date'] = $_REQUEST['needed_by_date'];
                $purchase_quote_data['quoted_quantity'] = $_REQUEST['quoted_quantity'];
                $purchase_quote_data['expected_price'] = $_REQUEST['expected_price'];
                $purchase_quote_data['comments'] = $_REQUEST['comments'];
                $purchase_quote_data['estimated_value'] = $_REQUEST['quoted_quantity']*$_REQUEST['expected_price'];

                $where_clause = array('id'=>$id);
                
                $this->Purchase_quote_item->update($where_clause,$purchase_quote_data);
                
                $quote_details=$this->Purchase_quote_master->getById($quote_id);
                $estimated_value = $quote_details->estimated_value - $current_est_value + $purchase_quote_data['estimated_value'];
                $this->Purchase_quote_master->update(array('id'=>$quote_id),array('estimated_value'=>$estimated_value));
            }
            else if ($oper=='del'){
                $quote_details=$this->Purchase_quote_master->getById($quote_id);
                $estimated_value = $quote_details->estimated_value - $item_details->estimated_value;
                $this->Purchase_quote_master->update(array('id'=>$quote_id),array('estimated_value'=>$estimated_value));
                $where_clause = array('id'=>$id);
                
                $this->Purchase_quote_item->update($where_clause,array('status'=>'cancelled'));
            }
            $this->db->trans_complete();
            
        }
        
        function populateOrderItems(){
            $orderid = $_REQUEST['orderId'];
            if (!empty($orderid)){
                $page = $_REQUEST['page'];
                $limit = $_REQUEST['rows'];
                $sidx = $_REQUEST['sidx'];
                $sord = $_REQUEST['sord'];

                //standard response parameters 

                $quotedata = array();
                $where = array('order_id' => $orderid );
                $count = $this->Purchase_order_item->totalNoOfRows($where);
                if( $count > 0 && $limit > 0) { 
                    $total_pages = ceil($count/$limit); 
                } else { 
                    $total_pages = 0; 
                } 
                if ($page > $total_pages) $page=$total_pages;

                $start = $limit*$page - $limit;

                 // if for some reasons start position is negative set it to 0 
                 // typical case is that the user type 0 for the requested page 
                if($start <0) $start = 0; 
                $clauses = array('orderBy'=>$sidx,'orderDir'=>$sord,'startLimit'=>$start,'limit'=>$limit);

                $data['total'] = $total_pages;
                $data['page'] = $page;
                $data['records'] = $count; 

                $quotes = $this->Purchase_order_item->getAll(false,$where);

                foreach ($quotes as $dp){
                    array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($dp['product_id'],$dp['name'],$dp['quoted_quantity'],$dp['received_quantity'],$dp['returned_quantity'],$dp['needed_by_date'],$dp['expected_price'],$dp['estimated_value'],$dp['received_value'],$dp['returned_value'],$dp['comments'])));
                }
                $data['orderitemdata'] = $quotedata;
                echo json_encode($data);
           }         
           
        }
        
        function populateReceiptItems(){
            $receiptId = $_REQUEST['receiptId'];
            $orderLineId = $_REQUEST['orderLineId'];
            // as of now keep default oper as "receipt"
            $oper = "receipt";
            
            if (!empty($_REQUEST['oper'])){
                $oper = $_REQUEST['oper'];
            }
            $page = $_REQUEST['page'];
            $limit = $_REQUEST['rows'];
            $sidx = $_REQUEST['sidx'];
            $sord = $_REQUEST['sord'];

            //standard response parameters 

            $quotedata = array();
            if ($oper=="receipt"){
               $where = array('receipt_id' => $receiptId ); 
            }
            else if ($oper=="orderline"){
               $where = array('order_line_id' => $orderLineId );  
            }
            $count = $this->Receipt_item->totalNoOfRows($where);
            if( $count > 0 && $limit > 0) { 
                $total_pages = ceil($count/$limit); 
            } else { 
                $total_pages = 0; 
            } 
            if ($page > $total_pages) $page=$total_pages;

            $start = $limit*$page - $limit;

             // if for some reasons start position is negative set it to 0 
             // typical case is that the user type 0 for the requested page 
            if($start <0) $start = 0; 
            $clauses = array('orderBy'=>$sidx,'orderDir'=>$sord,'startLimit'=>$start,'limit'=>$limit);

            $data['total'] = $total_pages;
            $data['page'] = $page;
            $data['records'] = $count; 

            $quotes = $this->Receipt_item->getAll(false,$where);

            foreach ($quotes as $dp){
                $receipt_data = $this->Receipt_master->getById($dp['receipt_id'],true);
                array_push($quotedata, array('id'=> $dp['id'],'dprow' => array($receipt_data['supplier_receipt_number'],$receipt_data['reference'],
                   $dp['receipt_id'], $dp['order_line_id'],$dp['product_id'],$dp['name'],$dp['ordered_quantity'],$dp['received_quantity'],$dp['received_value'],$dp['returned_quantity'],$dp['returned_value'],$dp['receiving_notes'],$dp['returned_notes'])));
            }
            $data['receiptitemdata'] = $quotedata;
            echo json_encode($data);
                    
           
        }
        
        function getOrderDetails(){
            $orderId=$_REQUEST['orderId'];
            if (!empty($orderId)){
                $order = $this->Purchase_order_master->getGridById($orderId);
                echo json_encode($order);
            }


        }
        function getQuoteDetails(){
            $quoteId=$_REQUEST['quoteId'];
            if (!empty($quoteId)){
                $quote = $this->Purchase_quote_master->getGridById($quoteId);
                echo json_encode($quote);
            }


        }
        function loadPOGrid()
	{
            
            $this->load->view("procurement/purchaseorder/purchase_order_grid",$data);
	}
        function loadOpenInvoicesGrid()
	{
            
            $this->load->view("procurement/invoice/purchase_invoice_grid",$data);
	}
        function loadFormFragment(){
            $this->load->view("procurement/purchaseorder/po_details",$data);

        }
        function loadNotesFragment(){
            $this->load->view("procurement/purchaseorder/po_notes",$data);

        }
        
        function loadWaitingForApprovalQuotesGrid (){
            $this->load->view("procurement/quote/approval/quote_approval_grid",$data);
        }
         function loadRejectedQuotesGrid (){
            $this->load->view("procurement/quote/rejected/quote_rejected_grid",$data);
        }
        
        function loadQuoteFormFragment(){
            $this->load->view("procurement/quote/approval/quote_details",$data);

        }
        function loadQuoteNotesFragment(){
            $this->load->view("procurement/quote/approval/quote_notes",$data);

        }
        
        
        function loadCreateQuotesGrid (){
            $productArray = $this->Product->getValues();
            foreach ($productArray as $product){
                //$data = array('label' => $model['model_name'], 'value' => $model['id']);
                //array_push($autoData,$data);
                $id = $product['id'];
                $name = $product['product_name'].'->'.$product['manufacturer'].' '.$product['model']
                        .' '.$product['measurement_denomination'].' '.$product['uom'];
                $productOptions.="<OPTION VALUE=\"$id\">".$name;
            }
            $data['productOptions'] = $productOptions;
            $this->load->view("procurement/quote/create/quote_create_grid",$data);
        }
        
        function loadReceivedGrid (){
            
            $this->load->view("procurement/purchaseorder/received/received_order_grid",$data);
        }
        
        function loadCreateQuoteFormFragment(){
            $deliveryPoints = $this->Delivery_point->getAll();
            foreach($deliveryPoints as $deliveryPoint) { 

                $id=$deliveryPoint["id"]; 
                $thing=$deliveryPoint["name"]; 
                $options.="<OPTION VALUE=\"$id\">".$thing; 
            } 
            $suppliers= $this->Supplier->getAll();
            foreach($suppliers as $supplier) { 

                $id=$supplier["id"]; 
                $thing=$supplier["supplier_name"]; 
                $supplieroptions.="<OPTION VALUE=\"$id\">".$thing; 
            } 
            $data['warehouseOptions']=$options;
            $data['supplierOptions']=$supplieroptions;
            $this->load->view("procurement/quote/create/quote_details",$data);

        }
        function loadCreateQuoteNotesFragment(){
            $this->load->view("procurement/quote/create/quote_notes",$data);

        }
        function submitForApproval(){
            $idArray = $_REQUEST['ids'];
            if (!empty($idArray)){
                 foreach($idArray as $tempId){
                    $this->db->trans_start();
                    $where_clause_quote = array('id'=>$tempId);
                    $this->Purchase_quote_master->update($where_clause_quote,array('status'=>  self::WAITING_FOR_APPROVAL));
                    log_message('debug',$this->db->last_query());
                    $where_clause_quote_item = array('quote_id'=>$tempId);
                    $this->Purchase_quote_item->update($where_clause_quote_item,array('status'=>self::WAITING_FOR_APPROVAL));
                    log_message('debug',$this->db->last_query());
                    $this->db->trans_complete();
                } 
                
            }
                
        }
        function assign(){
            $inv_id_array  = json_decode($_REQUEST['sel_quote']);
            foreach($inv_id_array as $id){
                $quote_details = $this->Purchase_quote_master->getById($id);
                $notes= $quote_details->notes;
                $notes .= '<br/>Assigned By:' .$this->username.' Assignment Notes:'.$_REQUEST['assignment_notes'];
                $where_clause_array= array('id'=>$id);
                $inv_data = array
                (
                    'owner_id'=>$_REQUEST['userId'],
                    'notes'=>$notes
                    
                );
                $this->Purchase_quote_master->update($where_clause_array,$inv_data);
            }
        }
        
        //receivings 
        function receiveItems(){
            $oper = $_REQUEST["oper"];
            $action = $_REQUEST["action"];
            $order_line_id = $_REQUEST["order_line_id"];
            $order_id = $_REQUEST["order_id"];
            $receiptOp = $_REQUEST["receipt"];
            $receiptIp = $_REQUEST["receipt_ip"];
            $received_quantity  = $_REQUEST["received_quantity"];
            $received_value = $_REQUEST["received_value"];
            $returned_quantity  = $_REQUEST["returned_quantity"];
            $returned_value = $_REQUEST["returned_value"];
            if ($oper == "return"){
                if (!empty($_REQUEST["returned_notes"])){
                    $receipt_item_data['returned_notes']=$_REQUEST["returned_notes"];
                }
            }
            else if ($oper == "receive"){
                if (!empty($_REQUEST["receiving_notes"])){
                    $receipt_item_data['receiving_notes']=$_REQUEST["receiving_notes"];
                }
            }

           
            
            //if (!empty($rcvd_note)){
                $fmatted_rcvd_note = "&#013;&#010; **** ".date("Y-m-d H:i:s", time()). " ****&#013;&#010;".$_REQUEST["receiving_notes"];
                $rcvd_note="CONCAT(`receiving_notes`, '$fmatted_rcvd_note')";
                $notes_array['receiving_notes'] = $rcvd_note;
            //}
            

            //if (!empty($rtrnd_note)){
                $fmatted_rtrnd_note = "&#013;&#010; **** ".date("Y-m-d H:i:s", time()). " ****&#013;&#010;".$_REQUEST["returned_notes"];
                $rtrnd_note = "CONCAT(`returned_notes`, '$fmatted_rtrnd_note')";
               // $receipt_item_data['returned_notes']="CONCAT(`returned_notes`, $fmatted_rtrnd_note);";
                $notes_array['returned_notes'] = $rtrnd_note;
            //}
           
            $product_id = $_REQUEST["product_id"];
            $supplierId=$_REQUEST["supplier_id"];
            $productdetails = $this->Product->getByProductId($product_id,true);
            $receipt_item_data['product_id'] = $product_id;
            $receipt_item_data['name'] = $productdetails['product_name'];
            $receipt_item_data['sku'] = $productdetails['barcode'];
            $receipt_item_data['order_line_id'] = $order_line_id;
            $receipt_item_data['received_quantity']=$received_quantity;
           
            // total received and value for order line items
            $total_received_for_order = $_REQUEST['total_received_quantity'];
            $total_received_value_for_order = $_REQUEST['total_received_value'];
            $total_returned_for_order = $_REQUEST['total_returned_quantity'];
            $total_returned_value_for_order = $_REQUEST['total_returned_value'];
            $ordered_quantity = $_REQUEST['quantity'];
            $order_line_item_matched = 0;
            
            
            $line_status= self::RECEIVING;
            if ($ordered_quantity == $total_received_for_order + $total_returned_for_order){
                $line_status= self::RECEIVED;
                $order_line_item_matched = 1;
            }
            
            
            
            $this…