Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $qry = "SELECT sp.TillRec as TillRec,sp.Code as Code, s.Name AS department_description, sp.Description AS Description, count(*) as cnt
- FROM
- stocktake_products sp
- INNER JOIN
- sections s ON sp.Section = s.Number
- WHERE
- stocktake_id = '{$stocktake_id}'
- AND
- TillRec IS NOT NULL
- GROUP BY Code
- ORDER BY s.Name, sp.Description, sp.TillRec";
- $qry_res = db::c()->query($qry);
- $report .= "<table id='stock_detail_report' cellspacing='0'>
- <tr>
- <td class='top' style='text-align:left;width:15%;' colspan='14'><div class='nosplit'></div></td>
- <td class='top' style='text-align:left;width:15%;' colspan='2'><div class='nosplit'>Till Consumption</div></td>
- <td class='top' style='text-align:left;width:15%;' colspan='14'><div class='nosplit'></div></td>
- </tr>
- <tr>
- <td class='top' style='text-align:left;width:15%;'><div class='nosplit'>Code</div></td>
- <td class='top' style='text-align:left;width:50%;'><div class='nosplit'>Description</div></td>
- <td class='top' style='text-align:left;width:50%;'><div class='nosplit'>Size</div></td>
- <td class='top' style='text-align:left;width:50%;'><div class='nosplit'>Unit</div></td>
- <td class='top' style='text-align:left;width:50%;'><div class='nosplit'>UOM</div></td>
- <td class='top' style='text-align:left;width:50%;'><div class='nosplit'>Cost Price</div></td>
- <td class='top' style='text-align:left;width:50%;'><div class='nosplit'>Retail</div></td>
- <td class='top' style='text-align:left;width:20%;'><div class='nosplit'>Opening Stock</div></td>
- <td class='top' style='text-align:center;width:10%;'><div class='nosplit'>Purchases</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Credits</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Transfers</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Closing Stock</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Allowances</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Stock Consumption</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Product Consumption</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Recipe Consumption</div></td>
- <td class='top' style='text-align:right;width:10%;'><div class='nosplit'>Variance</div></td>
- </tr>";
- $curdep = null;
- while ($row = $qry_res->fetch(PDO::FETCH_ASSOC)) {
- $qrycnt = db::c()->query("select count(*) from stocktake_products where stocktake_id = '{$stocktake_id}' and TillRec = '{$row['TillRec']}'") ->fetchColumn(0);
- $headQry = "SELECT
- sp.Description as prodName, sp.Cost as cost, sp.PLUProdCode as PLUProdCode, sp.Code as Code, sc.UnitsofMeasure as uom,
- sc.DescriptionSize as sizeDesc, sc.UnitDesc AS uDesc, sp.Bar1Price as retail, sp.CellLastStock as opening
- FROM
- stocktake_products sp
- INNER JOIN sizecodes sc ON sp.SizeCode = sc.Code
- WHERE
- sp.stocktake_id = '4687'
- AND
- (sp.Code = '{$row['Code']}' or sp.PLUProdCode = '{$row['Code']}')
- ORDER BY sp.PLUProdCode ASC;";
- $qryHead_res = db::c()->query($headQry);
- $opening = '0.00';
- while ($rowHead = $qryHead_res->fetch(PDO::FETCH_ASSOC))
- {
- if ($qrycnt == 1)
- {
- $report .= "
- <tr>
- <td><div class='nosplit'><strong>". $rowHead['Code'] ."</strong></div></td>
- <td><div class='nosplit'>". $rowHead['prodName'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['sizeDesc'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['uDesc'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['uom'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['cost'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['retail'] ."</div></td>
- <td><div class='nosplit'>". $opening ."</div></td>
- <td><div class='nosplit'>". $rowHead['deliveries'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['credits'] ."</div></td>
- <td><div class='nosplit'>".$tra."</div></td>
- <td><div class='nosplit'>". $closing ."</div></td>
- <td><div class='nosplit'>". $allowance ."</div></td>
- <td><div class='nosplit'>". $consCost ."</div></td>
- <td><div class='nosplit'>". $ts ."</div></td>
- <td><div class='nosplit'>". $tsr ."</div></td>
- <td bgcolor='#FF0000'><div class='nosplit'>". $varianceQty ."</div></td></tr>
- </tr>";
- }
- else if (!$rowHead['PLUProdCode'] or $rowHead['PLUProdCode'] == "" and $qrycnt > 1)
- {
- $report .= "
- <tr>
- <td><div class='nosplit'><strong>". $rowHead['Code'] ."</strong></div></td>
- <td><div class='nosplit'>". $rowHead['prodName'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['sizeDesc'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['uDesc'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['uom'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['cost'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['retail'] ."</div></td>
- <td><div class='nosplit'>". $opening ."</div></td>
- <td><div class='nosplit'>". $rowHead['deliveries'] ."</div></td>
- <td><div class='nosplit'>". $rowHead['credits'] ."</div></td>
- <td><div class='nosplit'>".$tra."</div></td>
- <td><div class='nosplit'>". $closing ."</div></td>
- <td><div class='nosplit'>". $allowance ."</div></td>
- <td><div class='nosplit'>". $consCost ."</div></td>
- <td><div class='nosplit'>". $ts ."</div></td>
- <td><div class='nosplit'>". $tsr ."</div></td>
- <td bgcolor='#FF0000'><div class='nosplit'>". $varianceQty ."</div></td></tr>
- </tr>";
- $subQry = "SELECT
- sp.Description as prodName, sp.Cost as cost, sp.PLUProdCode as PLUProdCode, sp.Code as Code, sc.UnitsofMeasure as uom,
- sc.DescriptionSize as sizeDesc, sc.UnitDesc AS uDesc, sp.Bar1Price as retail, sp.CellLastStock as opening
- FROM
- stocktake_products sp
- INNER JOIN sizecodes sc ON sp.SizeCode = sc.Code
- WHERE
- sp.stocktake_id = '4687'
- AND
- (sp.Code = '{$row['Code']}' or sp.PLUProdCode = '{$row['Code']}')
- ORDER BY sp.PLUProdCode ASC;";
- //echo $subQry . "<br/>";
- $subQry_res = db::c()->query($subQry);
- while ($rowSub = $subQry_res->fetch(PDO::FETCH_ASSOC))
- {
- $opening = $rowSub['opening'];
- $report .= "
- <tr>
- <td style = 'padding-left:20px;'><div class='nosplit'>". $rowSub['Code'] ."</strong></div></td>
- <td ><div class='nosplit'>". $rowSub['prodName'] ."</div></td>
- <td><div class='nosplit'>". $rowSub['sizeDesc'] ."</div></td>
- <td><div class='nosplit'>". $rowSub['uDesc'] ."</div></td>
- <td><div class='nosplit'>". $rowSub['uom'] ."</div></td>
- <td><div class='nosplit'>". $rowSub['cost'] ."</div></td>
- <td><div class='nosplit'>". $rowSub['retail'] ."</div></td>
- <td><div class='nosplit'>". $opening ."</div></td>
- <td><div class='nosplit'>". $rowSub['deliveries'] ."</div></td>
- <td><div class='nosplit'>". $rowSub['credits'] ."</div></td>
- <td><div class='nosplit'>".$tra."</div></td>
- <td><div class='nosplit'>". $closing ."</div></td>
- <td><div class='nosplit'>". $allowance ."</div></td>
- <td><div class='nosplit'>". $consCost ."</div></td>
- <td><div class='nosplit'>". $ts ."</div></td>
- <td><div class='nosplit'>". $tsr ."</div></td>
- <td bgcolor='#FF0000'><div class='nosplit'>". $varianceQty ."</div></td></tr>";
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement