PHP SJB_ContractManager::deleteContractIDFromNotificationSended Exemples

Exemple #1

Fichier : ContractManager.php Projet : Maxlander/shixi

 public static function deletePendingContractByInvoiceID($invoiceID, $userSID, $productSID)
 {
     $contracts = SJB_DB::query("SELECT id FROM `contracts` WHERE `invoice_id` = ?s AND `user_sid` = ?s AND `product_sid` = ?n AND `status` = 'pending'", $invoiceID, $userSID, $productSID);
     foreach ($contracts as $contract) {
         SJB_ContractManager::deleteContractIDFromNotificationSended($contract['id']);
     }
     return SJB_DB::query("DELETE FROM `contracts` WHERE `invoice_id` = ?s AND `user_sid` = ?s AND `product_sid` = ?n AND `status` = 'pending'", $invoiceID, $userSID, $productSID);
 }