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