Mediatricks

Tested and confirmed fixed. Thank you.

I would still like to request that the error messages on Ajax Fail are made more Customer friendly.

“Not going to fall for it!” is not a message our clients should see in case of error.

🙂

Thank you. I have tested on my sandbox with a clean install of the latest version of the pro plugin, and NO other plugins active (using native 2024 WP theme)  and the error persists. 

Waiting on a fix.

Hi Chris,

In the Sales Table I have added the option to put the reservation on hold for those situations when a customer starts a booking but then has a problem, or asks to add seats before completing payment, or wants to pay offline/cash.

I have added code hack so if a Reserved Booking is manually Confirmed in the back end, the DB is updated with a Sale Reference and the Paid Amount.

1.
In include/stageshow_sales_table.php

Look for
const BULKACTION_COMPLETED = ‘completed’;

And add underneath:

—————
const BULKACTION_RESERVED = ‘reserved’;
—————
2. In include/stageshowlib_sales_dbase_api.php

Add these two functions above the function GetSaleFromTxnID()

—————
//Update PAID on SET COMPLETE from Admin
function UpdateSalePaid($saleid)
{

// Get the SaleId and return it ….
$sql = ‘SELECT saleID, SUM(ticketPaid) as invTotal FROM ‘.$this->DBTables->Orders;
$sql .= ‘ WHERE saleID=”‘.$saleid.'”‘;

$Totals = $this->get_results($sql);

$Paid= $Totals[0]->invTotal;
$txnid = substr(md5(microtime()),rand(0,26),16);

$sql = ‘UPDATE ‘.$this->DBTables->Sales;
$sql .= ‘ SET salePaid=”‘.$Paid.'”, saleTxnId=”‘.$txnid.'”, salePPExpToken=””‘;
$sql .= ‘ WHERE saleID=”‘.$saleid.'”‘;

$this->query($sql);

// Get the SaleId and return it ….
$sql = ‘SELECT saleID FROM ‘.$this->DBTables->Sales;
$sql .= ‘ WHERE saleTxnId=”‘.$txnid.'”‘;

$saleEntry = $this->get_results($sql);
if (count($saleEntry) == 0)
return 0;

return $saleEntry[0]->saleId;
}

// Update Set a Booking to RESERVED
function UpdateSaleReserved($saleId)
{

date_default_timezone_set(‘Asia/Kuwait’);
$date = new DateTime(‘NOW’);
$date->add(new DateInterval(‘P90D’));
$newcheckout=$date->format(‘Y-m-d H:i:s’);

$sql = ‘UPDATE ‘.$this->DBTables->Sales;
$sql .= ‘ SET saleCheckoutTime=”‘.$newcheckout.'”, saleStatus=”Reserved”‘;
$sql .= ‘ WHERE saleID=”‘.$saleid.'”‘;

$this->query($sql);

// Get the SaleId and return it ….
$sql = ‘SELECT saleID FROM ‘.$this->DBTables->Sales;
$sql .= ‘ WHERE saleID=”‘.$saleid.'”‘;

$saleEntry = $this->get_results($sql);
if (count($saleEntry) == 0)
return 0;

return $saleEntry[0]->saleId;
}
—————

3. In stageshowplus_sales_table.php

Look at about line 39 – 43 for the bulkAction for Set Complete and add this modified copy AFTER it (before the closing } of the function.
—————
if (!$editMode)
{
$this->bulkActions = array_merge($this->bulkActions, array(
self::BULKACTION_RESERVED => __(‘Hold Booking’, $this->myDomain),
));
}
—————

4. In stageshowplus_manage_sales.php

Look around Line 142 for Bulk Action for COMPLETED and add the following after the break; (Line 147?)
—————

case StageShowWPOrgSalesAdminListClass::BULKACTION_RESERVED:
if ($actionCount > 0)
$actionMsg = $actionCount . ‘ ‘ . _n(“Sale has been put on hold”, “Sales have been put on hold”, $actionCount, $this->myDomain);
else
$actionMsg = __(“Nothing to Update”, $this->myDomain);
break;

—————

5. In stageshow_manage_sales.php

Look for the DoBulkAction function at the bottom of the file and replace it with this:

—————

function DoBulkAction($bulkAction, $recordId)
{
switch ($bulkAction)
{
case StageShowWPOrgSalesAdminListClass::BULKACTION_COMPLETED:
$saleResults = $this->myDBaseObj->GetSale($recordId);
$saleEntry = $saleResults[0];

// Check record can be changed to COMPLETED
$prevSaleStatus = $saleEntry->saleStatus;

// Get the sale entry
if (!$this->CanChangeState($prevSaleStatus, PAYMENT_API_SALESTATUS_COMPLETED))
return false;

//HACK To Update Resered and Transaction Data
$this->myDBaseObj->UpdateSalePaid($recordId);
$this->myDBaseObj->UpdateSaleIDStatus($recordId, PAYMENT_API_SALESTATUS_COMPLETED);

if ($prevSaleStatus == PAYMENT_API_SALESTATUS_RESERVED || $prevSaleStatus == PAYMENT_API_SALESTATUS_CHECKOUT)
{
// Previously Unverified Sale is confirmed – Send EMail to Purchaser
$this->myDBaseObj->EMailSale($saleEntry->saleID);
}
return true;

case StageShowWPOrgSalesAdminListClass::BULKACTION_RESERVED:
$saleResults = $this->myDBaseObj->GetSale($recordId);
$saleEntry = $saleResults[0];

// Check record can be changed to COMPLETED
$prevSaleStatus = $saleEntry->saleStatus;

// Get the sale entry
//if (!$this->CanChangeState($prevSaleStatus, PAYMENT_API_SALESTATUS_COMPLETED))
// return false;

// //HACK Change saleStatus to RESERVED

$this->myDBaseObj->UpdateSaleIDStatus($recordId, PAYMENT_API_SALESTATUS_RESERVED);

if ($prevSaleStatus == PAYMENT_API_SALESTATUS_UNVERIFIED || $prevSaleStatus == PAYMENT_API_SALESTATUS_CHECKOUT)
{

// Previously Unverified OR CHECKOUT Sale is confirmed – Send EMail to Purchaser
$this->myDBaseObj->UpdateSaleReserved($recordId);
}
return true;
}

return parent::DoBulkAction($bulkAction, $recordId);
}

—————

(That will leave two } } before the closing php tag. )

That should do it (unless I missed a file) and you will be able to switch records between COMPLETED and ON HOLD (Reserved) in the back end sales table.