= ?") : ""); ($num_of_days) ? $data_params[] = $days_back : ''; break; } case 'tones_to_be_cut':{ $sql = "select count(rod.clip_id) as s from ringtone_order ro inner join ringtone_order_detail rod on ro.ringtone_order_id = rod.ringtone_order_id inner join track_clips tc where rod.clip_id = tc.clip_id and rod.date_cut is null and ro.cut_only = 'N' and tc.start_time is null and tc.end_time is null " .(($num_of_days) ? (" and ro.date >= ?") : ""); ($num_of_days) ? $data_params[] = $days_back : ''; break; } case 'tones_delivered':{ $sql = "select count(rod.clip_id) as s from ringtone_order ro inner join ringtone_order_detail rod on ro.ringtone_order_id = rod.ringtone_order_id and ro.cut_only = 'N' where rod.date_delivered is not null " .(($num_of_days) ? (" and ro.date >= ?") : ""); ($num_of_days) ? $data_params[] = $days_back : ''; break; } case 'tones_to_be_delivered':{ $sql = "select count(rod.clip_id) as s from ringtone_order ro inner join ringtone_order_detail rod on ro.ringtone_order_id = rod.ringtone_order_id and ro.cut_only = 'N' where rod.date_delivered is null and rod.date_cut is not null " .(($num_of_days) ? (" and ro.date >= ?") : ""); ($num_of_days) ? $data_params[] = $days_back : ''; break; } } $rs = $wrapperObj->executeQuery($sql, $data_params); if ($rs === false) { show_pdo_error($sql, $wrapperObj->getLastStatement()); } if (isset($rs[0])) { $row = $rs[0]; return isset($row['s']) ? $row['s'] : false; } else { return false; } } $var = ''; $var .= '

	Week (7 Days)	Month (30 days)	All Time (inception to date)
Cut Only	-	-	'.(getClipNum("cut_only", 0, $wrapperObj) ? getClipNum("cut_only", 0, $wrapperObj) : '0').'
Tones Cut	'.(getClipNum("tones_cut", 7, $wrapperObj) ? getClipNum("tones_cut", 7, $wrapperObj) : '0').'	'.(getClipNum("tones_cut", 30, $wrapperObj) ? getClipNum("tones_cut", 30, $wrapperObj) : '0').'	'.(getClipNum("tones_cut", 0, $wrapperObj) ? getClipNum("tones_cut", 0, $wrapperObj) : '').'
Tones to be cut	'.(getClipNum("tones_to_be_cut", 7, $wrapperObj) ? getClipNum("tones_to_be_cut", 7, $wrapperObj) : '0').'	'.(getClipNum("tones_to_be_cut", 30, $wrapperObj) ? getClipNum("tones_to_be_cut", 30 , $wrapperObj) : '0').'	'.(getClipNum("tones_to_be_cut", 0, $wrapperObj) ? getClipNum("tones_to_be_cut", 0, $wrapperObj) : '0').'
Tones Delivered	'.(getClipNum("tones_delivered", 7, $wrapperObj) ? getClipNum("tones_delivered", 7, $wrapperObj) : '0').'	'.(getClipNum("tones_delivered", 30, $wrapperObj) ? getClipNum("tones_delivered", 30, $wrapperObj) : '0').'	'.(getClipNum("tones_delivered", 0, $wrapperObj) ? getClipNum("tones_delivered", 0, $wrapperObj) : '0').'
Tones to be delivered	'.(getClipNum("tones_to_be_delivered", 7, $wrapperObj) ? getClipNum("tones_to_be_delivered", 7, $wrapperObj) : '0').'	'.(getClipNum("tones_to_be_delivered", 30, $wrapperObj) ? getClipNum("tones_to_be_delivered", 30, $wrapperObj) : '0').'	'.(getClipNum("tones_to_be_delivered", 0, $wrapperObj) ? getClipNum("tones_to_be_delivered", 0, $wrapperObj) : '0').'

'; ?>