?> </tbody> </table> </div> </div> </div> <?php } else { if (Input::get('item') && Input::get('tkn') == 'edit' && Input::get('inv') == md5('2')) { if (Input::get('edit') == md5("true")) { $validate = new Validate(); $validation = $validate->check($_POST, array('category' => array('name' => 'Category', 'required' => true), 'supplier' => array('name' => 'Supplier', 'required' => true), 'goods_id' => array('name' => 'Good ID', 'required' => true), 'goods_name' => array('name' => 'Good Name', 'required' => true), 'goods_qty' => array('name' => 'Quantity', 'required' => true), 'selling_price' => array('name' => 'Selling Price', 'required' => true), 'cost_price' => array('name' => 'Cost Price', 'required' => true))); if ($validation->passed()) { $img = new Image(); $update = new Inventory(); $update1 = $update->updateinv('tbl_goods', 'goods_id', Crytion::decryt64(Input::get('item')), array('goods_id' => Input::get('goods_id'), 'goods_name' => Input::get('goods_name'), 'goods_category' => Input::get('category'), 'image' => $img->getimage(), 'image_name' => $img->getimagename(), 'image_type' => $img->getimagetype())); $update2 = $update->updateinv('tbl_goods_stock', 'goods_id', Crytion::decryt64(Input::get('item')), array('goods_id' => Input::get('goods_id'), 'goods_qty' => Input::get('goods_qty'), 'goods_discount' => Input::get('goods_discount'), 'goods_price_per_unit' => Input::get('selling_price'), 'goods_cost_price_per_unit' => Input::get('cost_price'), 'supplier_id' => Input::get('supplier'), 'date_update' => date('Y-m-d H:i:s'), 'comment' => 'Stock details update')); $update3 = $update->updateinv('tbl_item_update_record', 'goods_id', Crytion::decryt64(Input::get('item')), array('goods_id' => Input::get('goods_id'))); if ($update1 && $update2 && $update3) { Session::put('form-success', 'Update Item Success!'); } else { Session::put('form-error', array('Error in updating item!')); } } else { Session::put('form-error', $validation->error()); } } $item = "Select * from tbl_goods a,tbl_goods_stock b where a.goods_id = b.goods_id \n AND a.goods_id = ?"; $itemquery = $con->prepare($item); $itemquery->execute(array(Crytion::decryt64(Input::get('item')))); $row = $itemquery->fetch(PDO::FETCH_OBJ);