public static function Create($User__Id, $Files_Names)
{
// $MySQL = ccPDO::___GET("lbmgmt", false);
$MySQL = ccPDO::___GET("lbxxdb50", false);
try {
$MySQL->beginTransaction();
$FakeParam = $MySQL->prepare("SET @outTicket__Id = -1");
$FakeParam->execute();
$SP = $MySQL->prepare("CALL CREATE___Ticket(:User_Id, :File_Name, @outTicket__Id, :inPrint)");
$SP->bindValue(':User_Id', $User__Id, PDO::PARAM_INT);
$SP->bindValue(':File_Name', $Files_Names[0], PDO::PARAM_STR);
$SP->bindValue(':inPrint', 1, PDO::PARAM_BOOL);
$SP->execute();
$Result = $SP->fetchAll(PDO::FETCH_ASSOC);
$SP->closeCursor();
$Ticket__Id = $Result[0][Ticket__Id];
$Query = ccTicket::GET_Query___INSERT__Pictures($Ticket__Id, $Files_Names);
$MySQL->exec($Query);
$MySQL->commit();
ccTicket::MOVE__Ticket_Files($Files_Names, "Temp", "WIP");
$bSuccess = true;
} catch (Exception $e) {
$MySQL->rollBack();
$bSuccess = false;
throw $e;
}
return $bSuccess;
}
<?php require_once "../Models/General.php"; require "../Views/Logged.php"; require_once "../Models/PDO.php"; require_once "../Models/LB_DB.php"; require_once "../Models/DB.php"; $Inputs = filter_input_array(INPUT_GET); $Files_Names = $Inputs['Inputs']; $User__Id = $_SESSION['Id']; $bSuccess = ccTicket::Create($User__Id, $Files_Names); echo json_encode(array($bSuccess));
public static function CREATE_NEW__Ticket($Inputs)
{
$Queries = array();
$Queries['Ticket'] = ccTicket::GET__Query__Finalize($Inputs);
if (array_key_exists('Ticket_Discount', $Inputs) === true) {
$Queries['Ticket_Discount'] = ccLB_Proc::GET__Query__Finalize($Inputs, "Ticket_Discount");
}
if (array_key_exists('Ticket_Loyalty', $Inputs) === true) {
$Queries['Ticket_Loyalty'] = ccLB_Proc::GET__Query__Finalize($Inputs, "Ticket_Loyalty");
}
$Queries['Ticket_Product'] = ccLB_Proc::GET__Query__Finalize($Inputs, "Ticket_Product");
if (array_key_exists('Ticket_Product_Discount', $Inputs) === true) {
$Queries['Ticket_Product_Discount'] = ccLB_Proc::GET__Query__Finalize($Inputs, "Ticket_Product_Discount");
}
$Queries['Ticket_Info'] = ccTicket_Info::GET__Query__Finalize($Inputs);
global $PDO;
$Query = null;
try {
$PDO->setAttribute(PDO::ATTR_AUTOCOMMIT, 0);
$PDO->beginTransaction();
foreach ($Queries as $Query) {
$PDO->exec($Query);
}
$File__Names = array($Inputs['Ticket_Info']['File_Pic']);
// ccTicket_Info::MOVE__Ticket_Files($Inputs['Ticket_Info'][File_Name], "WIP", "Ready");
if ($Inputs['DB_Host'] === "localhost") {
$bSuccess = ccLB_Proc__Ticket::MOVE__Files($File__Names, "WIP", "Ready");
} else {
$bSuccess = ccLB_Proc__Ticket::MOVE__Files__FTP($File__Names, "WIP", "Ready");
}
if ($bSuccess === false) {
$PDO->rollBack();
throw new Exception();
}
// $bSuccess = ccDB::RUN__Query__INSERT($Queries, $PDO);
$PDO->commit();
} catch (Exception $e) {
$PDO->rollBack();
echo "ERROR: An error occured while executing, please review.\r\n";
echo $Query . "\r\n";
ccGeneral::EXCEPTION___Process($e, debug_backtrace());
}
return $bSuccess;
}
