function monthName()
{
?>
<select id="addAgeMonth">
<option>...</option>
<?php
for ($x = 1; $x <= 12; $x++) {
$id = numberToMonth($x);
?>
<option name= "<?php
echo $x;
?>
" > <?php
echo $id;
?>
</option>
<?php
}
?>
</select>
<?php
}
//loop through each month
$monthArray = array();
$queryMonthArray = array();
$queryMonthArray = explode(",", $statArray['months']);
//we need to eliminate duplicates - mysql doesnt allow group inside group_concats
foreach ($queryMonthArray as $resultMonth) {
$infoArray = array();
$infoArray = explode("|", $resultMonth);
$monthArray[$infoArray[0]] = $infoArray[1];
}
foreach ($monthArray as $month => $outlier) {
echo "<tr id='tr_" . $platformID . "_" . $publisherPlatformID . "_" . $statArray['year'] . "_" . $month . "_" . $statArray['archiveInd'] . "'>";
echo "<td style='padding:0px;'>";
echo "<table class='noBorderTable' style='width:340px;'>";
echo "<tr>";
echo "<td style='width:70px;font-weight:bold;'>" . numberToMonth($month) . " " . $statArray['year'] . "</td>";
echo "<td><a href=\"javascript:deleteMonth('" . $statArray['resourceType'] . "','" . $month . "','" . $statArray['year'] . "','" . $statArray['archiveInd'] . "', '" . $publisherPlatformID . "', '" . $platformID . "')\" style='font-size:100%;'>delete entire month</a>";
//print out prompt for outliers if outlierID is > 0
if ($outlier > 0) {
echo " <a href='ajax_forms.php?action=getMonthlyOutlierForm&publisherPlatformID=" . $publisherPlatformID . "&platformID=" . $platformID . "&archiveInd=" . $statArray['archiveInd'] . "&month=" . $month . "&year=" . $statArray['year'] . "&resourceType=" . $statArray['resourceType'] . "&height=340&width=415&modal=true' class='thickbox' style='font-size:100%;'>view outliers for this month</a>";
}
echo "</td></tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
}
if ($config->settings->useOutliers == "Y") {
echo "<tr>";
echo "<td><span style='font-weight:bold;'>YTD " . $statArray['year'] . "</span>";
if ($statArray['outlierID'] > 0) {
echo " <a href='ajax_forms.php?action=getYearlyOverrideForm&resourceType=" . $statArray['resourceType'] . "publisherPlatformID=" . $publisherPlatformID . "&platformID=" . $platformID . "&archiveInd=" . $statArray['archiveInd'] . "&year=" . $statArray['year'] . "&height=340&width=415&modal=true' class='thickbox' style='font-size:100%;'>update overrides for this year</a>";
<div id="div_stats">
<table border="0" style="width:480px">
<?php
if ($publisherPlatformID) {
$result = mysql_query("select distinct year, month, archiveInd from title_stats_monthly where publisherPlatformID='" . $publisherPlatformID . "' order by year, archiveInd, month;");
} else {
$result = mysql_query("select distinct year, month, archiveInd from title_stats_monthly tsm, publisher_platform pp where pp.publisherPlatformID = tsm.publisherPlatformID and pp.platformID = '" . $platformID . "' order by year, archiveInd, month;");
}
while ($row = mysql_fetch_assoc($result)) {
if ($row['archiveInd'] == "1") {
$archive = 'Archive';
} else {
$archive = '';
}
echo "<tr>";
echo "<td style='width:80px'><b>" . numberToMonth($row['month']) . " " . $row['year'] . "</b><br />" . $archive . "</td>";
echo "<td style='width:200px'><a href=\"javascript:deleteMonth('" . $row['month'] . "','" . $row['year'] . "','" . $row['archiveInd'] . "')\">delete entire month</a></td>";
//monthly ouliers
if ($publisherPlatformID) {
$query = "select *\r\n\t\t\tfrom title_stats_monthly tsm\r\n\t\t\twhere outlierID <> 0 and publisherPlatformID='" . $publisherPlatformID . "'\r\n\t\t\tand archiveInd='" . $row['archiveInd'] . "'\tand year='" . $row['year'] . "'\tand month='" . $row['month'] . "' and ignoreOutlierInd = 0;";
} else {
$query = "select tsm.*\r\n\t\t\tfrom title_stats_monthly tsm, publisher_platform pp\r\n\t\t\twhere tsm.publisherPlatformID = pp.publisherPlatformID and outlierID <> 0 and platformID='" . $platformID . "'\r\n\t\t\tand archiveInd='" . $row['archiveInd'] . "'\tand year='" . $row['year'] . "'\tand month='" . $row['month'] . "' and ignoreOutlierInd = 0;";
}
$outlier_result = mysql_query($query);
if (mysql_num_rows($outlier_result) != 0) {
echo "<td style='width:200px'><a href=\"javascript:popUp('outliers.php?publisherPlatformID=" . $publisherPlatformID . "&platformID=" . $platformID . "&archiveInd=" . $row['archiveInd'] . "&month=" . $row['month'] . "&year=" . $row['year'] . "');\">view outliers for this month</a></td>";
} else {
echo "<td style='width:200px'> </td>";
}
echo "</tr>";
#figure out if this is the max row to print the YTD
public function getSaveAge()
{
$this->setRquery("SELECT pDOBD,pDOBM,pDOBY FROM amistiPersonal WHERE userID=?", array($this->UID));
$res = $this->getRquery();
$id = $this->UID;
$age = getUserAge($res[0]['pDOBD'], $res[0]['pDOBM'], $res[0]['pDOBY']);
$age .= " years";
$birthD .= addZero($res[0]['pDOBD']) . " " . numberToMonth($res[0]['pDODM']);
$ageInfo = $this->UID == UID ? "Your age information:" : $this->uName . " age information:";
?>
<div class="pProfileICHeader"> <?php
echo $ageInfo;
?>
</div>
<?php
if ($this->UID == UID) {
//check if it same as cur user
?>
<div class="pProfileMenuShow">...</div>
<!--- menu -->
<div class="pProfileMenu">
<li id="ageEdit">Edit</li>
<li id="ageDelete">Delete</li>
</div>
<?php
}
?>
<div class="pProfileItem">
<table>
<tr><td>Date of Birth </td><td>: <?php
echo $birthD;
?>
</td></tr>
<tr><td> Age </td><td>: <?php
echo $age;
?>
</td></tr>
</table>
</div>
<?php
}
function generateNumberPatientReport($conn)
{
global $gTEXT;
require_once 'tcpdf/tcpdf.php';
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetPrintHeader(false);
$pdf->SetPrintFooter(false);
$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
require_once dirname(__FILE__) . '/lang/eng.php';
$pdf->setLanguageArray($l);
}
$pdf->AddPage();
$pdf->SetFillColor(255, 255, 255);
//=====================================================National Inventory Table=======================================================
$monthId = $_POST['MonthId'];
$year = $_POST['YearId'];
$countryId = $_POST['CountryId'];
$itemGroupId = $_POST['ItemGroupId'];
$currentYearMonth = $_POST['YearId'] . "-" . $_POST['MonthId'] . "-" . "01";
$monthList = array('1' => 'January', '2' => 'February', '3' => 'March', '4' => 'April', '5' => 'May', '6' => 'June', '7' => 'July', '8' => 'August', '9' => 'September', '10' => 'October', '11' => 'November', '12' => 'December');
$sql = " SELECT ItemName, AMC, ClStock, FORMAT(MOS,1) MOS, Qty StockOnOrder, FORMAT(Qty/AMC,1) StockOnOrderMOS,\n (ifnull(FORMAT(MOS,1),0)+ifnull(FORMAT(Qty/AMC,1),0)) TotalMOS,a.ItemNo,TotalPatient\n FROM \n \t\t\t\t(SELECT\n \t\t\t\t t_cnm_masterstockstatus.CountryId,\n \t\t\t\t t_itemlist.ItemNo,\n \t\t\t\t t_itemlist.ItemName,\n \t\t\t\t SUM(t_cnm_stockstatus.AMC) AMC,\n \t\t\t\t SUM(t_cnm_stockstatus.ClStock) ClStock,\n \t\t\t\t SUM(t_cnm_stockstatus.MOS) MOS\n \t\t\t\tFROM t_cnm_stockstatus\n \t\t\t\t INNER JOIN t_cnm_masterstockstatus\n \t\t\t\t ON (t_cnm_stockstatus.CNMStockId = t_cnm_masterstockstatus.CNMStockId)\n \t\t\t\t INNER JOIN t_itemlist\n \t\t\t\t ON (t_cnm_stockstatus.ItemNo = t_itemlist.ItemNo)\n \t\t\t\tWHERE (t_cnm_masterstockstatus.Year = '{$year}'\n \t\t\t\t AND t_cnm_masterstockstatus.MonthId ={$monthId}\n \t\t\t\t AND t_cnm_masterstockstatus.CountryId = {$countryId}\n \t\t\t\t AND t_cnm_masterstockstatus.ItemGroupId ={$itemGroupId}\n \t\t\t\t AND t_cnm_masterstockstatus.StatusId = 5)\n \t\t\t\tGROUP BY t_cnm_masterstockstatus.CountryId, t_itemlist.ItemNo, t_itemlist.ItemName) a \n \t\t\t\tLEFT JOIN (SELECT\n \t\t\t\t CountryId\n \t\t\t\t , ItemNo\n \t\t\t\t , SUM(Qty) Qty\n \t\t\t\tFROM\n \t\t\t\t t_agencyshipment\n \t\t\t\tWHERE (ShipmentDate > CAST('{$currentYearMonth}' AS DATETIME) AND ShipmentStatusId = 3)\n \t\t\t\tGROUP BY CountryId, ItemNo) b\n \t\t\t\tON a.CountryId = b.CountryId AND a.ItemNo = b.ItemNo\n \t\t\t\tLEFT JOIN (SELECT t_cnm_regimenpatient.CountryId,ItemNo,sum(TotalPatient) as TotalPatient\n \t\t\t\tfrom t_cnm_regimenpatient\n \t\t\t\tInner Join t_regimenitems ON t_cnm_regimenpatient.RegimenId=t_regimenitems.RegimenId\n \t\t\t\tGroup By t_cnm_regimenpatient.CountryId,ItemNo) c ON a.CountryId = c.CountryId AND a.ItemNo = c.ItemNo\n \t\t\t\t\n \t\t\t\tHAVING MOS>0 OR StockOnOrderMOS>0 \n \t\t\t\t;";
$result = mysql_query($sql, $conn);
$total = mysql_num_rows($result);
if ($total > 0) {
$data = array();
$f = 0;
$tblHTML = '';
while ($rec = mysql_fetch_array($result)) {
$addmonth = number_format($rec['TotalMOS']);
$currentYearMonth = $year . "-" . $monthId . "-" . "01";
$lastYearMonth = date("Y-m-d", strtotime(date("Y-m-d", strtotime($currentYearMonth)) . "{$addmonth} month"));
$temp = explode('-', $lastYearMonth);
$strMonth = numberToMonth($temp[1]);
$lastYearMonth = $strMonth . ', ' . $temp[0];
$data['SL'][$f] = $f;
$data['ItemName'][$f] = $rec['ItemName'];
$data['TotalPatient'][$f] = $rec['TotalPatient'] == 0 ? '' : number_format($rec['TotalPatient']);
$data['ClStock'][$f] = $rec['ClStock'] == 0 ? '' : number_format($rec['ClStock']);
$data['MOS'][$f] = $rec['MOS'] == 0 ? '' : number_format($rec['MOS'], 1);
$data['StockOnOrder'][$f] = $rec['StockOnOrder'] == 0 ? '' : number_format($rec['StockOnOrder']);
$data['StockOnOrderMOS'][$f] = $rec['StockOnOrderMOS'] == 0 ? '' : number_format($rec['StockOnOrderMOS'], 1);
$data['TotalMOS'][$f] = $rec['TotalMOS'] == 0 ? '' : number_format($rec['TotalMOS'], 1);
$tblHTML .= '<tr style="page-break-inside:avoid;">
<td align="center" width="30" valign="middle">' . ($data['SL'][$f] + 1) . '</td>
<td align="left" width="150" valign="middle">' . $data['ItemName'][$f] . '</td>
<td align="right" width="60" valign="middle">' . $data['TotalPatient'][$f] . '</td>
<td align="right" width="60" valign="middle">' . $data['ClStock'][$f] . '</td>
<td align="right" width="85" valign="middle">' . $data['MOS'][$f] . '</td>
<td align="right" width="60" valign="middle">' . $data['StockOnOrder'][$f] . '</td>
<td align="right" width="80" valign="middle">' . $data['StockOnOrderMOS'][$f] . '</td>
<td align="right" width="60" valign="middle">' . $data['TotalMOS'][$f] . '</td>
<td align="right" width="80" valign="middle">' . $lastYearMonth . '</td>
</tr>';
$f++;
}
$year = $_POST['YearId'];
$MonthName = $_POST['MonthName'];
$CountryName = $_POST['CountryName'];
$html = '
<!-- EXAMPLE OF CSS STYLE -->
<style>
</style>
<body>
<h4 style="text-align:center;"><b>' . $gTEXT['Number of Patients by Product Report of '] . ' ' . $CountryName . ' on ' . $MonthName . ',' . $year . '</b></h4>
</body>';
$pdf->SetFont('dejavusans', '', 10);
$pdf->writeHTMLCell(0, 0, 8, 10, $html, '', 0, 0, false, 'C', true);
$html = '
<!-- EXAMPLE OF CSS STYLE -->
<style>
td{
height: 6px;
line-height:3px;
}
</style>
<body>
<table width="600px" border="0.5" style="margin:0 auto;">
<tr>
<th width="30" align="center"><b>SL#</b></th>
<th width="150" align="left"><b>' . $gTEXT['Product Name'] . '</b></th>
<th width="60" align="right"><b>' . $gTEXT['Total Patients'] . '</b></th>
<th width="60" align="right"><b>' . $gTEXT['Available Stock'] . '</b></th>
<th width="85" align="left"><b>' . $gTEXT['MOS(Available)'] . '</b></th>
<th width="60" align="right"><b>' . $gTEXT['Stock on Order'] . '</b></th>
<th width="80" align="right"><b>' . $gTEXT['MOS(Ordered)'] . '</b></th>
<th width="60" align="left"><b>' . $gTEXT['Total MOS'] . '</b></th>
<th width="80" align="right"><b>' . $gTEXT['Projected Date'] . '</b></th>
</tr>' . $tblHTML . '</table></body>';
$pdf->SetFont('dejavusans', '', 7);
$pdf->writeHTMLCell(0, 0, 10, 40, $html, '', 1, 1, false, 'L', true);
$filePath = SITEDOCUMENT . 'administrator/components/com_jcode/source/report/pdfslice/NumberPatientReport.pdf';
if (file_exists($filePath)) {
unlink($filePath);
}
$pdf->Output('pdfslice/NumberPatientReport.pdf', 'F');
echo 'NumberPatientReport.pdf';
} else {
echo 'Processing Error';
}
}
$objPHPExcel->getActiveSheet()->getStyle('E6')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('F6')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('G6')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('H6')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('I6')->getFont()->setBold(true);
$sQuery = " SELECT ItemName, AMC, ClStock, FORMAT(MOS,1) MOS, Qty StockOnOrder, FORMAT(Qty/AMC,1) StockOnOrderMOS, (ifnull(FORMAT(MOS,1),0)+ifnull(FORMAT(Qty/AMC,1),0)) TotalMOS\n\t\t\t\t,a.ItemNo,TotalPatient\n\t\t\t\t FROM \n\t\t\t\t(SELECT\n\t\t\t\t t_cnm_masterstockstatus.CountryId,\n\t\t\t\t t_itemlist.ItemNo,\n\t\t\t\t t_itemlist.ItemName,\n\t\t\t\t SUM(t_cnm_stockstatus.AMC) AMC,\n\t\t\t\t SUM(t_cnm_stockstatus.ClStock) ClStock,\n\t\t\t\t SUM(t_cnm_stockstatus.MOS) MOS\n\t\t\t\tFROM t_cnm_stockstatus\n\t\t\t\t INNER JOIN t_cnm_masterstockstatus\n\t\t\t\t ON (t_cnm_stockstatus.CNMStockId = t_cnm_masterstockstatus.CNMStockId)\n\t\t\t\t INNER JOIN t_itemlist\n\t\t\t\t ON (t_cnm_stockstatus.ItemNo = t_itemlist.ItemNo)\n\t\t\t\tWHERE (t_cnm_masterstockstatus.Year = '{$year}'\n\t\t\t\t AND t_cnm_masterstockstatus.MonthId ={$monthId}\n\t\t\t\t AND t_cnm_masterstockstatus.CountryId = {$countryId}\n\t\t\t\t AND t_cnm_masterstockstatus.ItemGroupId ={$itemGroupId}\n\t\t\t\t AND t_cnm_masterstockstatus.StatusId = 5)\n\t\t\t\tGROUP BY t_cnm_masterstockstatus.CountryId, t_itemlist.ItemNo, t_itemlist.ItemName) a \n\t\t\t\tLEFT JOIN (SELECT\n\t\t\t\t CountryId\n\t\t\t\t , ItemNo\n\t\t\t\t , SUM(Qty) Qty\n\t\t\t\tFROM\n\t\t\t\t t_agencyshipment\n\t\t\t\tWHERE (ShipmentDate > CAST('{$currentYearMonth}' AS DATETIME) AND ShipmentStatusId = 3)\n\t\t\t\tGROUP BY CountryId, ItemNo) b\n\t\t\t\tON a.CountryId = b.CountryId AND a.ItemNo = b.ItemNo\n\t\t\t\tLEFT JOIN (SELECT t_cnm_regimenpatient.CountryId,ItemNo,sum(TotalPatient) as TotalPatient\n\t\t\t\tfrom t_cnm_regimenpatient\n\t\t\t\tInner Join t_regimenitems ON t_cnm_regimenpatient.RegimenId=t_regimenitems.RegimenId\n\t\t\t\tGroup By t_cnm_regimenpatient.CountryId,ItemNo) c ON a.CountryId = c.CountryId AND a.ItemNo = c.ItemNo\n\t\t\t\t " . $sWhere . "\n\t\t\t\tHAVING MOS>0 OR StockOnOrderMOS>0 \n\t\t\t\t {$sOrder}\n {$sLimit} order by ItemNo,ItemName";
$rResult = mysql_query($sQuery);
$i = 1;
$j = 7;
if ($rResult) {
while ($row = mysql_fetch_array($rResult)) {
$addmonth = number_format($row['TotalMOS']);
$currentYearMonth = $year . "-" . $monthId . "-" . "01";
$lastYearMonth = date("Y-m-d", strtotime(date("Y-m-d", strtotime($currentYearMonth)) . "{$addmonth} month"));
$temp = explode('-', $lastYearMonth);
$strMonth = numberToMonth($temp[1]);
$lastYearMonth = $strMonth . ' , ' . $temp[0];
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $j, $i)->SetCellValue('B' . $j, $row['ItemName'])->SetCellValue('C' . $j, $row['TotalPatient'] == '' ? '' : number_format($row['TotalPatient']))->SetCellValue('D' . $j, $row['ClStock'] == '' ? '' : number_format($row['ClStock']))->SetCellValue('E' . $j, $row['MOS'] == '' ? '' : number_format($row['MOS'], 1))->SetCellValue('F' . $j, $row['StockOnOrder'] == '' ? '0' : number_format($row['StockOnOrder']))->SetCellValue('G' . $j, $row['StockOnOrderMOS'] == '' ? '0.0' : number_format($row['StockOnOrderMOS'], 1))->SetCellValue('H' . $j, $row['TotalMOS'] == '' ? '' : number_format($row['TotalMOS'], 1))->SetCellValue('I' . $j, $lastYearMonth);
$objPHPExcel->getActiveSheet()->getStyle('A' . $j . ':A' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B' . $j . ':B' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('C' . $j . ':C' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('E' . $j . ':E' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('D' . $j . ':D' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('H' . $j . ':H' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('F' . $j . ':F' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$objPHPExcel->getActiveSheet()->getStyle('I' . $j . ':I' . $j)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
$styleThinBlackBorderOutline = array('borders' => array('outline' => array('style' => PHPExcel_Style_Border::BORDER_THIN, 'color' => array('argb' => 'FF000000'))));
$objPHPExcel->getActiveSheet()->getStyle('A' . $j . ':A' . $j)->applyFromArray($styleThinBlackBorderOutline);
$objPHPExcel->getActiveSheet()->getStyle('B' . $j . ':B' . $j)->applyFromArray($styleThinBlackBorderOutline);
$objPHPExcel->getActiveSheet()->getStyle('C' . $j . ':C' . $j)->applyFromArray($styleThinBlackBorderOutline);
$objPHPExcel->getActiveSheet()->getStyle('D' . $j . ':D' . $j)->applyFromArray($styleThinBlackBorderOutline);
<table border="0">
<?php
//get (and save in an array) YTD data for display
$arrayYTD = array();
$result = mysql_query("select distinct year from title_stats_ytd where publisherPlatformID='" . $publisherPlatformID . "';");
while ($row = mysql_fetch_assoc($result)) {
$arrayYTD[$row['year']] = "<tr>";
$arrayYTD[$row['year']] .= "<td><b>YTD " . $row['year'] . "</b></font></td>";
$arrayYTD[$row['year']] .= "<td> </td>";
$arrayYTD[$row['year']] .= "</tr>";
}
mysql_free_result($result);
$result = mysql_query("select distinct year, month from title_stats_monthly where publisherPlatformID='" . $publisherPlatformID . "' order by year, month;");
while ($row = mysql_fetch_assoc($result)) {
echo "<tr>";
echo "<td><b>" . numberToMonth($row['month']) . " " . $row['year'] . "</b></font></td>";
echo "<td><a href=\"javascript:deleteMonth('" . $row['month'] . "','" . $row['year'] . "')\">delete entire month</a></td>";
echo "</tr>";
//monthly ouliers
$query = "select titleStatsMonthlyID, title, usageCount, overrideUsageCount, color\r\n\t\t\tfrom title_stats_monthly tsm, title t, outlier o\r\n\t\t\twhere tsm.titleID = t.titleID\r\n\t\t\tand o.outlierID = tsm.outlierID\r\n\t\t\tand publisherPlatformID='" . $publisherPlatformID . "'\r\n\t\t\tand year='" . $row['year'] . "'\r\n\t\t\tand month='" . $row['month'] . "';";
$outlier_result = mysql_query($query);
if (mysql_num_rows($outlier_result) != 0) {
echo "<tr>";
echo "<td> </td>";
echo "<td>";
echo "<div id='div_show_outlier_" . $row['month'] . "_" . $row['year'] . "'>";
echo "<a href=\"javascript:toggleLayer('div_outlier_" . $row['month'] . "_" . $row['year'] . "','block');javascript:toggleLayer('div_show_outlier_" . $row['month'] . "_" . $row['year'] . "','none')\">view outliers for this month</a>";
echo "</div>";
echo "<div id='div_outlier_" . $row['month'] . "_" . $row['year'] . "' style='display:none'>";
echo "<table border='0'>";
while ($outlier_row = mysql_fetch_assoc($outlier_result)) {
$publisherPlatformID = $_GET['publisherPlatformID'];
$platformID = $_GET['platformID'];
$year = $_GET['year'];
$archiveInd = $_GET['archiveInd'];
if ($publisherPlatformID) {
$result = mysql_query("select distinct year, month, archiveInd from title_stats_monthly where publisherPlatformID='" . $publisherPlatformID . "' and year = '" . $year . "' and archiveInd = '" . $archiveInd . "' order by year, archiveInd, month;");
} else {
$result = mysql_query("select distinct year, month, archiveInd from title_stats_monthly tsm, publisher_platform pp where pp.publisherPlatformID = tsm.publisherPlatformID and pp.platformID = '" . $platformID . "' and year = '" . $year . "' and archiveInd = '" . $archiveInd . "' order by year, archiveInd, month;");
}
while ($row = mysql_fetch_assoc($result)) {
if ($row['archiveInd'] == "1") {
$archive = ' (archive)';
} else {
$archive = '';
}
echo "<label for='month' class='month'><b>" . numberToMonth($row['month']) . " " . $row['year'] . "</b> " . $archive . "</label>";
echo "<label for='deleteStats' class='deleteStats'><a href=\"javascript:deleteMonth('" . $row['month'] . "','" . $row['year'] . "','" . $row['archiveInd'] . "', '" . $publisherPlatformID . "', '" . $platformID . "')\">delete entire month</a></label>";
//monthly ouliers
if ($publisherPlatformID) {
$query = "select *\r\n\t\t\t\tfrom title_stats_monthly tsm\r\n\t\t\t\twhere outlierID <> 0 and publisherPlatformID='" . $publisherPlatformID . "'\r\n\t\t\t\tand archiveInd='" . $row['archiveInd'] . "'\tand year='" . $row['year'] . "'\tand month='" . $row['month'] . "' and ignoreOutlierInd = 0;";
} else {
$query = "select tsm.*\r\n\t\t\t\tfrom title_stats_monthly tsm, publisher_platform pp\r\n\t\t\t\twhere tsm.publisherPlatformID = pp.publisherPlatformID and outlierID <> 0 and platformID='" . $platformID . "'\r\n\t\t\t\tand archiveInd='" . $row['archiveInd'] . "'\tand year='" . $row['year'] . "'\tand month='" . $row['month'] . "' and ignoreOutlierInd = 0;";
}
$outlier_result = mysql_query($query);
if (mysql_num_rows($outlier_result) != 0) {
echo "<label for='outliers' class='outliers'><a href=\"javascript:popUp('outliers.php?publisherPlatformID=" . $publisherPlatformID . "&platformID=" . $platformID . "&archiveInd=" . $row['archiveInd'] . "&month=" . $row['month'] . "&year=" . $row['year'] . "');\">view outliers for this month</a></label>";
} else {
echo "<label for='outliers' class='outliers'> </label>";
}
mysql_free_result($outlier_result);
echo "<br />";
