Inventory update
$row[0],'name'=>$row[1])); } $inv=json_encode($all_inventory_name); if( isset($_SESSION["smiley_uid"]) && ( $_SESSION["smiley_role"]=="a" || $_SESSION["smiley_role"]=="u" || $_SESSION["smiley_role"]=="d" || $_SESSION['smiley_role']=='h' ) ) { $stmt1 = pg_query_params($conn, "SELECT sno,date_txn,inventory_name,quantity_as_of_now,suggestion,health.inventory_update.company_id,expiry_date FROM health.inventory_update,health.inventory where health.inventory_update.company_id= $1 and health.inventory_update.inventory_id=health.inventory.inventory_id order by date_txn desc",array($_SESSION["smiley_cid"])); if (!$stmt1) { echo "An query error occurred.\n"; echo pg_last_error($conn); exit; } while ($row1 = pg_fetch_row($stmt1)) { $sno=$row1[0]; $date_txn=$row1[1]; $inventory_name=$row1[2]; $quantity_as_of_now=$row1[3]; $suggestion=$row1[4]; $company_id=$row1[5]; $expiry_date=$row1[6]; array_push($inventory_data,array($sno,$inventory_name,$quantity_as_of_now,$suggestion,$date_txn)); } $inv_data=json_encode($inventory_data); //print_r($inventory_data); pg_free_result($stmt1); } else if(isset($_SESSION["smiley_uid"])){ echo ' '; } echo '
serialno
Inventory Name
Quantity
Suggestion
Expiry Date
'; foreach($inventory_data as $idata){ echo '
'.$idata[0].'
'.$idata[1].'
'.$idata[2].'
'.$idata[3].'
'.$idata[4].'
'; //$lastsno=$idata[0]; } echo '
'; echo '
×
Add Row
Inventory name
'; foreach($all_inventory_name as $all_i_name){ echo '
'.$all_i_name["name"].'
'; } echo '
Quantity
Suggestion
Expiry
'; pg_free_result($stmt); ?>
/*swal( { title: "Coming Soon...", type: "warning", background: "rgba(255,255,255,0.89)", allowOutsideClick: false, onOpen: function () { //do something } }).then(function () { window.location="index.html"; }); */ '; } pg_free_result($stmt1); } pg_close($conn); ?>