Exemplo n.º 1
0
                $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 
Exemplo n.º 2
0
                $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'];