Проблема с этим участком кода(привожу этот участок от начала и до конца). Чего я хочу им добиться - выдать мне после того,как я отмечу нужные мне продукты, окно заказа. Однако выводит errorMessage со словами "Error at operation perfomance."
СУБД Оракл. Соответственно в базе все данные поля присутствуют.
Очень необходима ваша помощь. Ниже приведен данный код. Заранее спасибо
if (@PostContains(getRequestWindow)) {
if ((sizeOf($_SESSION["reProducts"])>0)) {
$c = sizeOf($_SESSION["reProducts"]);
if ($_SESSION["RequestDate"] && $_SESSION["ShipDate"]){
if ($_SESSION["reRequestDate"]!='' && $_SESSION["reShipDate"]!='') {
$check = dateCheck($_SESSION["reRequestDate"], $_SESSION["reShipDate"]);
switch ($check) {
case 0:
$html = getRequestWindow($conn," ","Wrong dates");
break;
case 1:
$Copies=array();
for ($i=0; $i<sizeOf($_SESSION["reProducts"]); $i++) {
$reProducts = $_SESSION["reProducts"];
$reRequestDate = $_SESSION["reRequestDate"];
$reShipDate = $_SESSION["reShipDate"];
if(OCIFetch($stmt)){
$copy = OCIResult($stmt, 'ID');
if ($copy!='') {
$Copies[] = $copy;
};
};
};
$userID = $_SESSION["userID"];
$reRequestDate = $_SESSION["reRequestDate"];
$reShipDate = $_SESSION["reShipDate"];
$sql="INSERT INTO request (person,RequestDate,ShipDate, allow)
VALUES ('$userID', sysDate,'$reShipDate', NULL)
RETURNING id INTO :retid";
$stmt = @OCIParse($conn,$sql);
OCIBindByName($stmt, ':retid', $retid, 32);
$mess = @OCIExecute($stmt);
if($mess) {
for ($i=0; $i<sizeof($Copies); $i++) {
$sql="INSERT INTO request_copy (request,copy) VALUES ('$retid','$Copies[$i]')";
$stmt = @OCIParse($conn,$sql);
$mess = @OCIExecute($stmt);
if (!$mess) {
@OCIRollback($conn);
errorMessage("Error at operation perfomance.");
}
}
}
else {
@OCIRollback($conn);
errorMessage("Error at operation perfomance.");
}
$html = getMainWindow($conn,"Your order is successfully added","");
$_SESSION["reRequestDate"] = "";
$_SESSION["reShipDate"] = "";
$_SESSION["reProducts"]=array();
break;
default:
$html = getRequestWindow($conn, "Repeat order","Wrong date");
}//Shipswitch
} else { $html = getRequestWindow($conn, "Repeat order", "No date");
}
} else { $html = getRequestWindow($conn, "Order", "Name dates on which the order is made out");
}
} else { $html = getMainWindow($conn,"Products for the order are not selected");
}
if (sizeof($Copies) > 0) {
$userID = $_SESSION["userID"];
$reRequestDate = $_SESSION["reRequestDate"];
$reShipDate = $_SESSION["reShipDate"];
$sql="INSERT INTO request (person, ShipDate,RequestDate,allow)
VALUES ('$userID','$reShipDate',sysDate,NULL)
RETURNING id INTO :retid";
$stmt = @OCIParse($conn,$sql);
OCIBindByName($stmt, ':retid', $retid, 32);
$mess = @OCIExecute($stmt);
if ($mess) {
for ($i=0; $i<sizeof($Copies); $i++) {
$sql="INSERT INTO request_copy (request,copy) VALUES ('$retid','$Copies[$i]')";
$stmt = @OCIParse($conn,$sql);
$mess = OCIExecute($stmt);
if (!$mess) {
@OCIRollback($conn);
errorMessage("Error at operation perfomance.");
};
};
} else {
@OCIRollback($conn);
errorMessage("Error at operation perfomance.");
}
$html = getMainWindow($conn,"Your order is successfully added");
} else {
$html = getMainWindow($conn," Your order has not been added!");
};
$_SESSION["reRequestDate"] = "";
$_SESSION["reShipDate"] = "";
$_SESSION["reProducts"]=array();
}
|