public function index() { App::import('Model', 'QuoteManager.Quote'); $quoteModel = new Quote(); $quoteDataList = $quoteModel->find('all', array('fields' => array('quote_number', 'status'), 'conditions' => array('Quote.vid' => null, 'Quote.created_by' => $this->loginUser['id']))); App::import('Model', 'WorkOrderManager.WorkOrder'); $workOrderModel = new WorkOrder(); $workOrderDataList = $workOrderModel->find('all', array('fields' => array('work_order_number', 'status'), 'conditions' => array('WorkOrder.created_by' => $this->loginUser['id']))); App::import('Model', 'PurchaseOrderManager.PurchaseOrder'); $purchaseOrderModel = new PurchaseOrder(); $purchaseOrderDataList = $purchaseOrderModel->find('all', array('fields' => array('purchase_order_num', 'received'), 'conditions' => array('PurchaseOrder.created_by' => $this->loginUser['id']))); $this->set(compact('quoteDataList', 'workOrderDataList', 'purchaseOrderDataList')); }
public function getWOSkid($skid_no = null) { $this->autoRender = false; App::import('Model', 'WorkOrderManager.WorkOrder'); $WorkOrder_Model = new WorkOrder(); $WorkOrder_data = $WorkOrder_Model->find('first', array('conditions' => array('WorkOrder.skid_number' => $skid_no))); if (!empty($WorkOrder_data)) { $WO_datas = $WorkOrder_Model->find('all', array('conditions' => array('WorkOrder.skid_number' => $skid_no), "recursive" => -1)); $wo_number = ""; $wo_id = ""; $cnt = count($WO_datas); foreach ($WO_datas as $WO_data) { $wo_number .= $WO_data['WorkOrder']['work_order_number']; $wo_id .= $WO_data['WorkOrder']['id']; if ($cnt > 1) { $wo_number .= ","; $wo_id .= ","; } $cnt--; } $data['skid_number'] = $WorkOrder_data['WorkOrder']['skid_number']; $data['skid_weight'] = $WorkOrder_data['WorkOrder']['skid_weight']; $data['wo_number'] = $wo_number; $data['wo_id'] = $wo_id; echo json_encode($data); } else { App::import('Model', 'ContainerManager.SkidInventory'); $SkidInventory_Model = new SkidInventory(); $SkidInventory_data = $SkidInventory_Model->find('first', array('conditions' => array('SkidInventory.skid_no' => $skid_no))); if (!empty($SkidInventory_data)) { $data['skid_number'] = $SkidInventory_data['SkidInventory']['skid_no']; $data['skid_weight'] = $SkidInventory_data['SkidInventory']['weight']; $data['wo_number'] = null; $data['wo_id'] = null; } else { $data['skid_number'] = ''; $data['skid_weight'] = "0.00"; $data['wo_number'] = null; $data['wo_id'] = null; } echo json_encode($data); } exit; }
public function corn_job() { $this->layoutOpt['layout'] = 'report'; App::import('Model', 'WorkOrderManager.WorkOrder'); $WorkOrder_Model = new WorkOrder(); $work_order = $WorkOrder_Model->find("all", array("conditions" => array("WorkOrder.is_print" => 0), "recursive" => -1)); $user_id = $this->loginUser['id']; $this->set(compact('work_order', 'user_id')); }
public function getWorkOrder($id = null, $customer_id) { App::import("Model", "WorkOrderManager.WorkOrder"); $WorkOrder_model = new WorkOrder(); $work_order = $WorkOrder_model->find("first", array("conditions" => array("WorkOrder.id" => $id))); $this->set(compact('id', 'work_order', "customer_id")); $this->render('Elements/PartialData/getWorkOrder'); }
function getWOInfo($id = null) { App::import('Model', 'WorkOrderManager.WorkOrder'); $WorkOrder = new WorkOrder(); $WorkOrder_data = $WorkOrder->find("first", array("conditions" => array('WorkOrder.id' => $id))); return $WorkOrder_data; }
function auto_generate_number($type) { $value = ""; if ($type == "Quote") { App::uses('Quote', 'QuoteManager.Model'); $quoteModel = new Quote(); $quotes = $quoteModel->find('all', array('fields' => array('Quote.id,Quote.quote_number'))); if ($quotes) { $quote_number = (int) $quotes[count($quotes) - 1]['Quote']['quote_number']; $quote_number = explode("-", $quote_number); $length = strlen($quote_number[0] + 1) == strlen($quote_number[0]) ? strlen($quote_number[0]) : strlen($quote_number[0] + 1); for ($i = $length; $i < 6; $i++) { $value .= '0'; } $value .= $quote_number[0] + 1; } else { $value = "000001"; } } elseif ($type == "Work Order") { App::uses('WorkOrder', 'WorkOrderManager.Model'); $woModel = new WorkOrder(); $wos = $woModel->find('all', array('fields' => array('WorkOrder.id,work_order_number'))); if ($wos) { $wo_number = (int) $wos[count($wos) - 1]['WorkOrder']['work_order_number']; $length = strlen($wo_number + 1) == strlen($wo_number) ? strlen($wo_number) : strlen($wo_number + 1); for ($i = $length; $i < 6; $i++) { $value .= '0'; } $value .= $wo_number + 1; } else { $value = "000001"; } } elseif ($type == "Purchase Order") { App::uses('PurchaseOrder', 'PurchaseOrderManager.Model'); $poModel = new PurchaseOrder(); $pos = $poModel->find('all', array('fields' => array('PurchaseOrder.id,purchase_order_num'))); if ($pos) { $po_number = (int) $pos[count($pos) - 1]['PurchaseOrder']['purchase_order_num']; $length = strlen($po_number + 1) == strlen($po_number) ? strlen($po_number) : strlen($po_number + 1); for ($i = $length; $i < 6; $i++) { $value .= '0'; } $value .= $po_number + 1; } else { $value = "000001"; } } elseif ($type == "Invoice") { App::uses('Invoice', 'Invoice.Model'); $invoiceModel = new Invoice(); $invoice = $invoiceModel->find('all', array('fields' => array('Invoice.id,invoice_no'))); if ($invoice) { $invoice_number = (int) $invoice[count($invoice) - 1]['Invoice']['invoice_no']; $length = strlen($invoice_number + 1) == strlen($invoice_number) ? strlen($invoice_number) : strlen($invoice_number + 1); for ($i = $length; $i < 6; $i++) { $value .= '0'; } $value .= $invoice_number + 1; } else { $value = "000001"; } } return $value; }
public function getQuote($id = null) { $this->autoRender = false; App::import('Model', 'WorkOrderManager.WorkOrder'); $workOrderModel = new WorkOrder(); $workOrder = $workOrderModel->find("first", array("conditions" => array("WorkOrder.id" => $id))); $all_items = $this->QuoteItem->ListQuoteItems($workOrder['Quote']['id']); $all_items = $this->QuoteItem->AdjustPOItem($all_items); //pr($all_items);exit; // debug($all_items); // $main_item_list = $all_items['quantity_list']; // $price_list = $all_items['price_list']; // $title_list = $all_items['title_list']; // $name_list = $all_items['name_list']; // $restrictedSupplier = $this->QuoteItemComponent->RestrictedSupplierOfPO($work_id); // $supplier_list = $this->QuoteItem->SupplierAndItemInfo(); App::import('Model', 'QuoteManager.Quote'); $quote = new Quote(); //$quote->recursive = 3; $quote_info = $quote->find("first", array("conditions" => array("Quote.id" => $workOrder['Quote']['id']))); $add_formate = $this->QuoteItem->address_format($quote_info['Quote']['address'], $quote_info['Quote']['city'], $quote_info['Quote']['province'], $quote_info['Quote']['country'], $quote_info['Quote']['postal_code']); if (!empty($quote_info['Quote']['est_shipping'])) { $quote_info['Quote']['est_shipping'] = $this->dateFormatPo($quote_info['Quote']['est_shipping']); } else { if ($quote_info['Quote']['delivery'] == '4 - 8 Weeks Delivery') { $add_days = 56; $today = $quote_info['Quote']['quote_created_date']; $esd_date = date('d/m/Y', strtotime($today) + 24 * 3600 * $add_days); } if ($quote_info['Quote']['delivery'] == '5 - 10 Weeks Delivery') { $add_days = 70; $today = $quote_info['Quote']['quote_created_date']; $esd_date = date('d/m/Y', strtotime($today) + 24 * 3600 * $add_days); } $quote_info['Quote']['est_shipping'] = $esd_date; } $quote_info['Quote']['sales_person'] = unserialize($quote_info['Quote']['sales_person']); $quote_info['Quote']['address_formate'] = $add_formate; $quote_info['all_item'] = $all_items; echo json_encode($quote_info); }
/** * edit method * * @param string $id * @return void */ public function edit($id = null, $section = null) { $this->InstallerSchedule->id = $id; if (!$this->InstallerSchedule->exists()) { throw new NotFoundException(__('Invalid Installer')); } if ($this->request->is('post') || $this->request->is('put')) { if ($this->InstallerSchedule->save($this->request->data)) { $this->Session->setFlash(__('The Installer has been saved')); $this->redirect(array('action' => 'detail_section', $this->InstallerSchedule->id, $section)); } else { $this->Session->setFlash(__('The Installer could not be saved. Please, try again.')); } } else { $this->request->data = $this->InstallerSchedule->read(null, $id); } $user_id = $this->loginUser['id']; App::uses('Installer', 'ScheduleManager.Model'); $installerModel = new Installer(); $installers = $installerModel->find('list', array('fields' => array('id', 'name_lookup_id'))); App::uses('WorkOrder', 'WorkOrderManager.Model'); $workOrderModel = new WorkOrder(); $workOrders = $workOrderModel->find('list', array('fields' => array('id', 'work_order_number'), 'conditions' => array('status' => 'Approve'))); $this->set(compact('user_id', 'workOrders', 'installers', 'id', 'section')); }
/** * edit method * * @param string $id * @return void */ public function edit($id = null, $section = null) { $this->ServiceEntry->id = $id; if (!$this->ServiceEntry->exists()) { throw new NotFoundException(__('Invalid ServiceEntry')); } if ($this->request->is('post') || $this->request->is('put')) { // $s_date = date("Y-m-d H:i:s", strtotime($this->formatDate($this->request->data['ServiceEntry']['created']))); // $add_e_date = strtotime($this->formatDate($this->request->data['ServiceEntry']['booked_for'])) + ( 60 * 60 ); // $e_date = date("Y-m-d H:i:s", $add_e_date); // $schedule['Appointment']['work_order_id'] = $this->request->data['ServiceEntry']['work_order_id']; // $schedule['Appointment']['created_by'] = $this->request->data['ServiceEntry']['created_by']; // $schedule['Appointment']['type'] = $this->request->data['ServiceEntry']['type']; // $schedule['Appointment']['start_date'] = $s_date; // $schedule['Appointment']['end_date'] = $e_date; // App::import('Model', 'ScheduleManager.Appointment'); // $Appointment_Model = new Appointment(); // $app_data = $Appointment_Model->find("first", array("conditions" => array("Appointment.service_entry_id" => $id))); // $schedule['Appointment']['id'] = $app_data['Appointment']['id']; if ($this->ServiceEntry->save($this->request->data)) { // $Appointment_Model->save($schedule); $this->Session->setFlash(__('The Service Entry has been saved')); if ($section != 'basic') { $this->redirect(array('action' => 'detail_section', $this->ServiceEntry->id, $section)); } else { $this->redirect(array('action' => 'detail_section', $this->ServiceEntry->id, $section)); } } else { $this->Session->setFlash(__('The Service Entry could not be saved. Please, try again.')); } } else { $this->request->data = $this->ServiceEntry->read(null, $id); } App::uses('WorkOrder', 'WorkOrderManager.Model'); $workOrderModel = new WorkOrder(); $workOrders = $workOrderModel->find('list', array('fields' => array('id', 'work_order_number'), 'conditions' => array('status' => 'Approve'))); $user_id = $this->loginUser['id']; $this->set(compact('workOrders', 'purchaseOrders', 'user_id', 'id', 'section')); }
function getWOAddress($id = null) { $this->autoRender = false; App::import('Model', 'WorkOrderManager.WorkOrder'); $workOrderModel = new WorkOrder(); $workOrder = $workOrderModel->find("first", array("conditions" => array("WorkOrder.id" => $id))); echo json_encode($workOrder); }