addDataParam('s', $old_date); $dataParams->addDataParam('s', $today); //--------------------------------------------------------------------------------------------- $sql1 = 'SELECT count(prospective_label_id) as s FROM prospective_label WHERE date_signedup BETWEEN ? AND ?'; $rs1 = $wrapperObj->executeQuery($sql1, $dataParams); if ($rs1 === false) { showierror($sql1); } //--------------------------------------------------------------------------------------------- $sql2 = 'SELECT count(prospective_label_id) as s FROM prospective_label WHERE date_processed BETWEEN ? AND ?'; $rs2 = $wrapperObj->executeQuery($sql2, $dataParams); if ($rs2 === false) { showierror($sql2); } //--------------------------------------------------------------------------------------------- $sql3 = 'SELECT count(prospective_label_id) as s FROM prospective_label WHERE orchard_accepted = "rejected" AND date_processed BETWEEN ? AND ?'; $rs3 = $wrapperObj->executeQuery($sql3, $dataParams); if ($rs3 === false) { showierror($sql3); } //--------------------------------------------------------------------------------------------- $sql4 = 'SELECT count(prospective_label_id) as s FROM prospective_label INNER JOIN vendor ON vendor.vendor_id = prospective_label.vendor_id WHERE orchard_accepted = "accepted" AND transferred = "Y" AND date_signed BETWEEN ? AND ?'; $rs4 = $wrapperObj->executeQuery($sql4, $dataParams); if ($rs4 === false) { showierror($sql4); } ?>

Prospective Label

Past "> days
'.($viewall ? sortColumnHeader('Date Range', 'date_range', $url) : 'Date Range').' '.($viewall ? sortColumnHeader('Report Description', 'report_description', $url) : 'Report Description').' '.($viewall ? sortColumnHeader('Total', 'total', $url) : 'Total').' '; $temp_range = ((isset($_REQUEST['range']) && ctype_digit($_REQUEST['range'])) ? $_REQUEST['range'] : "7"); $varTable .=' Past '.$temp_range.' days Prospective Label Submissions '.(isset($no_url) ? (isset($rs1[0]['s']) ? $rs1[0]['s'] : 0) : ''.(isset($rs1[0]['s']) ? $rs1[0]['s'] : 0).'').' Past ' . ((isset($_REQUEST['range']) && ctype_digit($_REQUEST['range'])) ? $_REQUEST['range'] : "7") . ' days Prospective Labels Approved '.(isset($no_url) ? (isset($rs2[0]['s']) ? $rs2[0]['s'] : 0) : ''.(isset($rs2[0]['s']) ? $rs2[0]['s'] : 0).'').' Past ' . ((isset($_REQUEST['range']) && ctype_digit($_REQUEST['range'])) ? $_REQUEST['range'] : "7") . ' days Prospective Labels Rejected '.(isset($no_url) ? (isset($rs3[0]['s']) ? $rs3[0]['s'] : 0) : ''.(isset($rs3[0]['s']) ? $rs3[0]['s'] : 0).'').' Past ' . ((isset($_REQUEST['range']) && ctype_digit($_REQUEST['range'])) ? $_REQUEST['range'] : "7") . ' days Prospective Labels Approved and switched to signed '.(isset($no_url) ? (isset($rs4[0]['s']) ? $rs4[0]['s'] : 0) : ''.(isset($rs4[0]['s']) ? $rs4[0]['s'] : 0).'').'
'; echo $varTable; ?>