Untitled
unknown
php
5 years ago
11 kB
9
Indexable
$post = $this->input->post(); $session = $this->session->userdata('hs_logged_in'); $action = $post['action']; $detail = $post['detail']; $psNumber = $post['psNumber']; $document = substr($action, -2); var_dump($post); die; if(is_array($detail)) { foreach($detail as $docCode => $arrayDet) { if($docCode == $document) { foreach($arrayDet as $matCode => $val) { $detailQty[$matCode] = $val; } } } } $getPSHeaderQuery = "SELECT fleet_doch.doc_code, fleet_doch.doc_date, fleet_doch.date_exec, fleet_doch.ref_date, fleet_doch.sro_code, fleet_doch.receive_by, fleet_doch.userid, fleet_doch.doc_remark, fleet_doch.lastupdate, fleet_doch.region_code, fleet_doch.status_doc, fleet_doch.type_doc, fleet_doch.type_ref, fleet_doch.unit_code, fleet_doch.model_no, fleet_doch.no_wo, fleet_doch.time_reading, fleet_doch.type_source, fleet_doch.dept_code, fleet_doch.job_status, fleet_doch.OrderType, fleet_doch.tFullSupply, fleet_doch.Owner, fleet_doch.OwnStamp, fleet_doch.Printed, fleet_doch.Edited, fleet_doch.Otorisasi, fleet_doch.OtoUsr, fleet_doch.OtoStamp, fleet_doch.Lvl, fleet_doch.order_by, fleet_doch.approval_by, fleet_doch.WoOrderType, fleet_doch.WoJobStatus, fleet_doch.tAccept, fleet_doch.user_accept, fleet_doch.accept_date, fleet_doch.accept_time, fleet_doch.wh_code, fleet_doch.dept_id, fleet_doch.wgCode, fleet_doch.purHndlCode, fleet_doch.Gapprove, fleet_doch.TotAppv, fleet_doch.LastAppv, fleet_doch.TstAppv, (SELECT ms_jobsite.region_name FROM ms_jobsite WHERE ms_jobsite.region_code = fleet_doch.region_code) AS region_name, (CASE fleet_doch.type_ref WHEN '1' THEN (SELECT fleet_sroh.sro_kind FROM fleet_sroh WHERE fleet_sroh.sro_code = fleet_doch.sro_code) WHEN '2' THEN (SELECT fleet_grh.priority_code FROM fleet_grh WHERE fleet_grh.doc_code = fleet_doch.sro_code) ELSE '' END) AS Priority FROM fleet_doch WHERE fleet_doch.doc_code = '$psNumber'"; $getPSHeaderArray = $this->Mmaster->getDataQuery($getPSHeaderQuery); $getPSHeader = $getPSHeaderArray[0]; $siteCode = $getPSHeader['region_code']; $yearNow = date('y') ; $getBranchCodeQuery = "SELECT PlantCode, company_code, PlantName, sar_code FROM ms_branch where PlantName = '$siteCode'"; $getBranchCodeArray = $this->Mmaster->getDataQuery($getBranchCodeQuery); $branchCode = $getBranchCodeArray[0]['PlantCode']; // $kodePRDoc = 'PRA'.$getPSHeader[$branchCode]; // $kodePRDoc = 'PRA03HOF18'; $kodePRDoc = 'PRA'.$branchCode.$siteCode.$yearNow; $getLastPRNumberQuery = "SELECT MAX ( RIGHT ( tr_purchase_reqh.pr_code , 6 ) ) as computed FROM tr_purchase_reqh WHERE tr_purchase_reqh.pr_code LIKE '$kodePRDoc%' "; $getLastPRNumberArray = $this->Mmaster->getDataQuery($getLastPRNumberQuery); // print_r($getLastPRNumberArray); die; $getLastPRNumbers = $getLastPRNumberArray[0]; $getLastPRNumber = $getLastPRNumbers['computed']; $newPRNumber = sprintf("%06d",$getLastPRNumber + 1); $detail = array(); foreach($detailQty as $matCodes => $reqQty) { // echo $matCodes.'<br />'; if(strpos($matCodes, '|-----|') !== FALSE ) { $matCodesArray = explode('|-----|', $matCodes); $matCodes = implode(' ', $matCodesArray); // print_r($matCodesArray); die; } if(strpos($matCodes, '|COMMASIGN|') !== FALSE){ $matCodes = str_replace("|COMMASIGN|", ",", $matCodes); } if(strpos($matCodes, '|') !== FALSE){ $matCodes = str_replace("|", ".", $matCodes); } $getPSDetailQuery = "select * from nv_ps_detail where doc_code = '$psNumber' AND part_code = '$matCodes'"; $getPSDetailArray = $this->Mmaster->getDataQuery($getPSDetailQuery); $sroCode = $getPSDetailArray[0]['sro_code']; $getSRODetailQuery = "select doc_code, part_code, prod_type, remark from fleet_grd where doc_code = '$sroCode' and part_code = '$matCodes'"; $getSRODetailArray = $this->Mmaster->getDataQuery($getSRODetailQuery); // print_r($getSRODetailArray); die; $sroRemark = $getSRODetailArray[0]['remark']; // print_r($sroRemark); die; $detail[$matCodes] = $getPSDetailArray[0]; $detail[$matCodes]['prQty'] = $reqQty; $lastPriceQuery = "select TOP 1 * from tr_purchaseD where Prod_code = '$matCodes' order by nomer DESC"; $getLastPriceArray = $this->Mmaster->getDataQuery($lastPriceQuery); if($getLastPriceArray) { $lastPrice = $getLastPriceArray[0]['harga']; $lastPO = $getLastPriceArray[0]['po_code']; } else { $lastPrice = false; $lastPO = false; } $detail[$matCodes]['lastPrice'] = $lastPrice; $detail[$matCodes]['lastPO'] = $lastPO; $detail[$matCodes]['remark'] = $sroRemark; } $getManPowerPRQuery = "SELECT ms_manpower_setB.nik as employee_code, upper(ms_manpower.name) as name, upper(ms_manpower.jabatan) as position_name, master_form.WindowName FROM ms_manpower, ms_manpower_setA, ms_manpower_setB, master_form WHERE ms_manpower_setA.FromID = ms_manpower_setB. FromID AND ms_manpower_setB.Nik = ms_manpower.Nik AND master_form.FromId = ms_manpower_setA.FromID AND ms_manpower.stedit<> '4' AND WindowName = 'w_pr_entry_modif' "; $getManPowerPRArray = $this->Mmaster->getDataQuery($getManPowerPRQuery); $kdUser = $session['KdUser']; $getJobSiteQuery = "select a.kduser, a.region_code, b.region_name, a.status_default_region as 'default' from ms_users_jobsite a, ms_jobsite b where kduser = '$kdUser' and b.region_code = a.region_code and b.stEdit <> 4"; $getJobSiteArray = $this->Mmaster->getDataQuery($getJobSiteQuery); // $getWarehouseQuery = "select a.wh_code, b.wh_name from ms_users_wh as a, ms_warehouse as b where b.wh_code = a.wh_code and a.kduser = '$kdUser' and a.region_code = '$siteCode' and b.stEdit <> 4"; $getWarehouseQuery = "select a.wh_code, b.wh_name from ms_users_wh as a, ms_warehouse as b where b.wh_code = a.wh_code and a.kduser = '$kdUser' and b.stEdit <> 4"; $getWarehouseArray = $this->Mmaster->getDataQuery($getWarehouseQuery); $costCenter = $getPSHeader['dept_code']; $getCostCenterQuery = "select CostCenter, CostCenterName from ms_cost_center where region_code = '$siteCode'"; $getCostCenterArray = $this->Mmaster->getDataQuery($getCostCenterQuery); $deptId = $getPSHeader['dept_id']; $getDeptQuery = "select dept_code, dept_name from ms_department where stEdit <> 4"; $getDeptArray = $this->Mmaster->getDataQuery($getDeptQuery); $scope = $getPSHeader['Gapprove']; $getScopeQuery = "select a.GAppCode, b.GAppName, a.status_default_scope as 'default' from ms_users_scope as a, ms_approve_group as b where b.GAppCode = a.GAppCode and a.kduser = '$kdUser' and b.stEdit <> 4"; $getScopeArray = $this->Mmaster->getDataQuery($getScopeQuery); $getPICQuery = "select purHndlCode, purHndlName from ms_purHndl where stEdit <> 4"; $getPICArray = $this->Mmaster->getDataQuery($getPICQuery); $getWGQuery = "select a.kduser, a.wgCode, a.status_default_wgroup as 'default', b.wgName from ms_users_WGroup as a, ms_purwkgrp as b where b.wgCode = a.wgCode and a.kduser='$kdUser' and b.stEdit <> 4"; $getWGArray = $this->Mmaster->getDataQuery($getWGQuery); $getUnitCodeQuery = "SELECT ms_unit.unit_code, ms_unit.model_no, ms_unit.unit_name, ms_unit.region_code, ms_unit.dept_code FROM ms_unit WHERE ( ms_unit.active = '1' ) and ( ms_unit.tMain = 1 )"; $getUnitCode = $this->Mmaster->getDataQuery($getUnitCodeQuery); $data['post'] = $post; $data['detail'] = $detail; $data['psHeader'] = $getPSHeader; $data['manPowerPR'] = $getManPowerPRArray; $data['jobsite'] = $getJobSiteArray; $data['projectArea'] = $siteCode; $data['warehouses'] = $getWarehouseArray; $data['whCode'] = $getPSHeader['wh_code']; $data['costCenter'] = $costCenter; $data['costCenters'] = $getCostCenterArray; $data['deptId'] = $deptId; $data['departments'] = $getDeptArray; $data['scope'] = $scope; $data['unitCode'] = $getUnitCode; $data['scopes'] = $getScopeArray; $data['pic'] = $getPSHeader['purHndlCode']; $data['pics'] = $getPICArray; $data['workgroup'] = $getWGArray; $data['custSupp'] = $session['db']; $data['refNo'] = $psNumber; $data['remark'] = $getPSHeader['doc_remark']; // printExit($getCostCenterQuery); // echo '<pre>'; print_r($data); die; // print_r($getLastPRNumber); echo '<br/>' . $newPRNumber.'<br/>'; // die; if($post['action'] == 'createPR') { $this->load->view('template/header'); $this->load->view('template/sidebar'); $this->load->view('vcreatepr',$data); $this->load->view('template/footer'); $this->load->view('template/controlsidebar'); } elseif($post['action'] == 'createGI') { $this->load->view('template/header'); $this->load->view('template/sidebar'); $this->load->view('vcreategi',$data); $this->load->view('template/footer'); $this->load->view('template/controlsidebar'); }
Editor is loading...