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