executeQuery($delete_query, $dataParams, QueryWrapper::RETURN_AFFECTED_ROWS) === false) { show_pdo_error($delete_query, $wrapperObj->getLastStatement()); } $msg = '32ed656c'; header("location: ex_release_exclusive_pop.php?release_id=$release_id&confirm_msg=$msg"); exit(); } } elseif ($a == 'dAll') { $deleteQuery = 'DELETE FROM release_exclusive WHERE release_id = ?'; $dataParams = []; $dataParams[] = $release_id; if ($wrapperObj->executeQuery($deleteQuery, $dataParams, QueryWrapper::RETURN_AFFECTED_ROWS) === false) { show_pdo_error($deleteQuery, $wrapperObj->getLastStatement()); } $msg = '32edty67'; header("location: ex_release_exclusive_pop.php?release_id=$release_id&confirm_msg=$msg"); exit(); } elseif ($a == 'a') { $err_msg = ''; if (!count($dms_customer_id_req)) { $err_msg .= '&err_msg[]=ed79f9b1'; } if (!$sale_start_date_req) { $err_msg .= '&err_msg[]=04661fdb'; } elseif (!validateDate($sale_start_date_req)) { $err_msg .= '&err_msg[]=16dacf8a'; } if (!$err_msg) { foreach($dms_customer_id_req as $value){ $check = 'SELECT r.id, cm.name FROM release_exclusive r INNER JOIN customer_master cm ON r.dms_customer_id = cm.customer_id WHERE release_id = ? AND cm.customer_id = ?'; $dataParams = []; $dataParams[] = $release_id; $dataParams[] = $value; $check_result = $wrapperObj->executeQuery($check, $dataParams); if ($check_result === false) { show_pdo_error($check, $wrapperObj->getLastStatement()); } if(count($check_result) == 0) { $insert_query = 'INSERT INTO release_exclusive (release_id, upc, dms_customer_id, sale_start_date) SELECT release_id, upc, ?, ? FROM releases WHERE release_id = ?'; $dataParams = []; $dataParams[] = $value; $dataParams[] = $sale_start_date_req; $dataParams[] = $release_id; if ($wrapperObj->executeQuery($insert_query, $dataParams, QueryWrapper::RETURN_INSERT_ID) === false) { show_pdo_error($insert_query, $wrapperObj->getLastStatement()); } } else { $dms_row = $check_result[0]; $dms_name = $dms_row['name']; $encrypt = WebMessage::getParamHandler('Encrypt'); $msg_dms_name = $encrypt->process($dms_name); $msg = '1e1f0793&msg_dms_name=' . $msg_dms_name; header("location: ex_release_exclusive_pop.php?release_id=$release_id&err_msg=$msg"); exit(); } } $msg = '8883e131'; header("location: ex_release_exclusive_pop.php?release_id=$release_id&confirm_msg=$msg"); exit(); } else { header("location: ex_release_exclusive_pop.php?$url&err_msg=$err_msg"); exit(); } } #get release info. $release_query = 'SELECT r.release_name, r.sale_start_date FROM releases r WHERE r.release_id = ?'; $dataParams = []; $dataParams[] = $release_id; $release_result = $wrapperObj->executeQuery($release_query, $dataParams); if ($release_result === false) { show_pdo_error($release_query, $wrapperObj->getLastStatement()); } $release_row = $release_result[0]; #get all previously entered artist. $get_exclusive_query = 'SELECT re.id, re.dms_customer_id, re.sale_start_date, cm.name FROM release_exclusive re, customer_master cm WHERE re.dms_customer_id = cm.customer_id AND re.release_id = ?'; $dataParams = []; $dataParams[] = $release_id; $get_exclusive_result = $wrapperObj->executeQuery($get_exclusive_query, $dataParams); if ($get_exclusive_result === false) { show_pdo_error($get_exclusive_query, $wrapperObj->getLastStatement()); } ?>

Manage Release Exclusivity

Release:
Start Date for Release:
0) { ?>

Current Exclusivities

DMS Sale Start Date Remove All
">Remove

Add Release Exclusivity

Here you can add exclusivity for release. You can only enter one entry for each dms.
DMS:
Sale Start Date: Calendar