addDataParam('i', $ringtone_order_id);
$result = $wrapperObj->executeQuery($check_ringtone_order_id, $dataParams);
if ($result === false) {
showierror($check_ringtone_order_id);
}
if (!count($result)) {
$msg = 'jb110122';
$url = "ringtone_order_delete.php?err_msg=$msg";
header("Location: $url");
exit();
}
$sql = 'DELETE FROM ringtone_order where ringtone_order_id = ?';
$dataParams = new QueryData();
$dataParams->addDataParam('i', $ringtone_order_id);
$result = $wrapperObj->executeQuery($sql, $dataParams, MysqliWrapper::RETURN_AFFECTED_ROWS);
if ($result === false) {
showierror($sql);
}
$sql = 'DELETE FROM ringtone_order_detail where ringtone_order_id = ?';
$dataParams = new QueryData();
$dataParams->addDataParam('i', $ringtone_order_id);
$result = $wrapperObj->executeQuery($sql, $dataParams, MysqliWrapper::RETURN_AFFECTED_ROWS);
if ($result === false) {
showierror($sql);
}
$msg = 'jb110123';
$url = "ringtone_order_delete.php?confirm_msg=$msg";
header("Location: $url");
exit();
}
}
if (empty($ringtone_order_id) || !is_numeric($ringtone_order_id)) { ?>
addDataParam('i', $ringtone_order_id);
$result = $wrapperObj->executeQuery($check_ringtone_order_id, $dataParams);
if ($result === false) {
showierror($check_ringtone_order_id);
}
if (!count($result)) {
$msg = 'jb110122';
$url = "ringtone_order_delete.php?err_msg=$msg";
header("Location: $url");
exit();
}
$ringtone_order_query = 'SELECT ro.ringtone_order_id, ou.f_name, ou.l_name, ro.status, en.encoder, ro.date as entry_date, rod.date_delivered, count(distinct rod.ringtone_order_detail_id) AS total_product, count(distinct ro.dms_list) AS total_dms
FROM ringtone_order ro
LEFT JOIN ringtone_order_detail rod on rod.ringtone_order_id = ro.ringtone_order_id
LEFT JOIN orchadmin_users ou on ou.id = ro.orchadmin_user_id
LEFT JOIN encoder en on en.encoder_id = ro.encoder_id
WHERE ro.ringtone_order_id = ?
GROUP BY ro.ringtone_order_id
';
$dataParams = new QueryData();
$dataParams->addDataParam('i', $ringtone_order_id);
$ringtone_order_result = $wrapperObj->executeQuery($ringtone_order_query, $dataParams);
if ($ringtone_order_result === false) {
showierror($check_ringtone_order_id);
}
$ringtone_order_row = $ringtone_order_result[0];
?>