executeQuery($pCMI_query, [$customer_master_master_id]);
if ($pCMI_result === false) {
show_pdo_error($pCMI_query, $wrapperObj->getLastStatement());
}
$pCMI_row = $pCMI_result[0];
//search for the distribution type
$distribution_type_id = array();
$distribution_type_name = array();
$distribution_features_ids = array();
$sqlGetDistType = 'SELECT cmd.distribution_type_id, dt.name, cmd.distribution_features_ids
FROM customer_master_master_distribution_type cmd, distribution_type dt
WHERE cmd.distribution_type_id = dt.id AND customer_master_master_id = ?';
$resultGetDistType = $wrapperObj->executeQuery($sqlGetDistType, [$customer_master_master_id]);
if ($resultGetDistType === false) {
show_pdo_error($sqlGetDistType, $wrapperObj->getLastStatement());
}
foreach ($resultGetDistType as $rowGetDistType) {
$distribution_type_id[] = $rowGetDistType['distribution_type_id'];
$distribution_type_name[$rowGetDistType['distribution_type_id']] = $rowGetDistType['name'];
$distribution_features_ids[$rowGetDistType['distribution_type_id']] = $rowGetDistType['distribution_features_ids'];
}
$distribution_type_name = array_unique($distribution_type_name);
$distribution_features_ids = array_unique($distribution_features_ids);
?>
- DDEX Party ID: = $pCMI_row["ddex_party_id"] ?>
- Opt-Out Date: = $pCMI_row["optin_date"] ?>
- Audio Delivery Option: = ucwords(($pCMI_row["delivery_option"] == "full") ? "Full Catalog" : str_replace('_', ' ', $pCMI_row['delivery_option'])) ?>
- MV Delivery Option: = ucwords(($pCMI_row["mv_delivery_option"] == "full" ? "Full Catalog" : "Cherry Picking")) ?>
executeQuery($sql, [$customer_master_master_id], QueryWrapper::RETURN_RESULT, QueryWrapper::DIRECT_DELIVERY);
if ($rs === false) {
show_pdo_error($sql, $wrapperObj->getLastStatement());
}
foreach ($rs as $row) {
$selected_ed[$row['order_type']]['priority'] = $row['priority'];
$selected_ed[$row['order_type']]['encoding'] = $row['encoding'];
$selected_ed[$row['order_type']]['delivery'] = $row['delivery'];
}
?>
if ($selected_ed['release']) { ?>
- Store Priority: = $selected_ed['release']['priority'] ?>
- Encoding: = $selected_ed['release']['encoding'] ?> (Full Track)
- Delivery: = $selected_ed['release']['delivery'] ?> (Full Track)
} ?>
if ($selected_ed['ringtone']) { ?>
- Delivery: = $selected_ed['ringtone']['encoding'] ?> (Tone)
- Delivery: = $selected_ed['ringtone']['delivery'] ?> (Tone)
} ?>
-
| Distribution: |
executeQuery($getFeatureName, []);
if ($getFeatureName_rs === false) {
show_pdo_error($getFeatureName, $wrapperObj->getLastStatement());
}
foreach ($getFeatureName_rs as $getFeatureName_row) {
$features_arr[$getFeatureName_row['id']] = $getFeatureName_row['name'];
}
asort($distribution_type_name);
foreach ($distribution_type_name as $key => $detail) {
$f_arr = explode(',', $distribution_features_ids[$key]);
$new_f_arr = array();
foreach ($f_arr as $v) {
$new_f_arr[] = $features_arr[$v];
}
echo '| ' . $detail . ' - | ';
echo implode(' ', $new_f_arr);
echo ' |
';
}
?>