public static function main()
{
$event_id = Request::input('event_id');
$inventory_data = [];
for ($i = 1; $i <= count(Request::input('amt_all')); $i++) {
$amt_all = Request::input('amt_all');
$amt_oj = Request::input('amt_oj');
$amt_sup = Request::input('amt_sup');
$amt_cus = Request::input('amt_cus');
$amt_receive = Request::input('amt_receive');
$amt_return = Request::input('amt_return');
$inventory_data[$i] = ["amt_all" => $amt_all[$i], "amt_oj" => $amt_oj[$i], "amt_sup" => $amt_sup[$i], "amt_cus" => $amt_cus[$i], "amt_receive" => $amt_receive[$i], "amt_return" => $amt_return[$i]];
}
$count_inventory = inventory_amt::where('event_id', '=', $event_id)->count();
if ($count_inventory == 0) {
inventoryManage::New_role_DB($event_id);
inventoryManage::Update_DB($event_id, $inventory_data);
return redirect::to('assigment/' . $event_id)->with('status', "บันทึกสำเร็จ");
} else {
inventoryManage::Update_DB($event_id, $inventory_data);
return redirect::to('assigment/' . $event_id)->with('status', "บันทึกสำเร็จ");
}
}
public static function generate_page_2($event_id)
{
$data = inventoryManage::Get_DB($event_id);
$return_data = '<div class="container">
<div class="row">
<div class="col-md-12">
<h4 class="text-center">รายละเอียดอุปกรณ์</h4>
</div>
</div>
</div>
<table class="table table-bordered table-hover table-striped inventory">
<thead>
<tr>
<th class="text-center" style="width:3%">ลำดับ</th>
<th class="text-center">รายการ</th>
<th class="text-center">Amt</th>
<th class="text-center">OJ</th>
<th class="text-center">Sup</th>
<th class="text-center">Cus</th>
<th class="text-center">รับ</th>
<th class="text-center">คืน</th>
<th class="text-left">Remark/Note</th>
</tr>
</thead>
<tbody>';
if (count($data['inventory_amt']) == 0) {
for ($i = 1; $i <= count($data['inventory_name']); $i++) {
$return_data .= '<tr>
<td class="text-center">' . $i . '</td>
<td>' . $data['inventory_name'][$i]['name'] . '</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td>' . $data['inventory_name'][$i]['remark'] . '</td>
</tr>';
}
} else {
for ($i = 1; $i <= count($data['inventory_name']); $i++) {
$return_data .= '<tr>
<td class="text-center">' . $i . '</td>
<td>' . $data['inventory_name'][$i]['name'] . '</td>
<td class="text-center">' . ($data['inventory_amt'][$i]['amt_all'] == 0 ? "" : $data['inventory_amt'][$i]['amt_all']) . '</td>
<td class="text-center">' . ($data['inventory_amt'][$i]['amt_oj'] == 0 ? "" : $data['inventory_amt'][$i]['amt_oj']) . '</td>
<td class="text-center">' . ($data['inventory_amt'][$i]['amt_sup'] == 0 ? "" : $data['inventory_amt'][$i]['amt_sup']) . '</td>
<td class="text-center">' . ($data['inventory_amt'][$i]['amt_cus'] == 0 ? "" : $data['inventory_amt'][$i]['amt_cus']) . '</td>
<td class="text-center">' . ($data['inventory_amt'][$i]['amt_receive'] == 0 ? "" : $data['inventory_amt'][$i]['amt_receive']) . '</td>
<td class="text-center">' . ($data['inventory_amt'][$i]['amt_return'] == 0 ? "" : $data['inventory_amt'][$i]['amt_return']) . '</td>
<td>' . $data['inventory_name'][$i]['remark'] . '</td>
</tr>';
}
}
$return_data .= '</tbody></table>';
echo $return_data;
}
public static function main($event_id)
{
inventory::generate_html(inventoryManage::Get_DB($event_id));
}
