private static function getStartingID($directory)
{
$coreSettings = Settings::find('core');
$startingID = 1;
if (isset($coreSettings->data->startingIDs)) {
if (isset($coreSettings->data->startingIDs->{$directory}) && is_numeric($coreSettings->data->startingIDs->{$directory})) {
$startingID = $coreSettings->data->startingIDs->{$directory};
}
}
return $startingID;
}
public function update($id)
{
$rules = array('value' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return Redirect::route('admin.settings.edit', array('id' => $id))->withErrors($validator)->With(Input::all());
} else {
$setting = Settings::find($id);
$setting->value = Input::get('value');
if ($setting->save()) {
return Redirect::route('admin.settings.index')->with('success', Lang::get('messages.settings_update'));
}
}
return Redirect::route('admin.settings.index')->with('success', Lang::get('messages.settings_update'));
}
public function savesettings()
{
if (Input::get('id')) {
$settings = Settings::find(Input::get('id'));
} else {
$settings = new Settings();
}
$settings->area = Input::get('area');
$settings->section = Input::get('section');
$settings->setting_name = Input::get('setting_name');
$settings->setting_value = Input::get('setting_value');
$settings->autoload = Input::get('autoload');
Event::fire('backend.settings.save', array($settings));
$settings->save();
return Redirect::to('backend/settings/')->withMessage($this->notifyView(Lang::get('laracms::messages.settings_saved'), 'success'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
if (ACL::checkUserPermission('settings.index') == false) {
return Redirect::action('dashboard');
}
$settingsInfo = Settings::find($id);
if (!empty($settingsInfo)) {
$title = Lang::get('Edit Setting');
$formOpen = Form::open(array('method' => 'post', 'id' => 'form-settings', 'class' => '', 'route' => array('settings.update', $id)));
$formClose = Form::close();
$data = array('title' => $title, 'formOpen' => $formOpen, 'formClose' => $formClose, 'settingsInfo' => $settingsInfo);
return View::make('settings/edit', $data);
} else {
$message = 'Cannot find SettingsInfo';
return Redirect::action('settings.index')->with('error', $message);
}
}
/**
* @param $activityId
* @return array
*/
public function getActivityDefaultValues($activityId)
{
return $this->activity->find($activityId)->default_field_values;
}
public function save_settings()
{
$settings = Settings::all();
foreach ($settings as $setting) {
if (Input::get($setting->id) != NULL) {
$temp_setting = Settings::find($setting->id);
$temp_setting->value = Input::get($setting->id);
$temp_setting->save();
}
}
return Redirect::to('/admin/settings?success=1');
}
public function getCostingRecord($costingDb, $quantity = 0)
{
App::uses('Settings', 'Model');
App::uses('Customer', 'Model');
//$costingDb = $this->Costing->findById($costingId);
$exportDate = date('Y-m-d', time());
$settingModel = new Settings();
$settings = Hash::combine($settingModel->find("all"), '{n}.Settings.key', '{n}.Settings.val');
$customerModel = new Customer();
$customer = isset($costingDb['Product']['customer_id']) ? $customerModel->findById($costingDb['Product']['customer_id']) : array();
$data = array();
if (empty($quantity)) {
$quantity = $costingDb['Costing']['quantity'];
}
//row 1
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = 'HAVUPACKAGE';
$row[4] = '';
$row[5] = '';
$row[6] = '';
$row[7] = '';
$row[8] = 'COSTOFF';
$data[] = $row;
//row 2
$row = array();
$row[0] = '';
$row[1] = 'CONG TY TNHH BAO BI GIAY HOANG VUONG';
$data[] = $row;
//row 3
$data[] = array();
//row 4
$row = array();
$row[0] = 'DATE (YYYY-MM-DD):';
$row[1] = $exportDate;
$row[2] = '';
$row[3] = '';
$row[4] = "QUOTATION SHEET No:";
$data[] = $row;
$strLine = '-------------------------------------------------------------------------------------------------------------------------------';
//row 5
$row = array();
$row[0] = $strLine;
$data[] = $row;
//row 6
$row = array();
$row[0] = 'Customer:';
$row[1] = '';
$row[2] = isset($customer['Customer']['name']) ? $customer['Customer']['name'] : '';
$row[3] = '';
$row[4] = '';
$row[5] = 'Product Specification:';
$row[6] = '';
$row[7] = isset($costingDb['Product']['specification']) ? $costingDb['Product']['specification'] : '';
$data[] = $row;
//row 7
$data[] = array();
//row 8
$row = array();
$row[0] = 'Model:';
$row[1] = '';
$row[2] = isset($costingDb['Product']['item_no']) ? $costingDb['Product']['item_no'] : '';
$row[3] = '';
$row[4] = '';
$row[5] = 'Person-In-charged:';
$row[6] = '';
$row[7] = isset($costingDb['User']['display_name']) ? $costingDb['User']['display_name'] : '';
$data[] = $row;
//row 9
$row = array();
$row[0] = $strLine;
$data[] = $row;
//row 10
$row = array();
$row[0] = 'Length =';
$row[1] = $costingDb['Costing']['spec_length'];
$row[2] = 'cm';
$row[3] = 'With =';
$row[4] = $costingDb['Costing']['spec_width'];
$row[5] = 'cm';
$row[6] = '';
$row[7] = 'Quantity:';
$row[8] = $quantity;
$data[] = $row;
//row 11
$row = array();
$row[0] = $strLine;
$data[] = $row;
//row 12
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = 'Length(cm)';
$row[7] = 'Width(cm)';
$row[8] = 'COST(Vnd)';
$data[] = $row;
//row 13
$row = array();
$row[0] = 'Paper:';
$row[1] = 'Substance:';
$row[2] = $costingDb['Costing']['paper_substance'];
$row[3] = 'Gsm';
$row[4] = '';
$row[5] = 'Size: ';
$row[6] = $costingDb['Costing']['paper_length'];
$row[7] = $costingDb['Costing']['paper_width'];
$data[] = $row;
//row 14
$row = array();
$row[0] = '';
$row[1] = 'Price/Ram:';
$row[2] = $costingDb['Costing']['paper_price_ram'];
$row[3] = 'Vnd';
$row[4] = '';
$row[5] = 'Cost/Sht:';
$costShtRam = $costingDb['Costing']['paper_price_ram'] / 500;
$row[6] = $costShtRam;
$row[7] = 'Vnd';
$data[] = $row;
//row 15
$row = array();
$row[0] = '';
$row[1] = 'Price/Ton:';
$row[2] = $costingDb['Costing']['paper_price_ton'];
$row[3] = 'Vnd';
$row[4] = '';
$row[5] = 'Cost/Sht: ';
$costShtTon = $costingDb['Costing']['paper_length'] * $costingDb['Costing']['paper_width'] / 10000 * $costingDb['Costing']['paper_substance'] / 1000000 * $costingDb['Costing']['paper_price_ton'];
$row[6] = $costShtTon;
$row[7] = 'Vnd';
$row[8] = '';
$row[9] = 'Paper';
$data[] = $row;
$sumForPrnWastage = 0;
//row 16
$row = array();
$row[0] = '';
$row[1] = 'Cutting:';
$row[2] = $costingDb['Costing']['paper_cutting'];
$row[3] = 'Outs';
$row[4] = '';
$row[5] = 'Cost/PC: ';
$costPC = $costShtRam / $costingDb['Costing']['paper_cutting'] + $costShtTon / $costingDb['Costing']['paper_cutting'];
$sumPaper = $costPC;
$row[6] = $costPC;
$row[7] = 'Vnd';
$row[8] = $costPC;
$row[9] = $sumPaper;
$data[] = $row;
$sumForPrnWastage += $costPC;
//row 17
$row = array();
$row[0] = 'Printing:';
$row[1] = 'P. Area/PC:';
$printingAreaPC = $costingDb['Costing']['paper_length'] * $costingDb['Costing']['paper_width'] / 10000 / $costingDb['Costing']['paper_cutting'];
$row[2] = $printingAreaPC;
$row[3] = 'm2';
$row[4] = '';
$row[5] = 'Coverage:';
$row[6] = $costingDb['Costing']['printing_coverage'];
$row[7] = '%';
$data[] = $row;
//row 18
$row = array();
$row[0] = '';
$row[1] = 'Ink Price:';
$row[2] = $settings['printing_ink_price'];
$row[3] = 'Vnd/m2';
$row[4] = '';
$row[5] = 'Ink Cost / pc:';
$inkCostPc = round($printingAreaPC * $settings['printing_ink_price'] * $costingDb['Costing']['printing_coverage'] / 100 * $costingDb['Costing']['printing_cost']);
$row[6] = $inkCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $inkCostPc;
$data[] = $row;
$sumForPrnWastage += $inkCostPc;
//row 19
$row = array();
$row[0] = 'Ink loss/Prn / Color:';
$row[1] = '';
$row[2] = $settings['ink_loss_prn_color'];
$row[3] = 'Gm/Color';
$row[4] = 'Ink loss Cost / pc: ';
$row[5] = '';
$inkLostCostPc = round($costingDb['Costing']['printing_color'] * $settings['ink_loss_prn_color'] / 1000 * 100000 / $quantity * $costingDb['Costing']['printing_cost']);
$row[6] = $inkLostCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $inkLostCostPc;
$data[] = $row;
$sumForPrnWastage += $inkLostCostPc;
//row 20
$row = array();
$row[0] = '';
$row[1] = 'Trial Prn:';
$row[2] = $settings['trial_prn'];
$row[3] = 'Sht/Color';
$row[4] = 'Trial Cost/pc:';
$row[5] = '';
$trialCostPc = round($costingDb['Costing']['paper_cutting'] * $costPC * $settings['trial_prn'] * $costingDb['Costing']['printing_color'] / $quantity * $costingDb['Costing']['printing_cost']);
$row[6] = $trialCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $trialCostPc;
$data[] = $row;
$sumForPrnWastage += $trialCostPc;
//row 21
$row = array();
$row[0] = '';
$row[1] = 'No of Color:';
$row[2] = $costingDb['Costing']['printing_color'];
$row[3] = 'Colors';
$row[4] = ' No. of Passes:';
$row[5] = '';
$row[6] = $costingDb['Costing']['printing_cost'];
$row[7] = 'passes';
$data[] = $row;
//row 22
$row = array();
$row[0] = 'Printing Cost:';
$row[1] = '';
$row[2] = $settings['printing_cost'];
$row[3] = 'Vnd/Pass';
$row[4] = 'Prn. Cost/pc:';
$row[5] = '';
$prnCostPc = $settings['printing_cost'] / $costingDb['Costing']['paper_cutting'] * $costingDb['Costing']['printing_cost'];
$row[6] = $prnCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $prnCostPc;
$data[] = $row;
$sumForPrnWastage += $prnCostPc;
//row 23
$row = array();
$row[0] = '';
$row[1] = 'Time Cost:';
$row[2] = $settings['time_cost'];
$row[3] = 'Vnd/Min';
$data[] = $row;
//row 24
$row = array();
$row[0] = '';
$row[1] = 'Time Waste:';
$row[2] = $settings['time_waste'];
$row[3] = 'Min/Color';
$row[4] = 'Time Waste Cost/pc:';
$row[5] = '';
$timeWasteCostPc = round($costingDb['Costing']['printing_color'] * $settings['time_cost'] * $settings['time_waste'] / $quantity * $costingDb['Costing']['printing_cost']);
$row[6] = $timeWasteCostPc;
$row[7] = 'Vnd';
$row[8] = $timeWasteCostPc;
$data[] = $row;
$sumForPrnWastage += $timeWasteCostPc;
//row 25
$row = array();
$row[0] = '';
$row[1] = 'Prn Plate :';
$row[2] = $settings['prn_plate'];
$row[3] = 'Vnd/Color';
$row[4] = 'Plate Cost /pc:';
$row[5] = '';
$lateCostPc = round($costingDb['Costing']['printing_color'] * $settings['prn_plate'] / $quantity * $costingDb['Costing']['printing_cost']);
$row[6] = $lateCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $lateCostPc;
$data[] = $row;
$sumForPrnWastage += $lateCostPc;
//row 26
$row = array();
$row[0] = $costingDb['Costing']['printing_films'];
$row[1] = 'Film Cost :';
$row[2] = $settings['film_cost'];
$row[3] = 'Vnd/m2';
$row[4] = 'Film Cost/pc:';
$row[5] = '';
$filmCostPc = round($printingAreaPC * $settings['film_cost'] * $costingDb['Costing']['printing_films'] * $costingDb['Costing']['paper_cutting'] * $costingDb['Costing']['printing_color'] / $quantity);
$row[6] = $filmCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $filmCostPc;
$data[] = $row;
$sumForPrnWastage += $filmCostPc;
//row 27
$row = array();
$row[0] = '';
$row[1] = 'Prn Wastg:';
$row[2] = $settings['prn_wastg'];
$row[3] = '%/Color';
$row[4] = 'Prn Wastage Cost/pc:';
$row[5] = '';
$prnWastageCostPc = round($sumForPrnWastage * $settings['prn_wastg'] / 100 * $costingDb['Costing']['printing_color'] * $costingDb['Costing']['printing_cost']);
$row[6] = $prnWastageCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $prnWastageCostPc;
$row[9] = 'Printing';
$data[] = $row;
$sumPrinting = round($sumForPrnWastage - $costPC + $prnWastageCostPc);
//row 28
$row = array();
$row[0] = 'Printing Cost / pc / Color:';
$row[1] = '';
$row[2] = '';
$row[3] = round($sumPrinting / $costingDb['Costing']['printing_color']);
$row[4] = 'Vnd';
$row[5] = 'Printing Cost / pc:';
$row[6] = '';
$row[7] = $sumPrinting;
$row[8] = 'Vnd';
$row[9] = $sumPrinting;
$data[] = $row;
//row 29
$row = array();
$row[0] = 'Vanish:';
$data[] = $row;
//row 30
$row = array();
$row[0] = $costingDb['Costing']['vanish_oil'];
$row[1] = 'Oil:';
$row[2] = $settings['vanish_oil'];
$row[3] = 'Vnd / m2';
$row[4] = '';
$row[5] = 'Oil Cost/pc:';
$oilCostPc = round($printingAreaPC * $costingDb['Costing']['vanish_oil'] * $settings['vanish_oil']);
$row[6] = $oilCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $oilCostPc;
$data[] = $row;
//row 31
$row = array();
$row[0] = $costingDb['Costing']['vanish_uv'];
$row[1] = 'UV:';
$row[2] = $settings['vanish_uv'];
$row[3] = 'Vnd / m2';
$row[4] = '';
$row[5] = 'UV Cost/pc :';
$uvCostPc = round($costingDb['Costing']['paper_length'] * $costingDb['Costing']['paper_width'] / 10000 * $settings['vanish_uv'] / $costingDb['Costing']['paper_cutting'] * $costingDb['Costing']['vanish_uv']);
$row[6] = $uvCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $uvCostPc;
$data[] = $row;
//row 32
$row = array();
$row[0] = $costingDb['Costing']['vanish_opp'];
$row[1] = 'OPP:';
$row[2] = $settings['vanish_opp'];
$row[3] = 'Vnd / m2';
$row[4] = '';
$row[5] = 'OPP Cost/pc:';
$oppCostPc = round($costingDb['Costing']['paper_length'] * $costingDb['Costing']['paper_width'] / 10000 * $settings['vanish_opp'] / $costingDb['Costing']['paper_cutting'] * $costingDb['Costing']['vanish_opp']);
$row[6] = $oppCostPc;
$row[7] = 'Vnd/pc';
$row[8] = $oppCostPc;
$data[] = $row;
//row 33
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = '';
$row[7] = '';
$row[8] = '';
$row[9] = 'Coating';
$data[] = $row;
//row 34
$sumVanish = $oilCostPc + $uvCostPc + $oppCostPc;
$row = array();
$row[0] = '2 - Ply:';
$row[1] = $costingDb['Costing']['ply'];
$row[2] = 'pass';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = '';
$row[7] = '';
$row[8] = '';
$row[9] = $sumVanish;
$data[] = $row;
//row 35
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = 'subtance';
$row[3] = 'Price';
$row[4] = 'Area';
$row[5] = '';
$row[6] = 'Paper Usage';
$row[7] = 'Unit Price / gm';
$data[] = $row;
//row 36
$row = array();
$row[0] = '';
$row[1] = 'Inner Surface:';
$row[2] = $costingDb['Costing']['inner_surf_substance'];
$row[3] = $costingDb['Costing']['inner_surf_price'];
$row[4] = $printingAreaPC;
$row[5] = 'M2';
$row[6] = $printingAreaPC * $costingDb['Costing']['inner_surf_substance'] / 1000 * $quantity;
$innerSurfaceUnitPrice = $costingDb['Costing']['inner_surf_price'] / 1000000;
$row[7] = $innerSurfaceUnitPrice;
$innerSurface = $printingAreaPC * $costingDb['Costing']['inner_surf_substance'] * $innerSurfaceUnitPrice * $costingDb['Costing']['exchange'] * $costingDb['Costing']['ply'];
$row[8] = $innerSurface;
$data[] = $row;
//row 37
$row = array();
$row[0] = '';
$row[1] = 'B - Flute:';
$row[2] = $costingDb['Costing']['b_flute_substance'];
$row[3] = $costingDb['Costing']['b_flute_price'];
$bFluteArea = $printingAreaPC * 1.45;
$row[4] = round($bFluteArea, 3);
$row[5] = 'M2';
$row[6] = round($bFluteArea * $costingDb['Costing']['b_flute_substance'] / 1000 * $quantity, 2);
$bFluteUnitPrice = $costingDb['Costing']['b_flute_price'] / 1000000;
$row[7] = $bFluteUnitPrice;
$bFlute = $bFluteArea * $costingDb['Costing']['b_flute_substance'] * $bFluteUnitPrice * $costingDb['Costing']['exchange'] * $costingDb['Costing']['ply'];
$row[8] = $bFlute;
$data[] = $row;
//row 38
$row = array();
$row[0] = '';
$row[1] = 'E - Flute:';
$row[2] = $costingDb['Costing']['e_flute_substance'];
$row[3] = $costingDb['Costing']['e_flute_price'];
$eFluteArea = $printingAreaPC * 1.38;
$row[4] = round($eFluteArea, 3);
$row[5] = 'M2';
$row[6] = round($eFluteArea * $costingDb['Costing']['e_flute_substance'] / 1000 * $quantity);
$eFluteUnitPrice = $costingDb['Costing']['e_flute_price'] / 1000000;
$row[7] = $eFluteUnitPrice;
$eFlute = $eFluteArea * $costingDb['Costing']['e_flute_substance'] * $eFluteUnitPrice * $costingDb['Costing']['exchange'] * $costingDb['Costing']['ply'];
$row[8] = $eFlute;
$data[] = $row;
//row 39
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = 'Wastage:';
$wastage = round($costingDb['Costing']['paper_width'] / 100 * 30 / $costingDb['Costing']['paper_cutting']);
$row[6] = $wastage;
$row[7] = 'm2';
$col8Data = ($innerSurface + $bFlute + $eFlute) / $printingAreaPC * $wastage / $quantity * $costingDb['Costing']['ply'];
$row[8] = $col8Data;
$data[] = $row;
//row 40
$manufacturingCost = 0.08 * $costingDb['Costing']['exchange'] * $printingAreaPC * $costingDb['Costing']['ply'];
$sumFly = $innerSurface + $bFlute + $eFlute + $col8Data + $manufacturingCost;
$row = array();
$row[0] = '';
$row[1] = 'Total Cost:';
$row[2] = $sumFly;
$row[3] = $sumFly / $printingAreaPC;
$row[4] = 'Vnd/m2';
$row[5] = '';
$row[6] = '';
$row[7] = 'Manufacturing Cost:';
$row[8] = $manufacturingCost;
$row[9] = '2 Ply';
$data[] = $row;
//row 41
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = '';
$row[7] = '';
$row[8] = '';
$row[9] = $sumFly;
$data[] = $row;
//row 42
$row = array();
$row[0] = 'Limination:';
$row[1] = '';
$row[2] = $costingDb['Costing']['limination'];
$row[3] = 'pass';
$row[4] = '';
$row[5] = '';
$row[6] = $settings['limination'];
$row[7] = 'Vnd/m2';
$limination1 = round($printingAreaPC * $settings['limination'] * $costingDb['Costing']['limination']);
$row[8] = $limination1;
$row[9] = 'Laminate';
$data[] = $row;
//row 43
$limination = round(($sumPaper + $sumPrinting + $sumVanish + $sumFly) * $settings['limination _wastage'] / 100 * $costingDb['Costing']['limination']);
$sumLimination = $limination + $limination1;
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = 'Wastage:';
$row[6] = $settings['limination _wastage'];
$row[7] = '%';
$row[8] = $limination;
$row[9] = $sumLimination;
$data[] = $row;
//row 44
$row = array();
$row[0] = 'Die-Cut:';
$row[1] = $costingDb['Costing']['die_cut'];
$row[2] = 'pass';
$data[] = $row;
//row 45
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = $settings['die_cut'];
$row[3] = '/m2';
$row[4] = 'Mould Cost /pc:';
$row[5] = '';
$dieCut1 = round($costingDb['Costing']['paper_length'] * $costingDb['Costing']['paper_width'] / 10000 * $settings['die_cut'] / $costingDb['Costing']['paper_cutting'] / $quantity * $costingDb['Costing']['die_cut'] * $costingDb['Costing']['paper_cutting']);
$row[6] = $dieCut1;
$row[7] = 'Vnd/pc';
$row[8] = $dieCut1;
$data[] = $row;
//row 46
$row = array();
$row[0] = '';
$row[1] = 'Labour:';
$row[2] = $settings['die_cut_labour'];
$row[3] = 'Vnd/pass';
$row[4] = '';
$row[5] = 'Labour Cost /pc :';
$dieCut2 = round($settings['die_cut_labour'] / $costingDb['Costing']['paper_cutting'] * $costingDb['Costing']['die_cut']);
$row[6] = $dieCut2;
$row[7] = 'Vnd/pc';
$row[8] = $dieCut2;
$row[9] = 'Die cut';
$data[] = $row;
//row 47
$row = array();
$row[0] = '';
$row[1] = 'Wastage:';
$row[2] = $settings['die_cut_wastage'];
$row[3] = '%';
$row[4] = '';
$row[5] = 'Wastage:';
$dieCutWastage = round(($sumPaper + $sumPrinting + $sumVanish + $sumFly + $limination1) * $settings['die_cut_wastage'] / 100 * $costingDb['Costing']['die_cut']);
$row[6] = $dieCutWastage;
$row[7] = 'Vnd/pc';
$row[8] = $dieCutWastage;
$sumDieCut = $dieCut1 + $dieCut2 + $dieCutWastage;
$row[9] = $sumDieCut;
$data[] = $row;
//row 48
$row = array();
$row[0] = 'Gluing:';
$row[1] = $settings['gluing_1'];
$row[2] = 'Vnd/pc';
$row[3] = '';
$row[4] = $costingDb['Costing']['gluing_1'];
$row[5] = 'pass';
$gluing1 = $settings['gluing_1'] * $costingDb['Costing']['gluing_1'];
$row[6] = $gluing1;
$row[7] = 'Vnd/pc';
$row[8] = $gluing1;
$data[] = $row;
//row 49
$row = array();
$row[0] = '';
$row[1] = $settings['gluing_2'];
$row[2] = 'Vnd/pc';
$row[3] = '';
$row[4] = $costingDb['Costing']['gluing_2'];
$row[5] = 'pass';
$gluing2 = $settings['gluing_2'] * $costingDb['Costing']['gluing_2'];
$row[6] = $gluing2;
$row[7] = 'Vnd/pc';
$row[8] = $gluing2;
$data[] = $row;
//row 50
$row = array();
$row[0] = '';
$row[1] = $settings['gluing_3'];
$row[2] = 'Vnd/pc';
$row[3] = '';
$row[4] = $costingDb['Costing']['gluing_3'];
$row[5] = 'pass';
$gluing3 = $settings['gluing_3'] * $costingDb['Costing']['gluing_3'];
$row[6] = $gluing3;
$row[7] = 'Vnd/pc';
$row[8] = $gluing3;
$row[9] = 'Glue';
$data[] = $row;
//row 51
$sumGluing = $gluing1 + $gluing2 + $gluing3;
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = '';
$row[7] = '';
$row[8] = '------------';
$row[9] = $sumGluing;
$data[] = $row;
//row 52
$sumAll = round($sumPaper + $sumPrinting + $sumVanish + $sumFly + $sumLimination + $sumDieCut + $sumGluing);
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = '';
$row[7] = '';
$row[8] = $sumAll;
$data[] = $row;
//row 53
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = 'Transportation:';
$row[5] = '';
$row[6] = $costingDb['Costing']['transportation'];
$row[7] = '%';
$transportation = round($sumAll * $costingDb['Costing']['transportation'] / 100);
$row[8] = $transportation;
$row[9] = $transportation;
$data[] = $row;
//row 54
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = 'Packaging:';
$row[5] = '';
$row[6] = $costingDb['Costing']['packaging'];
$row[7] = '%';
$packaging = round($sumAll * $costingDb['Costing']['packaging'] / 100);
$row[8] = $packaging;
$row[9] = $packaging;
$data[] = $row;
//row 55
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = 'Sales Tax:';
$row[5] = '';
$row[6] = $settings['sales_tax'];
$row[7] = '%';
$saleTax = round(($sumAll + $transportation) * $settings['sales_tax'] / 100);
$row[8] = $saleTax;
$row[9] = $saleTax;
$data[] = $row;
//row 56
$row = array();
$row[0] = '';
$row[1] = '';
$data[] = $row;
$sum1 = round($sumAll + $transportation + $packaging + $saleTax);
$mk = round($sum1 * $costingDb['Costing']['mk'] / 100);
$sellingPrice = round($sum1 + $mk);
$grossMU = round(($prnCostPc + $timeWasteCostPc + $manufacturingCost + $dieCut2) / $sellingPrice * 100 + $costingDb['Costing']['mk']);
//row 57
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = 'GROSS MU';
$row[3] = $grossMU;
$row[4] = '';
$row[5] = 'MK:';
$row[6] = $costingDb['Costing']['mk'];
$row[7] = '%';
$row[8] = $mk;
$row[9] = $mk;
$data[] = $row;
//row 58
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = '';
$row[7] = '';
$row[8] = '---------------';
$data[] = $row;
//row 59
$row = array();
$row[0] = '';
$row[1] = '';
$row[2] = '';
$row[3] = '';
$row[4] = '';
$row[5] = '';
$row[6] = 'Selling Price(Vnd):';
$row[7] = '';
$row[8] = $sellingPrice;
$row[9] = $sellingPrice;
$data[] = $row;
//row 60
$row = array();
$row[0] = $strLine;
$data[] = $row;
$row = array();
$data[] = $row;
$ret['excelData'] = $data;
$ret['sellingPrice'] = $sellingPrice;
return $ret;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Settings::find($id)->delete();
return Redirect::to('settings')->with('success', 'Record deleted successfully');
}
