EVOLUTION-NINJA

Edit File: Orders.php

<?php

namespace App\Controllers;
use App\Models\Gss_model;

class Orders extends BaseController
{

public function __construct()
{
        $this->db = \Config\Database::connect();
}

public function access_id()
{

$gss_model = new Gss_model();
            $id=session()->get('admin_id');
            $table='gss_login';
            $where=array('user_id'=>$id);
            $d=$gss_model->get_where_row($table,$where);
            return $d->user_type_id;
 }

public function access_details()
 {

$gss_model = new Gss_model();
            $id=session()->get('admin_id');
            $table='gss_login';
            $where=array('user_id'=>$id);
            $d=$gss_model->get_where_row($table,$where);
            $data['user_type_id']=$d->user_type_id;

$table='gss_access_controls';
            $where=array('department_id'=>$data['user_type_id']);
            return $gss_model->get_where_result($table,$where);
}

public function purchase_order_form()
    {
        $admin_id =session()->get('admin_id');
        if($admin_id)
        {
            $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
            return view('admin/purchase_order_form',$data);
        }
        else
        {
            redirect('/');
        } 
 }

public function purchase_order_generate_po()
    {
        $session = session();
        $admin_id = $session->get('admin_id');
        
        $gss_model = new Gss_model();

if (!$admin_id) {
            return redirect()->to('/');
        }

$ids = $this->request->getGet('id');

if (empty($ids)) {
            return $this->response->setStatusCode(400)->setBody('Invalid request: ID parameter is missing.');
        }

$array_ids = explode(",", $ids);

$data['product_list'] = $gss_model->get_where_reults_work_order_list($array_ids);
        $data['owners'] = $gss_model->get_where_result1111('gss_project_master');
        $data['wo_no'] = $gss_model->get_purchase_order();
        $data['user_type_id'] = $this->access_id();
        $data['access'] = $this->access_details();

return view('admin/purchase_order_generate_po', $data);
    }

public function vendor_search_by_fetch()
 {
  $gss_model = new Gss_model();
  $vendor_name=$this->request->getPost('id');
  $table='gss_vendor_details';
  $condition=['delete_status'=>'ACTIVE'];
  $result=$gss_model->get_whererow($table,$condition,$vendor_name);
  if($result)
  {
    return $this->response->setJSON(['result'=>1,'message'=>$result]);
   
  }
  else
  {
   return $this->response->setJSON(['result'=>0,'message'=>'No Details found']);
  }
   
}

public function insert_work_po_data()
    {
       
        $request = service('request');

$db = \Config\Database::connect();
        $data = [
            'bank_details'    => $request->getPost('bank_details'),
            'vendor_name'     => $request->getPost('vendor_name'),
            'g_date'          => $request->getPost('g_date'),
            'po_no'           => $request->getPost('po_no'),
            'currency'        => $request->getPost('currency'),
            'address'         => $request->getPost('address'),
            'contact_person'  => $request->getPost('contact_person'),
            'contact_number'  => $request->getPost('contact_number'),
            'email'           => $request->getPost('email'),
            'note'            => $request->getPost('note'),
            'total_amt'       => $request->getPost('total_amt'),
            'discount'        => $request->getPost('discount'),
            'g_total'         => $request->getPost('g_total'),
            'comment'         => $request->getPost('comment'),
            'gst_no'          => $request->getPost('gst_no'),
            'terms_payment'   => $request->getPost('terms_payment'),
            'ot_charges'      => $request->getPost('ot_charges'),
            'quantity_val'    => $request->getPost('quantity_val'),
            'unit1'           => $request->getPost('unit1'),
            'inr_value_val'   => $request->getPost('inr_value_val'),
            'ot_sgst'         => $request->getPost('ot_sgst'),
            'ot_cgst'         => $request->getPost('ot_cgst'),
            'ot_igst'         => $request->getPost('ot_igst'),
            'total_value_val' => $request->getPost('total_value_val')
        ];

// Get array data
        $product_id   = $request->getPost('product_id');
        $p_name       = $request->getPost('p_name');
        $description  = $request->getPost('description');
        $i_no         = $request->getPost('i_no');
        $cgst         = $request->getPost('cgst');
        $sgst         = $request->getPost('sgst');
        $project_name = $request->getPost('project_name');
        $purpose      = $request->getPost('purpose');
        $quantityy    = $request->getPost('quantityy');
        $igst         = $request->getPost('igst');
        $unit         = $request->getPost('unit');
        $inrvalue     = $request->getPost('inrvalue');
        $totalvalue   = $request->getPost('totalvalue');

// Generate timestamps
       $date = new \DateTime('now', new \DateTimeZone('Asia/Kolkata'));

$created_at = $date->format('Y-m-d H:i:s');

// Check if PO Number already exists
        $poExists = $db->table('gss_po_generate')
            ->where(['po_no' => $data['po_no'], 'delete_status' => 'ACTIVE'])
            ->countAllResults();

if ($poExists > 0) {
            return $this->response->setJSON(['result' => 0, 'message' => 'This PO number already exists']);
        }

// Insert each product data
        foreach ($product_id as $key => $ids) {
            $insertData = [
                'po_no'            => $data['po_no'],
                'vendor'           => $data['vendor_name'],
                'date'             => $data['g_date'],
                'currency'         => $data['currency'],
                'vendor_address'   => $data['address'],
                'contact_person'   => $data['contact_person'],
                'contact_number'   => $data['contact_number'],
                'email'            => $data['email'],
                'product_id'       => $ids,
                'product_name'     => $p_name[$key],
                'description'      => $description[$key],
                'indent'           => $i_no[$key],
                'project_name'     => $project_name[$key],
                'purpose_no'       => $purpose[$key],
                'quentity'         => $quantityy[$key],
                'unit_price'       => $unit[$key],
                'inr_value'        => $inrvalue[$key],
                'sgst'             => $sgst[$key],
                'cgst'             => $cgst[$key],
                'igst'             => $igst[$key],
                'total_value'      => $totalvalue[$key],
                'total_amt'        => $data['total_amt'],
                'discount'         => $data['discount'],
                'grand_total'      => $data['g_total'],
                'delete_status'    => 'ACTIVE',
                'material_delivery'=> $data['comment'],
                'bank_details'     => $data['bank_details'],
                'terms_of_payment' => $data['terms_payment'],
                'gst_no'           => $data['gst_no'],
                'ot_charges'       => $data['ot_charges'],
                'ot_unit'          => $data['unit1'],
                'ot_quantity'      => $data['quantity_val'],
                'ot_inr_value'     => $data['inr_value_val'],
                'ot_sgst'          => $data['ot_sgst'],
                'ot_cgst'          => $data['ot_cgst'],
                'ot_discount'      => $data['discount'],
                'ot_igst'          => $data['ot_igst'],
                'ot_total_value'   => $data['total_value_val'],
                'created_at'       => $created_at,
                'modified_at'      => $created_at,
                'note'             => $data['note'],
                'cancel_status'    => 'CANCEL'
            ];

$result = $db->table('gss_po_generate')->insert($insertData);
        }

if ($result) {
            return $this->response->setJSON(['result' => 1, 'message' => 'Added successfully']);
        } else {
            return $this->response->setJSON(['result' => 0, 'message' => 'Not Added']);
        }
    }

public function single_project_po()
	{
	    $gss_model = new Gss_model();
		$table       = 'gss_po_generate';
		$project  = $this->request->getPost('project');
		$where   	 = ['project_name' => $project ,'delete_status' => 'ACTIVE'];
		$order_by    = 'id';
		$result      = $gss_model->get_where_result_distinct($table,$where,$order_by);
		if($result)
		{
			 return $this->response->setJSON(['result'=>1,'po_no'=>$result]);
		}
		else
		{
			 return $this->response->setJSON(['result'=>0]);
		}
}

public function work_order_form()
	{
		$admin_id = session()->get('admin_id');
		if($admin_id)
		{
		    $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
		  //  	print_r($data);die();
		return view('admin/work_order_form',$data);
		
	
		}
		else
		{
			redirect('/');
		}	
	}

public function generate_po()
{
    $admin_id = session()->get('admin_id');
     $gss_model = new Gss_model();
    if (!$admin_id) {
        return redirect()->to('/');
    }

$ids = $this->request->getGet('id'); 
    if (!$ids) {
        return show_error('Invalid Request', 400);
    }

$array_ids = array_map('intval', explode(",", $ids));

$db = \Config\Database::connect(); 
    
     $land_table='gss_project_master';
  	 $data['product_list']=$gss_model->get_where_work_order($array_ids);
	 $data['owners']= $gss_model->get_where_result1111($land_table);
	 $data['wo_no']=$gss_model->get_work_order();

$data['user_type_id'] = $this->access_id();
    $data['access'] = $this->access_details();

return view('admin/po_generate', $data); 
}

public function insert_work_wo_data()
{
    $request = service('request');
    $db = \Config\Database::connect();
    $table = 'gss_wo_generate';

$po_no = $request->getPost('po_no');

// Check if PO number already exists
    $existing_po = $db->table($table)
                      ->where('po_no', $po_no)
                      ->where('delete_status', 'ACTIVE')
                      ->get()
                      ->getRow();

if ($existing_po) {
        return $this->response->setJSON(['result' => 0, 'message' => 'This WO number already exists']);
    }

$date = new \DateTime('now', new \DateTimeZone('Asia/Kolkata'));
    $created_at = $date->format('Y-m-d H:i:s');

// Get posted data
    $vendor_name   = $request->getPost('vendor_name');
    $g_date        = $request->getPost('g_date');
    $currency      = $request->getPost('currency');
    $address       = $request->getPost('address');
    $contact_person = $request->getPost('contact_person');
    $contact_number = $request->getPost('contact_number');
    $email         = $request->getPost('email');
    $product_id    = $request->getPost('product_id');
    $p_name        = $request->getPost('p_name');
    $description   = $request->getPost('description');
    $i_no          = $request->getPost('i_no');
    $cgst          = $request->getPost('cgst');
    $sgst          = $request->getPost('sgst');
    $igst          = $request->getPost('igst');
    $project_name  = $request->getPost('project_name');
    $purpose       = $request->getPost('purpose');
    $inrvalue      = $request->getPost('inrvalue');
    $totalvalue    = $request->getPost('totalvalue');
    $ot_charges    = $request->getPost('ot_charges');
    $quantity_val  = $request->getPost('quantity_val');
    $unit1         = $request->getPost('unit1');
    $inr_value_val = $request->getPost('inr_value_val');
    $ot_sgst       = $request->getPost('ot_sgst');
    $ot_cgst       = $request->getPost('ot_cgst');
    $ot_igst       = $request->getPost('ot_igst');
    $total_value_val = $request->getPost('total_value_val');
    $note          = $request->getPost('note');
    $total_amt     = $request->getPost('total_amt');
    $discount      = $request->getPost('discount');
    $g_total       = $request->getPost('g_total');
    $comment       = $request->getPost('comment');
    $gst_no        = $request->getPost('gst_no');
    $terms_payment = $request->getPost('terms_payment');
    $tds           = $request->getPost('tds');
    $bank_details  = $request->getPost('bank_details');

// Insert each product record
    foreach ($product_id as $key => $ids) {
        $data = [
            'po_no'           => $po_no,
            'vendor'          => $vendor_name,
            'date'            => $g_date,
            'currency'        => $currency,
            'vendor_address'  => $address,
            'product_id'      => $ids,
            'contact_person'  => $contact_person,
            'contact_number'  => $contact_number,
            'email'           => $email,
            'product_name'    => $p_name[$key],
            'description'     => $description[$key],
            'indent'          => $i_no[$key],
            'project_name'    => $project_name[$key],
            'purpose_no'      => $purpose[$key],
            'inr_value'       => $inrvalue[$key],
            'sgst'            => $sgst[$key],
            'cgst'            => $cgst[$key],
            'igst'            => $igst[$key],
            'total_value'     => $totalvalue[$key],
            'total_amt'       => $total_amt,
            'discount'        => $discount,
            'grand_total'     => $g_total,
            'delete_status'   => 'ACTIVE',
            'material_delivery' => $comment,
            'bank_details'    => $bank_details,
            'tds'             => $tds,
            'terms_of_payment'=> $terms_payment,
            'gst_no'          => $gst_no,
            'ot_charges'      => $ot_charges,
            // 'ot_unit'         => $unit1,
            // 'ot_quantity'     => $quantity_val,
            'ot_inr_value'    => $inr_value_val,
            'ot_sgst'         => $ot_sgst,
            'ot_cgst'         => $ot_cgst,
            'ot_igst'         => $ot_igst,
            'ot_total_value'  => $total_value_val,
            'ot_discount'     => $discount,
            'created_at'      => $created_at,
            'modified_at'     => $created_at,
            'note'            => $note,
            'cancel_status'   => 'CANCEL'
        ];

$db->table($table)->insert($data);
    }

return $this->response->setJSON(['result' => 1, 'message' => 'Added successfully']);
}

public function po_genereted_list_form()
    {
        $admin_id = session()->get('admin_id');
         $gss_model = new Gss_model();
        if($admin_id)
        {
            $land_table         = 'gss_project_master';
            $data['project']     = $gss_model->get_where_result1111($land_table);
            $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
            return view('admin/po_genereted_list',$data);
        }
        else
        {
            redirect('/');
        } 
    }

public function work_order_wo_generated_list()
{
     $gss_model = new Gss_model();
    $from_date = $this->request->getGet('from');
    if (!empty($from_date)) {
        $from_date = date('d-m-Y', strtotime($from_date));
    }

$to_date = $this->request->getGet('to');
    if (!empty($to_date)) {
        $to_date = date('d-m-Y', strtotime($to_date));
    }

$result = $gss_model->get_work_order_dates($from_date, $to_date);

return $this->response->setJSON($result ? $result : ['result' => 0]);
}

public function wo_subgrid()
{
    $id = $this->request->getGet('id');
   $gss_model = new Gss_model();
    if (!$id) {
        return $this->response->setJSON(['error' => 'Invalid request.']);
    }

$table = 'gss_wo_generate';

// Get single row based on ID
    $getAllData = $gss_model->get_where_row($table, ['id' => $id]);

if (!$getAllData) {
        return $this->response->setJSON(['error' => 'No data found.']);
    }

$po = $getAllData->po_no;

// Fetch subgrid data based on po_no
    $getAllSubgridData = $gss_model->fetch_where_subgrid_data1($table, ['po_no' => $po]);

return $this->response->setJSON($getAllSubgridData);
}

public function single_project_wo()
{
    
      $gss_model = new Gss_model();
    $table = 'gss_wo_generate';
    $project = $this->request->getPost('project');

if (!$project) {
        return $this->response->setJSON(['result' => 0, 'error' => 'Project name is required.']);
    }

$where = ['project_name' => $project, 'delete_status' => 'ACTIVE'];
    $orderBy = 'id';

$result = $gss_model->get_where_result_distinct($table, $where, $orderBy);

if ($result) {
        return $this->response->setJSON(['result' => 1, 'wo_no' => $result]);
    }

return $this->response->setJSON(['result' => 0]);
}

public function purchase_po_genereted_list_form()
    {
        $admin_id = session()->get('admin_id');
        $gss_model = new Gss_model();
        if($admin_id)
        {
            $land_table         = 'gss_project_master';
            $data['project']     = $gss_model->get_where_result1111($land_table);
            $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
            echo view('admin/purchase_po_genereted_list_form',$data);
        }
        else
        {
            redirect('/');
        } 
}

public function work_order_po_generated_list()
    {
        $from_date = $this->request->getPost('from');
        $to_date   = $this->request->getPost('to');
        $gss_model = new Gss_model();
        // Convert dates if provided
        if (!empty($from_date) && DateTime::createFromFormat('Y-m-d', $from_date)) {
            $from_date = (new DateTime($from_date))->format('Y-m-d');
        } else {
            $from_date = null;
        }

if (!empty($to_date) && DateTime::createFromFormat('Y-m-d', $to_date)) {
            $to_date = (new DateTime($to_date))->format('Y-m-d');
        } else {
            $to_date = null;
        }

// Fetch data from model
        $result = $gss_model->get_purchase_order_dates($from_date, $to_date);

// Return JSON response
        return $this->response->setJSON($result ?: ['result' => 0]);
}
	
	
 public function purchase_order_project_wise()
    {
        $gss_model = new Gss_model();
        $from_date = $this->request->getPost('from');
        if (!empty($from_date)) {
            $from_date = (new DateTime($from_date))->format('Y-m-d');
        }

$to_date = $this->request->getPost('to');
        if (!empty($to_date)) {
            $to_date = (new DateTime($to_date))->format('Y-m-d');
        }

$project = $this->request->getPost('project');
        $po_no   = $this->request->getPost('po_no');

$table = 'gss_po_generate';

if ($project == 'all' && empty($from_date) && empty($to_date)) {
            $condition = ['delete_status' => 'ACTIVE'];
            $result = $gss_model->get_where_distinct_po($table, $condition);
        } elseif (!empty($project) && $po_no == 'all' && !empty($from_date) && !empty($to_date)) {
            $result = $gss_model->get_civil_po_wo_order($table, $from_date, $to_date, $project, $po_no);
        } elseif ($po_no == 'all') {
            $where = ['project_name' => $project];
            $result = $gss_model->get_where_distinct_po_wo($table, $where, $from_date, $to_date, $project);
        } elseif ($project == 'all' && !empty($from_date) && !empty($to_date)) {
            $result = $gss_model->get_purchase_order_dates($from_date, $to_date);
        } elseif (!empty($project) && !empty($po_no) && !empty($from_date) && !empty($to_date)) {
            $result = $gss_model->get_po($from_date, $to_date, $project, $po_no);
        } else {
            $result = $gss_model->get_purchase_order_project($project, $po_no);
        }

return $this->response->setJSON($result ?: ['result' => 0]);
}

public function po_subgrid()
	{
		
        $gss_model = new Gss_model();
		$i=$this->request->getGet('id');
		 	//  print_r($i);die();
		 $table='gss_po_generate';
		 $where = ['id'=>$i];
		 $getalldatas = $gss_model->get_where_row($table,$where);
		 
		 $po=$getalldatas->po_no;
		 
	
		
		  $where1 = array('po_no'=>$po);
		  $getalldata = $gss_model->fetch_where_subgrid_data1($table,$where1);
		
          return $this->response->setJSON($getalldata);
}
    public function edit_purchase_order_po()
    {
        $admin_id = session()->get('admin_id');
        $gss_model = new Gss_model();
        if($admin_id)
        {
        
            $ids=$this->request->getGet('id');
            $where=['id'=>$ids];
            $table='gss_po_generate';
            $data['po_details']=$gss_model->get_where_row($table,$where);
            $where1 = ['po_no'=>$data['po_details']->po_no];
            $data['fetch_details'] = $gss_model->fetch_where_subgrid_data1($table,$where1);
            $data['key']=1;
            $land_table         = 'gss_project_master';
            $data['owners']     = $gss_model->get_where_result1111($land_table);
            $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
            return view('admin/edit_purchase_order_po',$data);
        }
        else
        {
            redirect('/');
        } 
    }	
    
public function update_work_po_data()
{
    $db = \Config\Database::connect();
    $request = service('request');

$id = $request->getPost('edit_id');
    $bank_details = $request->getPost('bank_details');
    $vendor_name = $request->getPost('vendor_name');
    $g_date = $request->getPost('g_date');
    $po_no = $request->getPost('po_no');
    $currency = $request->getPost('currency');
    $address = $request->getPost('address');
    $contact_person = $request->getPost('contact_person');
    $contact_number = $request->getPost('contact_number');
    $email = $request->getPost('email');
    $product_id = $request->getPost('product_id');
    $p_name = $request->getPost('p_name');
    $description = $request->getPost('description');
    $i_no = $request->getPost('i_no');
    $cgst = $request->getPost('cgst');
    $sgst = $request->getPost('sgst');
    $project_name = $request->getPost('project_name');
    $purpose = $request->getPost('purpose');
    $quantityy = $request->getPost('quantityy');
    $igst = $request->getPost('igst');
    $unit = $request->getPost('unit');
    $inrvalue = $request->getPost('inrvalue');
    $totalvalue = $request->getPost('totalvalue');
    $ot_charges = $request->getPost('ot_charges');
    $quantity_val = $request->getPost('quantity_val');
    $unit1 = $request->getPost('unit1');
    $inr_value_val = $request->getPost('inr_value_val');
    $ot_sgst = $request->getPost('ot_sgst');
    $ot_cgst = $request->getPost('ot_cgst');
    $ot_igst = $request->getPost('ot_igst');
    $total_value_val = $request->getPost('total_value_val');
    $note = $request->getPost('note');
    $total_amt = $request->getPost('total_amt');
    $discount = $request->getPost('discount');
    $g_total = $request->getPost('g_total');
    $comment = $request->getPost('comment');
    $gst_no = $request->getPost('gst_no');
    $terms_payment = $request->getPost('terms_payment');

$date = new \DateTime('now', new \DateTimeZone('Asia/Kolkata'));
    $created_at = $date->format('Y-m-d H:i:s');

$builder = $db->table('gss_po_generate');

foreach ($product_id as $key => $ids) {
        $data = [
            'po_no' => $po_no,
            'vendor' => $vendor_name,
            'date' => $g_date,
            'currency' => $currency,
            'vendor_address' => $address,
            'contact_person' => $contact_person,
            'contact_number' => $contact_number,
            'email' => $email,
            'product_id' => $ids,
            'product_name' => $p_name[$key],
            'description' => $description[$key],
            'indent' => $i_no[$key],
            'project_name' => $project_name[$key],
            'purpose_no' => $purpose[$key],
            'quentity' => $quantityy[$key],
            'unit_price' => $unit[$key],
            'inr_value' => $inrvalue[$key],
            'sgst' => $sgst[$key],
            'cgst' => $cgst[$key],
            'igst' => $igst[$key],
            'total_value' => $totalvalue[$key],
            'total_amt' => $total_amt,
            'discount' => $discount,
            'grand_total' => $g_total,
            'delete_status' => 'ACTIVE',
            'material_delivery' => $comment,
            'bank_details' => $bank_details,
            'terms_of_payment' => $terms_payment,
            'gst_no' => $gst_no,
            'ot_charges' => $ot_charges,
            'ot_unit' => $unit1,
            'ot_quantity' => $quantity_val,
            'ot_inr_value' => $inr_value_val,
            'ot_sgst' => $ot_sgst,
            'ot_cgst' => $ot_cgst,
            'ot_igst' => $ot_igst,
            'ot_total_value' => $total_value_val,
            'modified_at' => $created_at,
            'note' => $note
        ];

// Update the record
        $updateResult = $builder->where('id', $id[$key])->update($data);
    }

if ($updateResult) {
        return $this->response->setJSON(['result' => 1, 'message' => 'Updated successfully']);
    } else {
        return $this->response->setJSON(['result' => 0, 'message' => 'Not Updated']);
    }
}
    
 public function view_purchase_order_po()
    {
        $admin_id = session()->get('admin_id');
         $gss_model = new Gss_model();
        if($admin_id)
        {
            $ids=$this->request->getGet('id');
            $table='gss_po_generate';
            $where = ['delete_status'=>'ACTIVE','id'=>$ids];

$data['fetch_address']=$gss_model->get_where_row($table,$where);
 
            $where1 = array('po_no'=>$data['fetch_address']->po_no);
            $data['fetch_details'] = $gss_model->fetch_where_subgrid_data1($table,$where1);
            
            $data['key']=1;
            
            $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
		    
            return view('admin/view_purchase_order_po',$data);
        }
        else
        {
            redirect('/');
        } 
}

public function edit_work_order_po()
    {
        $admin_id = session()->get('admin_id');
          $gss_model = new Gss_model();
        if($admin_id)
        {
            $ids=$this->request->getGet('id');
            $where=['id'=>$ids];
            $table='gss_wo_generate';
            $data['po_details']=$gss_model->get_where_row($table,$where);
            $where1 = array('po_no'=>$data['po_details']->po_no);
            $data['fetch_details'] = $gss_model->fetch_where_subgrid_data1($table,$where1);
            
            $data['key']=1;
            $land_table         = 'gss_project_master';

$data['owners']     = $gss_model->get_where_result1111($land_table);
            $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
            return view('admin/edit_work_order_po',$data);	   
          
        }
        else
        {
            redirect('/');
        } 		
    }
 public function update_work_wo_data()
{
    $db = \Config\Database::connect();
    $request = service('request');

$product_id = $request->getPost('product_id');
    $p_name = $request->getPost('p_name');
    $description = $request->getPost('description');
    $i_no = $request->getPost('i_no');
    $cgst = $request->getPost('cgst');
    $sgst = $request->getPost('sgst');
    $project_name = $request->getPost('project_name');
    $purpose = $request->getPost('purpose');
    $igst = $request->getPost('igst');
    $inrvalue = $request->getPost('inrvalue');
    $totalvalue = $request->getPost('totalvalue');
    $ot_charges = $request->getPost('ot_charges');
    $quantity_val = $request->getPost('quantity_val');
    $unit1 = $request->getPost('unit1');
    $inr_value_val = $request->getPost('inr_value_val');
    $ot_sgst = $request->getPost('ot_sgst');
    $ot_cgst = $request->getPost('ot_cgst');
    $ot_igst = $request->getPost('ot_igst');
    $total_value_val = $request->getPost('total_value_val');
    $note = $request->getPost('note');
    $total_amt = $request->getPost('total_amt');
    $discount = $request->getPost('discount');
    $g_total = $request->getPost('g_total');
    $comment = $request->getPost('comment');
    $gst_no = $request->getPost('gst_no');
    $terms_payment = $request->getPost('terms_payment');
    $tds = $request->getPost('tds');

$date = new \DateTime('now', new \DateTimeZone('Asia/Kolkata'));
    $created_at = $date->format('Y-m-d H:i:s');

$table = 'gss_wo_generate';
    $builder = $db->table($table);

foreach ($product_id as $key => $ids) {
        $data = [
            'po_no' => $po_no,
            'vendor' => $vendor_name,
            'date' => $g_date,
            'currency' => $currency,
            'contact_person' => $contact_person,
            'contact_number' => $contact_number,
            'email' => $email,
            'vendor_address' => $address,
            'product_id' => $ids,
            'product_name' => $p_name[$key],
            'description' => $description[$key],
            'indent' => $i_no[$key],
            'project_name' => $project_name[$key],
            'purpose_no' => $purpose[$key],
            'inr_value' => $inrvalue[$key],
            'sgst' => $sgst[$key],
            'cgst' => $cgst[$key],
            'igst' => $igst[$key],
            'total_value' => $totalvalue[$key],
            'total_amt' => $total_amt,
            'discount' => $discount,
            'grand_total' => $g_total,
            'delete_status' => 'ACTIVE',
            'material_delivery' => $comment,
            'bank_details' => $bank_details,
            'tds' => $tds,
            'terms_of_payment' => $terms_payment,
            'gst_no' => $gst_no,
            'ot_charges' => $ot_charges,
            'ot_unit' => $unit1,
            'ot_quantity' => $quantity_val,
            'ot_inr_value' => $inr_value_val,
            'ot_sgst' => $ot_sgst,
            'ot_cgst' => $ot_cgst,
            'ot_igst' => $ot_igst,
            'ot_total_value' => $total_value_val,
            'modified_at' => $created_at,
            'note' => $note,
        ];

$builder->where('id', $id[$key])->update($data);
    }

if ($db->affectedRows() > 0) {
        return $this->response->setJSON(['result' => 1, 'message' => 'Updated successfully']);
    } else {
        return $this->response->setJSON(['result' => 0, 'message' => 'No changes made']);
    }
}
    public function view_work_order_wo()
    {
        $admin_id = session()->get('admin_id');
        $gss_model = new Gss_model();
        if($admin_id)
        {
            $ids=$this->request->getGet('id');
            $table='gss_wo_generate';
            $where = ['delete_status'=>'ACTIVE','id'=>$ids];
            
            
            $data['fetch_address']=$gss_model->get_where_row($table,$where);
            
            
            
            $where1 = array('po_no'=>$data['fetch_address']->po_no);
            $data['fetch_details'] = $gss_model->fetch_where_subgrid_data1($table,$where1);
            
            $data['key']=1;
            $data['user_type_id'] = $this->access_id();
		    $data['access'] = $this->access_details();
            return view('admin/view_work_order_po',$data);
         
        }
        else
        {
            redirect('/');
        } 
    }
    
    
public function work_order_project_wise()
{
    $gss_model = new Gss_model();

$from_date = $this->request->getGet('from');
    if (!empty($from_date)) {
        $from_date = (new \DateTime($from_date))->format('Y-m-d');
    }

$to_date = $this->request->getGet('to');
    if (!empty($to_date)) {
        $to_date = (new \DateTime($to_date))->format('Y-m-d');
    }

$project = $this->request->getGet('project');
    $po_no   = $this->request->getGet('po_no');

$table = 'gss_wo_generate';

if ($project == 'all' && empty($from_date) && empty($to_date)) {
        $condition = ['delete_status' => 'ACTIVE'];
        $result = $gss_model->where($condition)->distinct()->findAll();
    } 
    else if (!empty($project) && $po_no == "all" && !empty($from_date) && !empty($to_date)) {
        $result = $gss_model->get_civil_po_wo_order($table, $from_date, $to_date, $project, $po_no);
    } 
    else if ($po_no == "all") {
        $result = $gss_model->where('project_name', $project)->distinct()->findAll();
    } 
    else if ($project == 'all' && !empty($from_date) && !empty($to_date)) {
        $result = $gss_model->get_work_order_dates($from_date, $to_date);
    } 
    else if (!empty($project) && !empty($po_no) && !empty($from_date) && !empty($to_date)) {
        $result = $gss_model->get_wo($from_date, $to_date, $project, $po_no);
    } 
    else {
        $result = $gss_model->get_work_order_project($project, $po_no);
    }

return $this->response->setJSON($result ?: ['result' => 0]);
}

public function export_print_purchase_order()
	{
// 		$from_date  = $_GET['from'];

$gss_model = new Gss_model(); 
		$from_date  =$this->request->getPost('from');
		if($from_date != "")
		{
			$date       = new DateTime($from_date);
        	$from_date  = $date->format('Y-m-d');
		}
		
		$to_date    =$this->request->getPost('to');;
		if($to_date != "")
		{
			$date       = new DateTime($to_date);
        	$to_date    = $date->format('Y-m-d');
		}
		
		$project    = $this->request->getPost('project');;
		
		$po_no  = $this->request->getPost('po_no');;
		$table='gss_po_generate';
		//$condition=array('delete_status'=>'ACTIVE');
		  if($project == 'all' && $from_date == "" && $to_date == "")
		  {
			  $table='gss_po_generate';
			  $condition=['delete_status'=>'ACTIVE'];
			  $result   = $gss_model->get_where_distinct_po($table,$condition);

if($result)
			  {
			   echo json_encode($result);
			  }
			  else
			  {
			   echo json_encode(array('result'=>0));
			  }
		  }
		  else if($project != "" && $po_no =="all" && $from_date!= "" && $to_date!= "")
		  {
			  $result   = $gss_model->get_civil_po_wo_order($table,$from_date,$to_date,$project,$po_no);

if($result)
			  {
			   echo json_encode($result);
			  }
			  else
			  {
			   echo json_encode(array('result'=>0));
			  }
		  }
		  else if($po_no == 'all')
		  {
			  $where = array('project_name'=>$project);
			   $result   = $gss_model->get_where_distinct_po_wo($table,$where,$from_date,$to_date,$project);

if($result)
			  {
			   echo json_encode($result);
			  }
			  else
			  {
			   echo json_encode(array('result'=>0));
			  }
			  
		  }
			else if($project == 'all' && $from_date!= "" && $to_date!= "")
		  {
			  
			  $result   = $gss_model->get_purchase_order_dates($from_date,$to_date);

if($result)
			  {
			   echo json_encode($result);
			  }
			  else
			  {
			   echo json_encode(array('result'=>0));
			  }
		  }
		  else if($project != "" && $po_no !="" && $from_date!= "" && $to_date!= "")
		  {
			  $result   = $gss_model->get_po($from_date,$to_date,$project,$po_no);
			 
			  if($result)
			  {
			   echo json_encode($result);
			  }
			  else
			  {
			   echo json_encode(array('result'=>0));
			  }
		  }
		  else 
		  {
			 $condition=array('po_no'=>$po_no);
			
			 $result   = $gss_model->get_purchase_order_project($project,$po_no);
		
			  if($result)
			  {
			   echo json_encode($result);
			  }
			  else
			  {
			   echo json_encode(array('result'=>0));
			  }
		  }
	}

public function export_print_work_order()
	{
	    $gss_model = new Gss_model(); 
		$from_date  =$this->request->getPost('from');
		if($from_date != "")
		{
			$date       = new DateTime($from_date);
        	$from_date  = $date->format('Y-m-d');
		}
		
		$to_date    =$this->request->getPost('to');
		if($to_date != "")
		{
			$date       = new DateTime($to_date);
        	$to_date    = $date->format('Y-m-d');
		}
		
		$project    = $this->request->getPost('project');
		
      	$po_no  = $this->request->getPost('po_no');
	    $table='gss_wo_generate';

if($project == 'all' && $from_date == "" && $to_date == "")
		  {
			  $table='gss_wo_generate';
			  $condition=['delete_status'=>'ACTIVE'];
			  $result   = $gss_model->get_where_distinct_po($table,$condition);

if($result)
			  {
			   return $this->response->setJSON($result);
			  }
			  else
			  {
			   return $this->response->setJSON(['result'=>0]);
			  }
		  }
		  else if($project != "" && $po_no =="all" && $from_date!= "" && $to_date!= "")
		  {
			  $result   = $gss_model->get_civil_po_wo_order($table,$from_date,$to_date,$project,$po_no);

if($result)
			  {
			   return $this->response->setJSON($result);
			  }
			  else
			  {
			   return $this->response->setJSON(['result'=>0]);
			  }
		  }
		  	else if($po_no == "all")
			{
				$where = array('project_name'=>$project);
				$result   = $gss_model->get_where_distinct_po_wo($table,$where,$project,$po_no);

if($result)
				{
					return $this->response->setJSON($result);
				}
				else
				{
					 return $this->response->setJSON(['result'=>0]);
				}
			}
		  else if($project == 'all' && $from_date != "" && $to_date != "")
		  {
			  
			  $result   = $gss_model->get_work_order_dates($from_date,$to_date);

if($result)
			  {
			   return $this->response->setJSON($result);
			  }
			  else
			  {
			   return $this->response->setJSON(['result'=>0]);
			  }
		  }
		  else if($project != "" && $po_no !="" && $from_date!= "" && $to_date!= "")
		  {
			  $result   = $gss_model->get_wo($from_date,$to_date,$project,$po_no);
			 
			  if($result)
			  {
			   return $this->response->setJSON($result);
			  }
			  else
			  {
			   return $this->response->setJSON(['result'=>0]);
			  }
		  }
		else 
		{
			$result   = $gss_model->get_work_order_project($project,$po_no);
	
			if($result)
			{
				return $this->response->setJSON($result);
			}
			else
			{
				 return $this->response->setJSON(['result'=>0]);
			}
		}
	}

}?>