Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/arjun_erp/application/controllers

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: Productionreport.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
ini_set('max_execution_time',259200);
class Productionreport extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Productionreport_model'));
    $this->load->model(array('Quotation_model'));
    $this->load->model(array('Worklog_model'));
    $this->load->model(array('Customer_model'));
    $this->load->model(array('Invoice_model'));
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Report');
  }

public function pending_production_export()
  {
    $fdate = isset($_SESSION['prodreportfdate'])?$_SESSION['prodreportfdate']:'';
    $tdate = isset($_SESSION['prodreporttdate'])?$_SESSION['prodreporttdate']:'';
    $cat = isset($_SESSION['prodreportcat'])?$_SESSION['prodreportcat']:'';
    $prod = isset($_SESSION['prodreportprod'])?$_SESSION['prodreportprod']:'';
    $gsm = isset($_SESSION['prodreportgsm'])?$_SESSION['prodreportgsm']:'';
    $color = isset($_SESSION['prodreportcolor'])?$_SESSION['prodreportcolor']:'';
    $cid = isset($_SESSION['prodreportcid'])?$_SESSION['prodreportcid']:'';
    $uid = isset($_SESSION['prodreportuid'])?$_SESSION['prodreportuid']:'';
    $empid = isset($_SESSION['prodreportempid'])?$_SESSION['prodreportempid']:'';

if($cat=='' && $prod=='' && $gsm=='' && $color=='' && $cid=='' && $uid=='')
    {
      $pending_production_list = $this->Productionreport_model->get_basic_pending_production_list($fdate,$tdate);
    }
    else
    {
      if($cat!='')
        $catqry = ' AND p.category_id='.$cat;
      else
        $catqry = '';

if($prod!='')
        $prodqry = ' AND p.product_id='.$prod;
      else
        $prodqry = '';

if($gsm!='')
        $gsmqry = ' AND p.gsm='.$gsm;
      else
        $gsmqry = '';

if($color!='')
        $colorqry = " AND p.color='".$color."'";
      else
        $colorqry = '';

if($cid!='')
        $compqry = " AND o.location_id='".$cid."'";
      else
        $compqry = '';

if($uid!='')
        $unitqry = " AND o.prod_unit='".$uid."'";
      else
        $unitqry = '';

$resqry = $this->db->query("SELECT wo.work_order_date, pt.product_type,o.order_no,o.order_date,o.del_date,p.product_name,wop.uom,wop.order_qty,o.customer_id,c.customer_name FROM `work_order` wo,work_order_product wop,product p,`order` o,product_type pt,product_category pc,product_attribute pa, attribute a,customer c WHERE wo.work_order_id = wop.work_order_id AND wo.order_id = o.order_id AND wop.product_id = p.product_id AND p.type_id = pt.product_type_id AND p.category_id = pc.product_category_id AND pa.attribute_id = a.attribute_id AND o.customer_id = c.customer_id AND wo.status=0 AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' $catqry $prodqry $gsmqry $colorqry $compqry $unitqry GROUP BY wop.work_order_product_id ORDER BY wo.work_order_id");
      $pending_production_list = $resqry->result_array();
    }

$g_settings = general_setting_details();

if($cid!='')
    {
      $locationlist = $this->Invoice_model->get_location_by_id($cid);
      $locationName = $locationlist->location_name;
      $reptitle = 'Pending Production Report For '.$locationName.' From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }
    else
    {
      $locationName = '';
      $reptitle = 'Pending Production Report for All Company From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }

$objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
        'font' => array(
            'bold' => true,
            'color' => array('rgb' => '000000')
        ),
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
        )
    );

$objPHPExcel->getActiveSheet()->mergeCells('A1:H1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Product Type');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'SO No');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', 'SO Date');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Delivery Date');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'Customer Info');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', 'Product Name');
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G2', 'UOM');
    $objPHPExcel->getActiveSheet()->getStyle('G2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('H2', 'Quantity');
    $objPHPExcel->getActiveSheet()->getStyle('H2')->applyFromArray($styleArray);

$i=3; $totqty=0;
    foreach ($pending_production_list as $pplist ) { 
      $cusDetails = $this->Customer_model->get_customer_contact_details($pplist['customer_id']);
      $pno = $cusDetails->phone_no;

$cname = $pplist['customer_name'].' - '.$pno;

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $pplist['product_type']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $pplist['order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, date_format(date_create($pplist['order_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, date_format(date_create($pplist['del_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $cname);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $pplist['product_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $pplist['uom']);
      $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, round($pplist['order_qty'],2));

$i++;
      $totqty+=$pplist['order_qty'];
    }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, 'Total');
    $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, round($totqty,2));

$filename='Pending_Production.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
    //if you want to save it as .XLSX Excel 2007 format
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
    $objPHPExcel->setActiveSheetIndex(0);

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output');

}

public function production_register_export()
  {
    $fdate = isset($_SESSION['prodreportfdate'])?$_SESSION['prodreportfdate']:'';
    $tdate = isset($_SESSION['prodreporttdate'])?$_SESSION['prodreporttdate']:'';
    $cat = isset($_SESSION['prodreportcat'])?$_SESSION['prodreportcat']:'';
    $prod = isset($_SESSION['prodreportprod'])?$_SESSION['prodreportprod']:'';
    $gsm = isset($_SESSION['prodreportgsm'])?$_SESSION['prodreportgsm']:'';
    $color = isset($_SESSION['prodreportcolor'])?$_SESSION['prodreportcolor']:'';
    $cid = isset($_SESSION['prodreportcid'])?$_SESSION['prodreportcid']:'';
    $uid = isset($_SESSION['prodreportuid'])?$_SESSION['prodreportuid']:'';
    $empid = isset($_SESSION['prodreportempid'])?$_SESSION['prodreportempid']:'';

if($cat=='' && $prod=='' && $gsm=='' && $color=='' && $cid=='' && $uid=='' && $empid=='')
    {
      $production_register_list = $this->Productionreport_model->get_basic_production_register_list($fdate,$tdate);
    }
    else
    {
      if($cat!='')
        $catqry = ' AND p.category_id='.$cat;
      else
        $catqry = '';

if($prod!='')
        $prodqry = ' AND p.product_id='.$prod;
      else
        $prodqry = '';

if($gsm!='')
        $gsmqry = ' AND p.gsm='.$gsm;
      else
        $gsmqry = '';

if($color!='')
        $colorqry = " AND p.color='".$color."'";
      else
        $colorqry = '';

if($cid!='')
        $compqry = " AND o.location_id='".$cid."'";
      else
        $compqry = '';

if($uid!='')
        $unitqry = " AND o.prod_unit='".$uid."'";
      else
        $unitqry = '';

if($empid!='')
        $empqry = " AND wlp.user_id='".$empid."'";
      else
        $empqry = '';

$resqry = $this->db->query("SELECT o.order_date,c.customer_name,p.product_name,dcp.quantity,wlp.weight FROM `delivery_challan` dc,`order` o,customer c,work_order wo,product p,delivery_challan_product dcp,work_log wl,work_log_product wlp,product_category pc WHERE dc.order_id = o.order_id AND o.order_id = wo.order_id AND wo.work_order_id = wl.work_order_id AND dc.delivery_challan_id = dcp.delivery_challan_id AND wl.work_log_id = wlp.work_log_id AND dcp.product_id = wlp.product_id AND o.customer_id = c.customer_id AND p.product_id = dcp.product_id AND p.category_id = pc.product_category_id AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $catqry $prodqry $gsmqry $colorqry $compqry $unitqry $empqry GROUP BY dcp.delivery_challan_product_id");
      $production_register_list = $resqry->result_array();
    }

$g_settings = general_setting_details();

if($cid!='')
    {
      $locationlist = $this->Invoice_model->get_location_by_id($cid);
      $locationName = $locationlist->location_name;
      $reptitle = 'Production Register Report For '.$locationName.' From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }
    else
    {
      $locationName = '';
      $reptitle = 'Production Register Report for All Company From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }

$objPHPExcel->getActiveSheet()->mergeCells('A1:E1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'SO Date');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'Customer Name');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', 'Product Name');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Quantity');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'Weight');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);

$i=3; $totqty=0;$totwgt=0;
    foreach ($production_register_list as $prlist ) {

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($prlist['order_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $prlist['customer_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $prlist['product_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, round($prlist['quantity'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, round($prlist['weight'],2));

$i++;
      $totqty+=$prlist['quantity'];
      $totwgt+=$prlist['weight'];
    }

$filename='Production_Register.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output');

}

public function factory_report_export()
  {
    $fdate = isset($_SESSION['prodreportfdate'])?$_SESSION['prodreportfdate']:'';
    $tdate = isset($_SESSION['prodreporttdate'])?$_SESSION['prodreporttdate']:'';
    $cat = isset($_SESSION['prodreportcat'])?$_SESSION['prodreportcat']:'';
    $prod = isset($_SESSION['prodreportprod'])?$_SESSION['prodreportprod']:'';
    $gsm = isset($_SESSION['prodreportgsm'])?$_SESSION['prodreportgsm']:'';
    $color = isset($_SESSION['prodreportcolor'])?$_SESSION['prodreportcolor']:'';
    $cid = isset($_SESSION['prodreportcid'])?$_SESSION['prodreportcid']:'';
    $uid = isset($_SESSION['prodreportuid'])?$_SESSION['prodreportuid']:'';
    $empid = isset($_SESSION['prodreportempid'])?$_SESSION['prodreportempid']:'';

if($cat=='' && $prod=='' && $gsm=='' && $color=='' && $cid=='' && $uid=='')
    {
      $factory_report_list = $this->Productionreport_model->get_basic_factory_report_list($fdate,$tdate);
    }
    else
    {
      if($cat!='')
        $catqry = ' AND p.category_id='.$cat;
      else
        $catqry = '';

if($prod!='')
        $prodqry = ' AND p.product_id='.$prod;
      else
        $prodqry = '';

if($gsm!='')
        $gsmqry = ' AND rg.rawmaterial_gsm='.$gsm;
      else
        $gsmqry = '';

if($color!='')
        $colorqry = " AND rc.rawmaterial_color='".$color."'";
      else
        $colorqry = '';

if($cid!='')
        $compqry = " AND o.location_id='".$cid."'";
      else
        $compqry = '';

if($uid!='')
        $unitqry = " AND o.prod_unit='".$uid."'";
      else
        $unitqry = '';

$resqry = $this->db->query("SELECT i.invoice_id,i.invoice_no,o.order_id,o.order_no,o.eyelets,op.product_id,op.cut_size_length,op.cut_size_width,wo.work_order_no,wlp.rawmaterial_id,wlp.weight,rg.rawmaterial_gsm,rc.rawmaterial_color,pc.product_category,op.quantity,p.cut_size_length as pcutsizelength, p.cut_size_width as pcutsizewidth FROM `invoice` i,`order` o,order_product op,work_order wo, work_log wl,work_log_product wlp,rawmaterial r,rawmaterial_gsm rg,rawmaterial_color rc,product p,product_category pc WHERE i.order_id = o.order_id AND wo.order_id = o.order_id AND op.order_id = o.order_id AND wo.work_order_id = wl.work_order_id AND wl.work_log_id = wlp.work_log_id AND wlp.product_id = op.product_id AND r.rawmaterial_id = wlp.rawmaterial_id AND r.rawmaterial_gsm_id = rg.rawmaterial_gsm_id AND r.rawmaterial_color_id = rc.rawmaterial_color_id AND p.product_id = op.product_id AND p.category_id = pc.product_category_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $catqry $prodqry $gsmqry $colorqry $compqry $unitqry");
      $factory_report_list = $resqry->result_array();
    }

$g_settings = general_setting_details();

if($cid!='')
    {
      $locationlist = $this->Invoice_model->get_location_by_id($cid);
      $locationName = $locationlist->location_name;
      $reptitle = 'Factory Report For '.$locationName.' From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }
    else
    {
      $locationName = '';
      $reptitle = 'Factory Report for All Company From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }

$objPHPExcel->getActiveSheet()->mergeCells('A1:M1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'S.NO');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'GSM');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', 'COLOR');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Size');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'QTY');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', 'SO NO');
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G2', 'WO NO');
    $objPHPExcel->getActiveSheet()->getStyle('G2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('H2', 'INV NO');
    $objPHPExcel->getActiveSheet()->getStyle('H2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('I2', 'WEIGHT OF THE MATERIAL');
    $objPHPExcel->getActiveSheet()->getStyle('I2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('J2', 'EYELETS');
    $objPHPExcel->getActiveSheet()->getStyle('J2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('K2', 'GSM - ACTUAL');
    $objPHPExcel->getActiveSheet()->getStyle('K2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('L2', 'OPERATOR SIGN');
    $objPHPExcel->getActiveSheet()->getStyle('L2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('M2', 'INCHARGE SIGN');
    $objPHPExcel->getActiveSheet()->getStyle('M2')->applyFromArray($styleArray);

$i=3; $totqty=0;$totwgt=0;
    $j=1;foreach ($factory_report_list as $pplist ) { 
      if($pplist['cut_size_length']==0 || $pplist['cut_size_width']==0)
      {
          if($pplist['pcutsizelength']!=0 && $pplist['pcutsizewidth']!=0)
          {
              $wgt = $pplist['pcutsizelength']*$pplist['pcutsizewidth'];
              $agsm = number_format(((($pplist['weight']*10.76)/$wgt)*1000),2);
          }
          else
          {
              $agsm = 0;
          }
      }
      else
      {
          $wgt = $pplist['cut_size_length']*$pplist['cut_size_width'];
          $agsm = number_format(((($pplist['weight']*10.76)/$wgt)*1000),2);
      }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $j);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $pplist['rawmaterial_gsm']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $pplist['rawmaterial_color']);
      if($pplist['cut_size_length']==0 || $pplist['cut_size_width']==0)
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $pplist['pcutsizelength'].'x'.$pplist['pcutsizewidth']);
      else
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $pplist['cut_size_length'].'x'.$pplist['cut_size_width']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $pplist['quantity']);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $pplist['order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $pplist['work_order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $pplist['invoice_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $pplist['weight']);
      $objPHPExcel->getActiveSheet()->setCellValue('J'.$i, $pplist['eyelets']);
      $objPHPExcel->getActiveSheet()->setCellValue('K'.$i, $agsm/$pplist['quantity']);
      $objPHPExcel->getActiveSheet()->setCellValue('L'.$i, '');
      $objPHPExcel->getActiveSheet()->setCellValue('M'.$i, '');

$i++;$j++;
    }

$filename='Factory_Report.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output');

}

public function getProduct()
  {
    $cat_id = $_POST['cat_id'];
    $product = $this->Quotation_model->get_product_by_category_id($cat_id);
    if(count($product)>0)
    {
      $st = '<option value="">Select Product</option>';
      foreach ($product as $prod) {
          $st.='<option value='.$prod["product_id"].'>'.$prod["product_name"].'</option>';
      }
    }
    else
    {
      $st = '<option value="">No Products Available</option>';
    }
    echo $st;
  }

public function index()
  {

//SELECT wo.work_order_date, pt.product_type,o.order_no,o.order_date,o.del_date,p.product_name,wop.uom,wop.order_qty FROM `work_order` wo,work_order_product wop,product p,`order` o,product_type pt,product_category pc,product_attribute pa, attribute a WHERE wo.work_order_id = wop.work_order_id AND wo.order_id = o.order_id AND wop.product_id = p.product_id AND p.type_id = pt.product_type_id AND p.category_id = pc.product_category_id AND pa.attribute_id = a.attribute_id AND wo.status=0 AND wo.work_order_date>='2019-02-01' AND wo.work_order_date<='2019-02-21' GROUP BY wop.work_order_product_id ORDER BY wo.work_order_id

$data['product_category_list'] = $this->Productionreport_model->get_product_category();
    $data['gsm_list'] = $this->Productionreport_model->get_active_rawmaterial_gsm();
    $data['color_list'] = $this->Productionreport_model->get_active_rawmaterial_color();
    $data['employee_list'] = $this->Worklog_model->employee_active_list();
    //$data['product_list'] = $this->Productionreport_model->get_product_list();
    //$data['location_list'] = $this->Productionreport_model->get_active_location();
    if($_SESSION['company_id']==0)
      $data['location_list'] = $this->Quotation_model->get_location();
    else
      $data['location_list'] = $this->Quotation_model->get_location_by_comp_id($_SESSION['company_id']);

$this->load->view('productionreport/production_report',$data);
  }

public function production_report()
  {
    $fdate = $_POST['fdate'];
    $fd = explode('/', $fdate);
    $fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];

$tdate = $_POST['tdate'];
    $td = explode('/', $tdate);
    $tdate = $td[2].'-'.$td[0].'-'.$td[1];

$rtype = $_POST['rtype'];
    $cat = $_POST['cat'];
    $prod = $_POST['prod'];
    $gsm = $_POST['gsm'];
    $color = $_POST['color'];
    $cid = $_POST['cid'];
    $uid = $_POST['uid'];
    $empid = $_POST['empid'];

$this->session->set_userdata('prodreportfdate', $_POST['fdate']!=''?$fdate:'');
    $this->session->set_userdata('prodreporttdate', $_POST['tdate']!=''?$tdate:'');
    $this->session->set_userdata('prodreportcat', $_POST['cat']!=''?$_POST['cat']:'');
    $this->session->set_userdata('prodreportprod', $_POST['prod']!=''?$_POST['prod']:'');
    $this->session->set_userdata('prodreportgsm', $_POST['gsm']!=''?$_POST['gsm']:'');
    $this->session->set_userdata('prodreportcolor', $_POST['color']!=''?$_POST['color']:'');
    $this->session->set_userdata('prodreportcid', $_POST['cid']!=''?$_POST['cid']:'');
    $this->session->set_userdata('prodreportuid', $_POST['uid']!=''?$_POST['uid']:'');
    $this->session->set_userdata('prodreportempid', $_POST['empid']!=''?$_POST['empid']:'');

if($rtype == 'pending for production')
    {
      if($cat=='' && $prod=='' && $gsm=='' && $color=='' && $cid=='' && $uid=='')
      {
        $data['pending_production_list'] = $this->Productionreport_model->get_basic_pending_production_list($fdate,$tdate);
      }
      else
      {
        if($cat!='')
          $catqry = ' AND p.category_id='.$cat;
        else
          $catqry = '';

if($prod!='')
          $prodqry = ' AND p.product_id='.$prod;
        else
          $prodqry = '';

if($gsm!='')
          $gsmqry = ' AND p.gsm='.$gsm;
        else
          $gsmqry = '';

if($color!='')
          $colorqry = " AND p.color='".$color."'";
        else
          $colorqry = '';

if($cid!='')
          $compqry = " AND o.location_id='".$cid."'";
        else
          $compqry = '';

if($uid!='')
          $unitqry = " AND o.prod_unit='".$uid."'";
        else
          $unitqry = '';

//$resqry = $this->db->query("SELECT wo.work_order_date, pt.product_type,o.order_no,o.order_date,o.del_date,p.product_name,wop.uom,wop.order_qty FROM `work_order` wo,work_order_product wop,product p,`order` o,product_type pt,product_category pc,product_attribute pa, attribute a WHERE wo.work_order_id = wop.work_order_id AND wo.order_id = o.order_id AND wop.product_id = p.product_id AND p.type_id = pt.product_type_id AND p.category_id = pc.product_category_id AND pa.attribute_id = a.attribute_id AND p.product_id = pa.product_id AND wo.status=0 AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' $catqry $prodqry $gsmqry $colorqry GROUP BY wop.work_order_product_id ORDER BY wo.work_order_id");
        $resqry = $this->db->query("SELECT wo.work_order_date, pt.product_type,o.order_no,o.order_date,o.del_date,p.product_name,wop.uom,wop.order_qty,o.customer_id,c.customer_name FROM `work_order` wo,work_order_product wop,product p,`order` o,product_type pt,product_category pc,product_attribute pa, attribute a,customer c WHERE wo.work_order_id = wop.work_order_id AND wo.order_id = o.order_id AND wop.product_id = p.product_id AND p.type_id = pt.product_type_id AND p.category_id = pc.product_category_id AND pa.attribute_id = a.attribute_id AND o.customer_id = c.customer_id AND wo.status=0 AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' $catqry $prodqry $gsmqry $colorqry $compqry $unitqry GROUP BY wop.work_order_product_id ORDER BY wo.work_order_id");
        $data['pending_production_list'] = $resqry->result_array();
      }
      $this->load->view('productionreport/pending_production_table',$data);
    }

if($rtype == 'production register')
    {
      //SELECT o.order_date,c.customer_name,p.product_name,dcp.quantity,wlp.weight FROM `delivery_challan` dc,`order` o,customer c,work_order wo,product p,delivery_challan_product dcp,work_log wl,work_log_product wlp WHERE dc.order_id = o.order_id AND o.order_id = wo.order_id AND wo.work_order_id = wl.work_order_id AND dc.delivery_challan_id = dcp.delivery_challan_id AND wl.work_log_id = wlp.work_log_id AND dcp.product_id = wlp.product_id AND o.customer_id = c.customer_id AND p.product_id = dcp.product_id AND dc.delivery_challan_date>='2019-01-01' AND dc.delivery_challan_date<='2019-01-03' GROUP BY dcp.delivery_challan_product_id

//SELECT o.order_date,c.customer_name,p.product_name,dcp.quantity,wlp.weight FROM `delivery_challan` dc,`order` o,customer c,work_order wo,product p,delivery_challan_product dcp,work_log wl,work_log_product wlp,product_category pc,product_attribute pa, attribute a WHERE dc.order_id = o.order_id AND o.order_id = wo.order_id AND wo.work_order_id = wl.work_order_id AND dc.delivery_challan_id = dcp.delivery_challan_id AND wl.work_log_id = wlp.work_log_id AND dcp.product_id = wlp.product_id AND o.customer_id = c.customer_id AND p.product_id = dcp.product_id AND p.category_id = pc.product_category_id AND pa.attribute_id = a.attribute_id AND p.product_id = pa.product_id AND dc.delivery_challan_date>='2019-01-01' AND dc.delivery_challan_date<='2019-01-03' GROUP BY dcp.delivery_challan_product_id
      if($cat=='' && $prod=='' && $gsm=='' && $color=='' && $cid=='' && $uid=='' && $empid=='')
      {
        $data['production_register_list'] = $this->Productionreport_model->get_basic_production_register_list($fdate,$tdate);
      }
      else
      {
        if($cat!='')
          $catqry = ' AND p.category_id='.$cat;
        else
          $catqry = '';

if($prod!='')
          $prodqry = ' AND p.product_id='.$prod;
        else
          $prodqry = '';

if($gsm!='')
          $gsmqry = ' AND p.gsm='.$gsm;
        else
          $gsmqry = '';

if($color!='')
          $colorqry = " AND p.color='".$color."'";
        else
          $colorqry = '';

if($cid!='')
          $compqry = " AND o.location_id='".$cid."'";
        else
          $compqry = '';

if($uid!='')
          $unitqry = " AND o.prod_unit='".$uid."'";
        else
          $unitqry = '';

if($empid!='')
          $empqry = " AND wlp.user_id='".$empid."'";
        else
          $empqry = '';

//$resqry = $this->db->query("SELECT o.order_date,c.customer_name,p.product_name,dcp.quantity,wlp.weight FROM `delivery_challan` dc,`order` o,customer c,work_order wo,product p,delivery_challan_product dcp,work_log wl,work_log_product wlp,product_category pc,product_attribute pa, attribute a WHERE dc.order_id = o.order_id AND o.order_id = wo.order_id AND wo.work_order_id = wl.work_order_id AND dc.delivery_challan_id = dcp.delivery_challan_id AND wl.work_log_id = wlp.work_log_id AND dcp.product_id = wlp.product_id AND o.customer_id = c.customer_id AND p.product_id = dcp.product_id AND p.category_id = pc.product_category_id AND pa.attribute_id = a.attribute_id AND p.product_id = pa.product_id AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $catqry $prodqry $gsmqry $colorqry GROUP BY dcp.delivery_challan_product_id");
        $resqry = $this->db->query("SELECT o.order_date,c.customer_name,p.product_name,dcp.quantity,wlp.weight FROM `delivery_challan` dc,`order` o,customer c,work_order wo,product p,delivery_challan_product dcp,work_log wl,work_log_product wlp,product_category pc WHERE dc.order_id = o.order_id AND o.order_id = wo.order_id AND wo.work_order_id = wl.work_order_id AND dc.delivery_challan_id = dcp.delivery_challan_id AND wl.work_log_id = wlp.work_log_id AND dcp.product_id = wlp.product_id AND o.customer_id = c.customer_id AND p.product_id = dcp.product_id AND p.category_id = pc.product_category_id AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $catqry $prodqry $gsmqry $colorqry $compqry $unitqry $empqry GROUP BY dcp.delivery_challan_product_id");
        $data['production_register_list'] = $resqry->result_array();
      }
      $this->load->view('productionreport/production_register_table',$data);
    }

if($rtype == 'factory report')
    {
      //SELECT i.invoice_id,i.invoice_no,o.order_id,o.order_no,o.eyelets,op.product_id,op.cut_size_length,op.cut_size_width,wo.work_order_no,ir.issue_id,ir.issue_no,irp.rawmaterial_id,irp.issue_qty,rg.rawmaterial_gsm,rc.rawmaterial_color,pc.product_category,op.quantity FROM `invoice` i,`order` o,order_product op,work_order wo, issue_register ir,issue_register_product irp,rawmaterial r,rawmaterial_gsm rg,rawmaterial_color rc,product p,product_category pc WHERE i.order_id = o.order_id AND wo.order_id = o.order_id AND op.order_id = o.order_id AND wo.work_order_id = ir.work_order_id AND ir.issue_id = irp.issue_id AND irp.product_id = op.product_id AND r.rawmaterial_id = irp.rawmaterial_id AND r.rawmaterial_gsm_id = rg.rawmaterial_gsm_id AND r.rawmaterial_color_id = rc.rawmaterial_color_id AND p.product_id = op.product_id AND p.category_id = pc.product_category_id AND i.invoice_date>='2018-12-25' AND i.invoice_date<='2019-01-30'
      if($cat=='' && $prod=='' && $gsm=='' && $color=='' && $cid=='' && $uid=='')
      {
        $data['factory_report_list'] = $this->Productionreport_model->get_basic_factory_report_list($fdate,$tdate);
      }
      else
      {
        if($cat!='')
          $catqry = ' AND p.category_id='.$cat;
        else
          $catqry = '';

if($prod!='')
          $prodqry = ' AND p.product_id='.$prod;
        else
          $prodqry = '';

if($gsm!='')
          $gsmqry = ' AND rg.rawmaterial_gsm='.$gsm;
        else
          $gsmqry = '';

if($color!='')
          $colorqry = " AND rc.rawmaterial_color='".$color."'";
        else
          $colorqry = '';

if($cid!='')
          $compqry = " AND o.location_id='".$cid."'";
        else
          $compqry = '';

if($uid!='')
          $unitqry = " AND o.prod_unit='".$uid."'";
        else
          $unitqry = '';

//$resqry = $this->db->query("SELECT i.invoice_id,i.invoice_no,o.order_id,o.order_no,o.eyelets,op.product_id,op.cut_size_length,op.cut_size_width,wo.work_order_no,ir.issue_id,ir.issue_no,irp.rawmaterial_id,irp.issue_qty,rg.rawmaterial_gsm,rc.rawmaterial_color,pc.product_category,op.quantity,p.cut_size_length as pcutsizelength, p.cut_size_width as pcutsizewidth FROM `invoice` i,`order` o,order_product op,work_order wo, issue_register ir,issue_register_product irp,rawmaterial r,rawmaterial_gsm rg,rawmaterial_color rc,product p,product_category pc WHERE i.order_id = o.order_id AND wo.order_id = o.order_id AND op.order_id = o.order_id AND wo.work_order_id = ir.work_order_id AND ir.issue_id = irp.issue_id AND irp.product_id = op.product_id AND r.rawmaterial_id = irp.rawmaterial_id AND r.rawmaterial_gsm_id = rg.rawmaterial_gsm_id AND r.rawmaterial_color_id = rc.rawmaterial_color_id AND p.product_id = op.product_id AND p.category_id = pc.product_category_id AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $catqry $prodqry $gsmqry $colorqry $compqry $unitqry");
        //$resqry = $this->db->query("SELECT o.order_date,c.customer_name,p.product_name,dcp.quantity,wlp.weight FROM `delivery_challan` dc,`order` o,customer c,work_order wo,product p,delivery_challan_product dcp,work_log wl,work_log_product wlp,product_category pc WHERE dc.order_id = o.order_id AND o.order_id = wo.order_id AND wo.work_order_id = wl.work_order_id AND dc.delivery_challan_id = dcp.delivery_challan_id AND wl.work_log_id = wlp.work_log_id AND dcp.product_id = wlp.product_id AND o.customer_id = c.customer_id AND p.product_id = dcp.product_id AND p.category_id = pc.product_category_id AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $catqry $prodqry $gsmqry $colorqry GROUP BY dcp.delivery_challan_product_id");
        $data['factory_report_list'] = $resqry->result_array();
      }
      $this->load->view('productionreport/factory_report_table',$data);
    }

}

public function irptowlp()
  {
    $resqry = $this->db->query("SELECT ir.issue_id, ir.work_order_id, irp.product_id, irp.rawmaterial_id, irp.rawmaterial_stock_id FROM issue_register ir,issue_register_product irp WHERE ir.issue_id = irp.issue_id")->result_array();
    foreach($resqry as $res)
    {
      $rqry = $this->db->query("UPDATE work_log_product JOIN work_log ON work_log_product.work_log_id = work_log.work_log_id SET work_log_product.rawmaterial_id = '".$res['rawmaterial_id']."',work_log_product.rawmaterial_stock_id = '".$res['rawmaterial_stock_id']."' WHERE work_log_product.product_id = '".$res['product_id']."' AND work_log.work_order_id = '".$res['work_order_id']."'");
    }
    redirect('/productionreport');
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Productionreport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation