function getCabinet()
{
$this->autoRender = false;
$sql = "SELECT * FROM cabinetlist;";
$datas = $this->Cabinet->query($sql);
App::uses("Cabinet", "Inventory.Model");
foreach ($datas as $data) {
$cabinet_model = new Cabinet();
$cabinet_data['Cabinet']['name'] = $data['cabinetlist']['Cabinet'];
$cabinet_data['Cabinet']['description'] = $data['cabinetlist']['Description'];
$cabinet_data['Cabinet']['actual_dimensions_width'] = $data['cabinetlist']['Width'];
$cabinet_data['Cabinet']['actual_dimensions_height'] = $data['cabinetlist']['Height'];
$cabinet_data['Cabinet']['actual_dimensions_depth'] = $data['cabinetlist']['Depth'];
$cabinet_data['Cabinet']['left_gable_price'] = $data['cabinetlist']['LeftGablePrice'];
$cabinet_data['Cabinet']['right_gable_price'] = $data['cabinetlist']['RightGablePrice'];
$cabinet_data['Cabinet']['top_bottom_width'] = $data['cabinetlist']['TBWidth'];
$cabinet_data['Cabinet']['top_bottom_depth'] = $data['cabinetlist']['TBDepth'];
$cabinet_data['Cabinet']['top_bottom_sqr'] = $data['cabinetlist']['TBSquareFeet'];
$cabinet_data['Cabinet']['cabinet_back_width'] = $data['cabinetlist']['BackWidth'];
$cabinet_data['Cabinet']['cabinet_back_height'] = $data['cabinetlist']['BackHeight'];
$cabinet_data['Cabinet']['cabinet_back_sqr'] = $data['cabinetlist']['BackSquareFeet'];
$cabinet_data['Cabinet']['MelCost'] = $data['cabinetlist']['MelCost'];
$cabinet_data['Cabinet']['taping'] = $data['cabinetlist']['Taping'];
$cabinet_data['Cabinet']['drilling'] = $data['cabinetlist']['Drilling'];
$cabinet_data['Cabinet']['back_cutting'] = $data['cabinetlist']['BackCutting'];
$cabinet_data['Cabinet']['BoxPrice'] = $data['cabinetlist']['BoxPrice'];
$cabinet_data['Cabinet']['top_door_width'] = $data['cabinetlist']['TopDoorWidth'];
$cabinet_data['Cabinet']['top_door_height'] = $data['cabinetlist']['TopDoorHeight'];
$cabinet_data['Cabinet']['top_door_count'] = $data['cabinetlist']['TopDoorCount'];
$cabinet_data['Cabinet']['bottom_door_width'] = $data['cabinetlist']['BottomDoorWidth'];
$cabinet_data['Cabinet']['bottom_door_height'] = $data['cabinetlist']['BottomDoorHeight'];
$cabinet_data['Cabinet']['bottom_door_count'] = $data['cabinetlist']['BottomDoorCount'];
$cabinet_data['Cabinet']['top_drawer_front_width'] = $data['cabinetlist']['TopDrawerWidth'];
$cabinet_data['Cabinet']['top_drawer_front_height'] = $data['cabinetlist']['TopDrawerHeight'];
$cabinet_data['Cabinet']['top_drawer_front_count'] = $data['cabinetlist']['TopDrawerCount'];
$cabinet_data['Cabinet']['middle_drawer_front_width'] = $data['cabinetlist']['MidDrawerWidth'];
$cabinet_data['Cabinet']['middle_drawer_front_height'] = $data['cabinetlist']['MidDrawerHeight'];
$cabinet_data['Cabinet']['middle_drawer_front_count'] = $data['cabinetlist']['MidDrawerCount'];
$cabinet_data['Cabinet']['bottom_drawer_front_width'] = $data['cabinetlist']['BottomDrawerWidth'];
$cabinet_data['Cabinet']['bottom_drawer_front_height'] = $data['cabinetlist']['BottomDrawerHeight'];
$cabinet_data['Cabinet']['bottom_drawer_front_count'] = $data['cabinetlist']['BottomDrawerCount'];
$cabinet_data['Cabinet']['dummy_drawer_front_width'] = $data['cabinetlist']['DummyHeight'];
$cabinet_data['Cabinet']['dummy_drawer_front_height'] = $data['cabinetlist']['DummyWidth'];
$cabinet_data['Cabinet']['dummy_drawer_front_count'] = $data['cabinetlist']['DummyCount'];
$cabinet_data['Cabinet']['drawer_bottom_width'] = $data['cabinetlist']['DrawerBottomWidth'];
$cabinet_data['Cabinet']['drawer_bottom_depth'] = $data['cabinetlist']['DrawerBottomDepth'];
$cabinet_data['Cabinet']['number_hinges'] = $data['cabinetlist']['NumberofHinges'];
$cabinet_data['Cabinet']['AssemblyCost'] = $data['cabinetlist']['AssemblyCost'];
$cabinet_data['Cabinet']['UnitType'] = $data['cabinetlist']['UnitType'];
$cabinet_data['Cabinet']['number_shelfs'] = $data['cabinetlist']['ShelfCount'];
$cabinet_data['Cabinet']['Line'] = $data['cabinetlist']['Line'];
$cabinet_data['Cabinet']['BothBotDoors'] = $data['cabinetlist']['BothBotDoors'];
$cabinet_data['Cabinet']['include_on_door_list'] = $data['cabinetlist']['IncOnDoorList'];
$cabinet_data['Cabinet']['include_on_finishing_list'] = $data['cabinetlist']['IncOnFinList'];
$cabinet_data['Cabinet']['FinishedEndSquareFeet'] = $data['cabinetlist']['FinishedEndSquareFeet'];
$cabinet_data['Cabinet']['FinishedEndPanelPrice'] = $data['cabinetlist']['FinishedEndPanelPrice'];
$cabinet_data['Cabinet']['VeneerPanelSquareFeet'] = $data['cabinetlist']['VeneerPanelSquareFeet'];
$cabinet_data['Cabinet']['VeneerPriceNotIncluded'] = $data['cabinetlist']['VeneerPriceNotIncluded'];
$cabinet_data['Cabinet']['OutsideProfiling'] = $data['cabinetlist']['OutsideProfiling'];
$cabinet_data['Cabinet']['DrawerCount'] = $data['cabinetlist']['DrawerCount'];
$cabinet_data['Cabinet']['DrawerHardwareCost'] = $data['cabinetlist']['DrawerHardwareCost'];
$cabinet_data['Cabinet']['ImageID'] = $data['cabinetlist']['ImageID'];
if (!$cabinet_model->save($cabinet_data)) {
pr($cabinet_model->validationErrors);
}
}
}
