function getDepartment() { $this->autoRender = false; $sql = "SELECT * FROM departments;"; $datas = $this->Cabinet->query($sql); App::uses("ItemDepartment", "Inventory.Model"); foreach ($datas as $data) { $ItemDepartment = new ItemDepartment(); $item_department['ItemDepartment']['name'] = $data['departments']['Department']; if ($data['departments']['Inactive'] == 0) { $item_department['ItemDepartment']['active'] = 1; } else { $item_department['ItemDepartment']['active'] = 0; } $item_department['ItemDepartment']['supplier_required'] = $data['departments']['SupplierReqd']; $item_department['ItemDepartment']['stock_number_required'] = $data['departments']['StockNoReqd']; $item_department['ItemDepartment']['direct_sale'] = $data['departments']['NFR']; $item_department['ItemDepartment']['instruction'] = $data['departments']['Instructions']; $item_department['ItemDepartment']['qb_item_ref'] = $data['departments']['QBAccount']; if (!$ItemDepartment->save($item_department)) { pr($ItemDepartment->validationErrors); } } }
function getItemDepartmentName($id) { App::uses("ItemDepartment", "Inventory.Model"); $itemDepartment = new ItemDepartment(); $itemDepartment->recursive = 0; $itemDepartmentDetail = $itemDepartment->find("first", array("fields" => array("id", "name"), 'conditions' => array('ItemDepartment.id' => $id))); return $itemDepartmentDetail['ItemDepartment']['name']; }
public function findQuoteItemDept($id = null) { App::import("Model", "Inventory.ItemDepartment"); $ItemDepartment = new ItemDepartment(); $itemdepartment_info = $ItemDepartment->find("first", array("conditions" => array("ItemDepartment.id" => $id), 'recursive' => -1)); //if(!empty($itemdepartment_info['ItemDepartment']['supplier_required'])) return $itemdepartment_info; }
function ItemDepartment() { App::uses("ItemDepartment", "Model"); $itemDepartment = new ItemDepartment(); return $itemDepartment->find("list", array("fields" => array("id", "name"))); }