executeQuery($delete_query, $dataParams, QueryWrapper::RETURN_AFFECTED_ROWS) === false) { show_pdo_error($delete_query, $pdoWrapperObj->getLastStatement()); } $msg = "Release exclusivity successfully removed."; header("location: release_exclusive_pop.php?upc=$upc&confirm_msg=$msg"); exit(); } } elseif ($a == 'dAll') { $delete_query = 'DELETE FROM release_exclusive WHERE upc = ?'; $dataParams = []; $dataParams[] = $upc; if ($pdoWrapperObj->executeQuery($delete_query, $dataParams, QueryWrapper::RETURN_AFFECTED_ROWS) === false) { show_pdo_error($delete_query, $pdoWrapperObj->getLastStatement()); } $msg = '32edty67'; header("location: release_exclusive_pop.php?upc=$upc&confirm_msg=$msg"); exit(); } elseif ($a == 'a') { $err_msg = ''; if (!count($dms_customer_id_req)) { $err_msg .= '
  • DMS is missing.
    • '; } if (!$sale_start_date_req) { $err_msg .= '
  • Sale Start Date is missing.
    • '; } elseif (!validateDate($sale_start_date_req)) { $err_msg .= '
  • Sale Start Date is invalid.
    • '; } if (!$err_msg) { foreach ($dms_customer_id_req as $value) { $check = 'SELECT re.id, cm.name FROM release_exclusive re inner join customer_master cm on re.dms_customer_id = cm.customer_id WHERE upc = ? and cm.customer_id = ?'; $dataParams = []; $dataParams[] = $upc; $dataParams[] = $value; $check_result = $pdoWrapperObj->executeQuery($check, $dataParams); if ($check_result === false) { show_pdo_error($check, $pdoWrapperObj->getLastStatement()); } if (count($check_result) == 0) { $insert_query = 'INSERT INTO release_exclusive (upc, dms_customer_id, sale_start_date) VALUES (?, ?, ?)'; $dataParams = []; $dataParams[] = $upc; $dataParams[] = $value; $dataParams[] = $sale_start_date_req; if ($pdoWrapperObj->executeQuery($insert_query, $dataParams, QueryWrapper::RETURN_INSERT_ID) === false) { show_pdo_error($insert_query, $pdoWrapperObj->getLastStatement()); } } else { $dms_name = $check_result[0]['name']; $msg = "Error: A release cannot have multiple exclusivity for the same territory. This release already has exclusive sale start date for $dms_name."; header("location: release_exclusive_pop.php?upc=$upc&err_msg=$msg"); exit(); } } $msg = "Release exclusivity successfully added."; header("location: release_exclusive_pop.php?upc=$upc&confirm_msg=$msg"); exit(); } else { header("location: 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.upc = ?'; $dataParams = []; $dataParams[] = $upc; $release_result = $pdoWrapperObj->executeQuery($release_query, $dataParams); if ($release_result === false) { show_pdo_error($release_query, $pdoWrapperObj->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 inner join customer_master cm ON re.dms_customer_id = cm.customer_id WHERE re.upc = ?'; $dataParams = []; $dataParams[] = $upc; $get_exclusive_result = $pdoWrapperObj->executeQuery($get_exclusive_query, $dataParams); if ($get_exclusive_result === false) { show_pdo_error($get_exclusive_query, $pdoWrapperObj->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