function getItem()
{
set_time_limit(0);
$this->autoRender = false;
$sql = "SELECT * FROM `inventory`\n\t\tWHERE\n\t\t\t`Description` NOT LIKE '%:V'\n\t\t\tAND `Description` NOT LIKE '%:M'\n\t\t\tAND `Description` NOT LIKE '%:P'\n\t\t\tAND `Description` NOT LIKE '%-V'\n\t\t\tAND `Description` NOT LIKE '%-M'\n\t\t\tAND `Description` NOT LIKE '%-P'\n\t\t\tAND `Department` NOT IN ( 'Stain', 'Sheet Stk', 'Sheet Goods' );";
$datas = $this->Cabinet->query($sql);
App::uses("Item", "Inventory.Model");
App::uses("Supplier", "Inventory.Model");
$supplier_model = new Supplier();
App::uses("Material", "Inventory.Model");
$Material_model = new Material();
App::uses("ItemDepartment", "Inventory.Model");
$ItemDepartment_model = new ItemDepartment();
foreach ($datas as $data) {
$Item = new Item();
$item_data = array();
$item_data['Item']['item_title'] = $data['inventory']['Description'];
$item_data['Item']['number'] = $data['inventory']['Number'];
$item_data['Item']['old_number'] = $data['inventory']['Number'];
$item_data['Item']['description'] = $data['inventory']['Reference'];
$item_data['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$item_data['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$item_data['Item']['minimum'] = $data['inventory']['Minimum'];
$item_data['Item']['maximum'] = $data['inventory']['Maximum'];
$item_data['Item']['location'] = $data['inventory']['Location'];
$supplier_id = $supplier_model->find('first', array('fields' => array('id'), 'conditions' => array('Supplier.name' => $data['inventory']['Supplier']), 'recursive' => -1));
$item_data['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
$item_data['Item']['created'] = $data['inventory']['Created'];
$item_data['Item']['modified'] = $data['inventory']['Modified'];
$item_data['Item']['item_cost'] = $data['inventory']['Cost'];
$item_data['Item']['PGM_Biesse'] = $data['inventory']['PGM_Biesse'];
$item_data['Item']['PGM_Morbi'] = $data['inventory']['PGM_Morbi'];
$item_data['Item']['PGM_Edgeband'] = $data['inventory']['PGM_Edgeband'];
$item_data['Item']['material'] = "Standard";
$item_data['Item']['item_material'] = 2;
$item_data['Item']['item_material_group'] = 3;
$item_data['Item']['variable_cost'] = $data['inventory']['Variablecost'];
$item_data['Item']['main_item'] = $data['inventory']['Mainitem'];
$item_data['Item']['base_item'] = 0;
$item_data['Item']['Department'] = $data['inventory']['Department'];
$department_id = $ItemDepartment_model->find('first', array('fields' => array('id', "name"), 'conditions' => array('ItemDepartment.name' => $data['inventory']['Department']), 'recursive' => -1));
$item_data['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$item_data['Item']['price'] = $data['inventory']['Price'];
$item_data['Item']['factor'] = $data['inventory']['Factor'];
$item_data['Item']['image'] = $data['inventory']['Image'];
$item_data['Item']['current_stock'] = !empty($data['inventory']['Onhand']) ? $data['inventory']['Onhand'] : 0;
$item_data['Item']['item_group'] = 1;
if (!$Item->save($item_data)) {
pr($Item->validationErrors);
}
//------------VENEER------------------------
$Item_Veneer = new Item();
$veneer = array();
$veneer['Item']['base_item'] = $Item->id;
$veneer['Item']['material'] = "Maple";
$veneer['Item']['item_material'] = 1;
$veneer['Item']['item_material_group'] = 1;
$veneer['Item']['description'] = $data['inventory']['Reference'];
$veneer['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$veneer['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$veneer['Item']['Department'] = $data['inventory']['Department'];
$veneer['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$veneer['Item']['item_group'] = 1;
$veneer['Item']['item_title'] = $data['inventory']['Description'];
$veneer['Item']['item_cost'] = $data['inventory']['Cost'];
$veneer['Item']['price'] = $data['inventory']['Price'];
$veneer['Item']['factor'] = $data['inventory']['Factor'];
$veneer['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
if (!$Item_Veneer->save($veneer)) {
pr($Item_Veneer->validationErrors);
}
//------------MDF------------------------
$Item_MDF = new Item();
$mdf = array();
$mdf['Item']['base_item'] = $Item->id;
$mdf['Item']['material'] = $data['inventory']['Reference'];
$mdf['Item']['item_material'] = 145;
$mdf['Item']['item_material_group'] = 2;
$mdf['Item']['description'] = 'ADJS';
$mdf['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$mdf['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$mdf['Item']['Department'] = $data['inventory']['Department'];
$mdf['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$mdf['Item']['item_group'] = 1;
$mdf['Item']['item_title'] = $data['inventory']['Description'];
$mdf['Item']['item_cost'] = $data['inventory']['Cost'];
$mdf['Item']['price'] = $data['inventory']['Price'];
$mdf['Item']['factor'] = $data['inventory']['Factor'];
$mdf['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
if (!$Item_MDF->save($mdf)) {
pr($Item_MDF->validationErrors);
}
//------------Plywood------------------------
$Item_plywood = new Item();
$plywood = array();
$plywood['Item']['base_item'] = $Item->id;
$plywood['Item']['material'] = $data['inventory']['Reference'];
$plywood['Item']['item_material'] = 3;
$plywood['Item']['item_material_group'] = 4;
$plywood['Item']['description'] = 'ADJS';
$plywood['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$plywood['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$plywood['Item']['Department'] = $data['inventory']['Department'];
$plywood['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$plywood['Item']['item_group'] = 1;
$plywood['Item']['item_title'] = $data['inventory']['Description'];
$plywood['Item']['item_cost'] = $data['inventory']['Cost'];
$plywood['Item']['price'] = $data['inventory']['Price'];
$plywood['Item']['factor'] = $data['inventory']['Factor'];
$plywood['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
if (!$Item_plywood->save($plywood)) {
pr($Item_plywood->validationErrors);
}
//------------Acrylic-19mm------------------------
$Item_Acr19 = new Item();
$Acr19 = array();
$Acr19['Item']['base_item'] = $Item->id;
$Acr19['Item']['material'] = $data['inventory']['Reference'];
$Acr19['Item']['item_material'] = 4;
$Acr19['Item']['item_material_group'] = 5;
$Acr19['Item']['description'] = 'ADJS';
$Acr19['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$Acr19['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$Acr19['Item']['Department'] = $data['inventory']['Department'];
$Acr19['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$Acr19['Item']['item_group'] = 1;
$Acr19['Item']['item_title'] = $data['inventory']['Description'];
$Acr19['Item']['item_cost'] = $data['inventory']['Cost'];
$Acr19['Item']['price'] = $data['inventory']['Price'];
$Acr19['Item']['factor'] = $data['inventory']['Factor'];
$Acr19['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
if (!$Item_Acr19->save($Acr19)) {
pr($Item_Acr19->validationErrors);
}
//------------Acrylic-38mm------------------------
$Item_Acr38 = new Item();
$Acr38 = array();
$Acr38['Item']['base_item'] = $Item->id;
$Acr38['Item']['material'] = $data['inventory']['Reference'];
$Acr38['Item']['item_material'] = 148;
$Acr38['Item']['item_material_group'] = 6;
$Acr38['Item']['description'] = 'ADJS';
$Acr38['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$Acr38['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$Acr38['Item']['Department'] = $data['inventory']['Department'];
$Acr38['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$Acr38['Item']['item_group'] = 1;
$Acr38['Item']['item_title'] = $data['inventory']['Description'];
$Acr38['Item']['item_cost'] = $data['inventory']['Cost'];
$Acr38['Item']['price'] = $data['inventory']['Price'];
$Acr38['Item']['factor'] = $data['inventory']['Factor'];
$Acr38['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
if (!$Item_Acr38->save($Acr38)) {
pr($Item_Acr38->validationErrors);
}
//------------HPL-19mm------------------------
$Item_HPL19 = new Item();
$HPL19 = array();
$HPL19['Item']['base_item'] = $Item->id;
$HPL19['Item']['material'] = $data['inventory']['Reference'];
$HPL19['Item']['item_material'] = 146;
$HPL19['Item']['item_material_group'] = 7;
$HPL19['Item']['description'] = 'ADJS';
$HPL19['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$HPL19['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$HPL19['Item']['Department'] = $data['inventory']['Department'];
$HPL19['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$HPL19['Item']['item_group'] = 1;
$HPL19['Item']['item_title'] = $data['inventory']['Description'];
$HPL19['Item']['item_cost'] = $data['inventory']['Cost'];
$HPL19['Item']['price'] = $data['inventory']['Price'];
$HPL19['Item']['factor'] = $data['inventory']['Factor'];
$HPL19['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
if (!$Item_HPL19->save($HPL19)) {
pr($Item_HPL19->validationErrors);
}
//------------HPL-38mm------------------------
$Item_HPL38 = new Item();
$HPL38 = array();
$HPL38['Item']['base_item'] = $Item->id;
$HPL38['Item']['material'] = $data['inventory']['Reference'];
$HPL38['Item']['item_material'] = 147;
$HPL38['Item']['item_material_group'] = 8;
$HPL38['Item']['description'] = 'ADJS';
$HPL38['Item']['width'] = !empty($data['inventory']['Width']) ? $data['inventory']['Width'] : 0;
$HPL38['Item']['length'] = !empty($data['inventory']['Length']) ? $data['inventory']['Length'] : 0;
$HPL38['Item']['Department'] = $data['inventory']['Department'];
$HPL38['Item']['item_department_id'] = $department_id['ItemDepartment']['id'];
$HPL38['Item']['item_group'] = 1;
$HPL38['Item']['item_title'] = $data['inventory']['Description'];
$HPL38['Item']['item_cost'] = $data['inventory']['Cost'];
$HPL38['Item']['price'] = $data['inventory']['Price'];
$HPL38['Item']['factor'] = $data['inventory']['Factor'];
$HPL38['Item']['supplier_id'] = $supplier_id['Supplier']['id'];
if (!$Item_HPL38->save($HPL38)) {
pr($Item_HPL38->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")));
}
