$insert_record = mysql_query($query_insert_to_site_store, $birus_conn) or die(mysql_error()); echo mysql_affected_rows($birus_conn); if (mysql_affected_rows($birus_conn) > 0 && count($row_get_last_record_per_item) > 1) { //Update The previous record with same Item. $query_update_next_id = "UPDATE birus.site_store SET next_id = '3' WHERE site_store.id ='" . $row_get_last_record_per_item['id'] . "'"; mysql_query($query_update_next_id, $birus_conn); if (mysql_affected_rows($birus_conn) > 0) { redirect_birus("", ""); } } } } else { alert_redirect_birus("site_item_issue_approve_view", "6", "Your Issue out Qty is greater than Qty in Store."); } } else { alert_redirect_birus("site_item_issue_approve_view", "2", "Already marked Received"); } } ?> <form action="<?php echo $editFormAction; ?> " method="post" name="site_to_site_req_item_form" id="site_to_site_req_item_form"> <table align="left"> <tr valign="baseline"> <td nowrap="nowrap" align="left">Item:</td> <td><input type="hidden" name="item_id" value="<?php echo $row_site_to_site_req_item_by_id['item_id']; ?> " /><?php
$previous_id_place_holder = ""; } $balace = $row_get_last_record_per_item["balance"] + $_REQUEST['qty_recieved']; $query_insert_to_main_store = "INSERT INTO birus.main_store({$previous_id_place_holder} item_id , pr_item_id, balance, created_by, created_date, record_status)\r\nVALUES ({$previous_id}'" . $_REQUEST["item_id"] . "','" . $_REQUEST['pr_item_id'] . "','{$balace}','{$loggedin_id}','" . date("y-m-d") . "','" . $_REQUEST["record_status"] . "');"; $insert_record = mysql_query($query_insert_to_main_store, $birus_conn) or die(mysql_error()); if (mysql_affected_rows($birus_conn) > 0 && count($row_get_last_record_per_item) > 1) { //Update The previous record with same Item. $query_update_next_id = "UPDATE birus.main_store SET next_id = '' WHERE main_store.id ='" . $row_get_last_record_per_item['id'] . "'"; mysql_query($query_update_next_id, $birus_conn); if (mysql_affected_rows($birus_conn) > 0) { redirect_birus("pr_item_recieve_view= true&purchase_req_id=" . $_REQUEST['pr_id'] . "", "2"); } } } } else { alert_redirect_birus("pr_item_recieve_view= true&purchase_req_id=" . $_REQUEST['pr_id'] . "", "2", "Already marked Received"); } } ?> <form action="<?php echo $editFormAction; ?> " method="post" name="pr_item_form" id="pr_item_form"> <table align="left"> <tr valign="baseline"> <td nowrap="nowrap" align="left">Item:</td> <td><input type="hidden" name="item_id" value="<?php echo $row_pr_item_by_id['item_id']; ?> " /><?php echo $row_pr_item_by_id['item_name'];