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