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);
}
