<?php
session_name('CAKEPHP'); session_start();
error_reporting(FALSE);
$PageSecurity = 3;

include('config.php');
include('includes/ConnectDB.inc');
include('includes/function_lib.php');
include('includes/LanguageSetup.php');
include('includes/DateFunctions.inc');
include('cocoon_config.php');

function getFieldvalue_cake($table, $condition, $val, $field)
{
  global $link1;
  //echo "select ".$field." from ".$table." where ".$condition." ='".$val."'";
  $sql = mysqli_query($link1, "select " . $field . " from " . $table . " where " . $condition . " ='" . $val . "'");
  $r = mysqli_fetch_array($sql);
  //echo "select ".$field." from ".$table." where ".$condition." ='".$val."'"; 
  return ($r[$field]);
}
?>
<script type="text/javascript" language="javascript">
  function toggle_visibility(id) {
    var e = document.getElementById(id);
    e.style.display = 'none';
    window.print();
  }
</script>
<?php
$sql = $_SESSION['expiryreport'];
$s = new db_query();
?>
<?php
$Compamies = DB_query("select * from companies", $db);
$CompamiesRow = DB_fetch_array($Compamies);
$sql1 = "SELECT * FROM companies where CompanyId='" . $_SESSION['ACGCompanyId'] . "'";
$sqlres = DB_query($sql1, $db);
$companyRow = DB_fetch_array($sqlres);
$s = new db_query();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
  <meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
  <title>Expiry Item Report</title>

  <style type="text/css" media="print">
    @page port {
      size: portrait;
    }

    @page land {
      size: landscape;
    }

    .portrait {
      page: port;
    }

    .wrapper {
      page: land;
    }
  </style>

  <style type="text/css">
    @page {
      size: portrait;
      margin: 10px;
    }

    @media print {
      * {
        box-sizing: border-box;
      }

      body {
        margin: 0px;
        padding: 0px;
        font-size: 12px;
        line-height: 18px;
        font-family: Arial, Helvetica, sans-serif;
        color: #000;
        font-weight: normal;
      }

      h1,
      h2,
      h3,
      h4,
      h5,
      p {
        margin: 0px;
        padding: 0px;
      }

      p {
        text-align: left;
      }

      h1 {
        font-size: 20px;
        line-height: 30px;
        font-weight: bold;
        text-transform: uppercase;
      }

      h2 {
        font-size: 18px;
        line-height: 28px;
        font-weight: normal;
      }

      thead {
        display: table-header-group;
      }

      .wrapper {
        width: 99%;
        height: auto;
        float: left;
        border: #000000 1px solid;
        border-bottom: #000000 1px solid;
      }

      .div_first,
      .div_first .full {
        width: 100%;
        height: auto;
        float: left;
        position: relative;
      }

      .div_first .left {
        width: 16%;
        text-align: center;
        height: auto;
        vertical-align: middle;
        height: auto;
        padding: 1% 0;
        float: left;
      }

      .div_first .middle {
        width: 68%;
        text-align: center;
        padding: 1% 0;
        margin: 0 auto;
        float: left;
      }

      .div_first .right {
        width: 16%;
        text-align: center;
        padding: 1% 0;
        float: left;
      }

      .div_first .full {
        text-align: center;
        border: 0;
      }

      .div_second,
      .div_third {
        width: 100%;
        height: auto;
        border-top: #000000 1px solid;
        float: left;
      }

      .div_second table tr th,
      .div_second table tr td {
        border-right: #000000 1px solid;
        border-bottom: #000000 1px solid;
      }

      .div_second table tr th {
        text-align: left;
      }

      .div_second table tr th:last-child,
      .div_second table tr td:last-child {
        border-right: 0;
      }

      .div_second table tr:last-child td {
        border-bottom: 0;
      }

      .div_second table tr td>table tr td {
        border-right: #000000 1px solid;
        border-bottom: #000000 1px solid;
      }

      .div_second table tr td>table tr td:last-child {
        border-right: 0;
      }

      .div_second table tr td>table tr:last-child td {
        border-bottom: 0;
      }

      .div_third table tr th,
      .div_third table tr td {
        border-bottom: #000 1px solid;
        border-right: #000 1px solid;
      }

      .div_third table tr th {
        background-color: transparent;
        text-align: left;
      }

      .div_third table tr th:last-child,
      .div_third table tr td:last-child {
        border-right: none;
      }

      .div_third table tr:last-child td {
        border-bottom: none;
      }

      .f12 {
        font-weight: bold;
        color: #000;
        font-size: 12px;
      }

      .f11 {
        color: #000;
        font-size: 12px;
        line-height: 18px;
      }

      .f14 {
        color: #000;
        font-size: 18px;
      }

      .mt26 {
        margin-top: 4px;
        width: 96%;
      }

      .mt27 {
        margin-top: 4px;
        width: 66%;
      }

      .border_top {
        border-top: #000 1px solid;
      }

      .border_bottom {
        border-bottom: #000 1px solid;
      }

      .wdt1 {
        width: 8%;
      }

      .wdt2 {
        width: 100px;
      }

      .wdt3 {
        width: 66px;
      }

      .wdt4 {
        width: 80px;
      }

      .wdt5 {
        width: 52px;
      }

      .wdt6 {
        width: 60px;
      }
    }

    @media screen {

      /* CSS Document */
      * {
        box-sizing: border-box;
      }

      body {
        margin: 0px;
        padding: 0px;
        background-color: #fff;
        font-size: 12px;
        line-height: 18px;
        font-family: Arial, Helvetica, sans-serif;
        color: #000;
        font-weight: normal;
      }

      h1,
      h2,
      h3,
      h4,
      h5,
      p {
        margin: 0px;
        padding: 0px;
      }

      p {
        text-align: left;
      }

      #foo {
        width: 1070px;
        height: auto;
        margin: 0px auto;
      }

      .wrapper {
        width: 1070px;
        height: auto;
        margin: 10px auto;
        border-top: #000000 1px solid;
      }

      h1 {
        font-size: 24px;
        line-height: 30px;
        font-weight: bold;
        text-transform: uppercase;
      }

      h2 {
        font-size: 18px;
        line-height: 28px;
        font-weight: normal;
      }

      .div_first,
      .div_first .full {
        width: 100%;
        height: auto;
        border-left: #000000 1px solid;
        border-right: #000000 1px solid;
        float: left;
        position: relative;
        display: table;
      }

      .div_first .full {
        text-align: center;
        border: 0;
        margin: 10px 0 0;
      }

      .div_first .left,
      .div_first .middle,
      .div_first .right {
        float: left;
        display: table-cell;
        vertical-align: middle;
      }

      .div_first .left {
        width: 16%;
        text-align: center;
        height: auto;
        vertical-align: middle;
        padding: 1% 0;
      }

      .div_first .middle {
        width: 68%;
        text-align: center;
        padding: 1% 0;
        position: relative;
        margin: 0 auto;
      }

      .div_first .right {
        width: 16%;
        text-align: center;
        padding: 1% 0;
      }

      .div_second,
      .div_third,
      .div_forth {
        width: 100%;
        height: auto;
        border-top: #000000 1px solid;
        border-left: #000000 1px solid;
        border-right: #000000 1px solid;
        float: left;
      }

      .div_second table tr th,
      .div_second table tr td {
        border-right: #000000 1px solid;
        border-bottom: #000000 1px solid;
      }

      .div_second table tr th {
        background-color: #ccc;
        text-align: left;
      }

      .div_second table tr th:last-child,
      .div_second table tr td:last-child {
        border-right: 0;
      }

      /*.div_second table tr:last-child td{border-bottom:0;}*/
      .div_second table tr td>table tr td {
        border-right: #000000 1px solid;
        border-bottom: #000000 1px solid;
      }

      .div_second table tr td>table tr td:last-child {
        border-right: 0;
      }

      .div_second table tr td>table tr:last-child td {
        border-bottom: 0;
      }

      .div_third table tr th,
      .div_third table tr td {
        border-bottom: #000 1px solid;
        border-right: #000 1px solid;
      }

      .div_third table tr th {
        background-color: #ccc;
        text-align: left;
      }

      .div_third table tr th:last-child,
      .div_third table tr td:last-child {
        border-right: none;
      }

      /*.div_third table tr:last-child td{border-bottom:none;}*/

      .f12 {
        color: #000;
        font-size: 12px;
        font-weight: bold;
      }

      .f11 {
        color: #000;
        font-size: 12px;
        line-height: 18px;
      }

      .f14 {
        color: #000;
        font-size: 18px;
      }

      .mt26 {
        margin-top: 4px;
        width: 96%;
      }

      .mt27 {
        margin-top: 4px;
        width: 56%;
      }

      .border_top {
        border-top: #000 1px solid;
      }

      .border_bottom {
        border-bottom: #000 1px solid;
      }

      .wdt1 {
        width: 10%;
      }

      .wdt2 {
        width: 180px;
      }

      .wdt3 {
        width: 66px;
      }

      .wdt4 {
        width: 120px;
      }

      .wdt5 {
        width: 52px;
      }

      .wdt6 {
        width: 70px;
      }
    }
  </style>
</head>

<body>
  <div id="foo">
    <p style="text-align:right;"><input type="button" onclick="javascript:toggle_visibility('foo');" value="Print" /></p>
  </div>
  <div class="wrapper">
    <!-- <div class="div_first">
    <?php $logoImage = ($CompamiesRow['CompanyLogo'] == '') ? 'Final_Logo_RM.png' : $CompamiesRow['CompanyLogo']; ?>
      <div class="left"><img src="Setup/CompanyLogo/<?php echo $logoImage;  ?>" class="mt26" /></div>
      <div class="middle"><?php
                          if ($CompamiesRow['CompanyName'] != "") {
                            echo "<h1>" . $CompamiesRow['CompanyName'] . "</h1>";
                          } else {
                            echo "";
                          }

                          if ($InoRow['deladd1'] != "") {
                            echo $InoRow['deladd1'];
                          } else {
                            echo "";
                          }
                          if ($InoRow['deladd2'] != "") {
                            echo ", " . $InoRow['deladd2'];
                          } else {
                            echo "";
                          }
                          if ($InoRow['deladd3'] != "") {
                            echo ", " . $InoRow['deladd3'];
                          } else {
                            echo "";
                          }
                          if ($InoRow['city'] != "") {
                            echo ", " . $s->getFieldValue("city_master", "id='" . $InoRow['city'] . "'", "city");
                          } else {
                            echo "";
                          }
                          if ($InoRow['pincode'] != "") {
                            echo " - " . $InoRow['pincode'];
                          } else {
                            echo "";
                          }
                          if ($InoRow['state'] != "") {
                            echo ", " . $s->getFieldValue("state_master", "id='" . $InoRow['state'] . "'", "state");
                          } else {
                            echo "";
                          }
                          if ($InoRow['country'] != "") {
                            echo ", " . $s->getFieldValue("country_master", "id='" . $InoRow['country'] . "'", "country");
                          } else {
                            echo "";
                          }
                          ?>
     <div class="full"><span class="f11"><?php echo "Phone No.:" . $CompamiesRow['Phone'] . ",   Fax No.: " . $CompamiesRow['fax'] . ", Email ID.: " . $CompamiesRow['email'] . ",   Website: " . $CompamiesRow['website']; ?><br>
    <?php echo $_SESSION['mess']; ?>
    </span></div>
       <h2>Expiry Item Report</h2>
      </div>
      <div class="right"></div>
  </div> -->
    <div class="div_first">
      <div class="left"><img src="images/ssmh-logo.jpeg" class="mt26" /></div>
      <div class="middle">
        <h1>Shekhar Sharraf Memorial Hospital</h1>
        <div class="f14">RUSA Medical Centre (Aligarh)</div>
        <div class="f12">6Km. Milestone, Agra Road, Aligarh - 202001, U.P. (India)</div>
        <div class="f12">Email : info@rusamedicalcentre.com</div>
        <div class="full">
          <h2>Expiry Item Report</h2>
        </div>
      </div>
      <div class="right"><img src="images/rusa-logo.jpeg" vspace="10" class="mt27" /></div>
    </div>
    <div class="div_second">
      <table width="100%" cellpadding="3" cellspacing="0" border="0">
        <thead>
          <th class="f12 wdt1">Sr No.</th>
          <th class="f12 wdt1" width="15%">Store</th>
          <th width="20px" class="f12 wdt1">Item Code</th>
          <th width="15%" class="f12">Item Name</th>
          <th width="15%" class="f12 wdt1">Batch No.</th>
          <th width="15%" class="f12 wdt1">Quantity</th>
          <th width="80" class="f12 wdt1">Value </th>
          <th width="80" class="f12 wdt1">Amount</th>
          <th colspan="3" class="f12 wdt1">Expiry Date</th>
        </thead>
        <?php
        $i = 1;
        $result = mysqli_query($link1, $sql);
        $numrow1 = mysqli_num_rows($result);
        if (mysqli_num_rows($result) > 0) {
          while ($myrow = mysqli_fetch_array($result)) {
            $hmis_storename = getFieldvalue_cake('store_masters', 'store_code', $myrow['store_code'], 'store_desc');
            $hmis_itemname = getFieldvalue_cake('itemforms', 'item_code', $myrow['item_code'], 'item_desc');
        ?>
            <tr class="f11">
              <td class="f12"><?php echo $i; ?></td>
              <td width="3%" class="f12"><?php echo $hmis_storename; ?></td>
              <td width="20px" class="f12"><?php echo $myrow['item_code']; ?></td>
              <td width="25%" class="f12"><?php echo  $hmis_itemname; ?></td>
              <td width="80" class="f12"><?php echo $myrow['batch_no']; ?></td>
              <td width="70" style="text-align:right;" class="f12"><?php echo number_format((float)$myrow['qty'], 2);
                                                                    $stock[] = $myrow['qty']; ?></td>
              <td width="80" class="f12"><?php echo $myrow['mrp'];
                                          $amount[] = $myrow['mrp'] ?></td>
              <td width="80" style="text-align:right;"><?php echo $myrow['mrp'] * $myrow['qty'];
                                                        $total_amount[] = $myrow['mrp'] * $myrow['qty']; ?></td>
              <td width="80" class="f12"><?php echo date('d/m/Y', strtotime($myrow['expire_date'])); ?></td>

            </tr>
          <?php $i++;
          }
          if ($numrow1 > 0) { ?>
            <tr class="f12">
              <td colspan="6" style="text-align:right;"><strong>Total Value</strong></td>
              <td class="f12 wdt6" style="text-align:right"><strong><?php echo number_format(array_sum($amount), 2); ?></strong></td>
              <td class="f12 wdt6" style="text-align:right"><strong><?php echo number_format(array_sum($total_amount), 2); ?></strong></td>
              <td>&nbsp;</td>

            </tr>
          <?php } ?>
        <?php } else { ?>
          <tr bgcolor="#e7e7e7" style="height: 25px">
            <td class="jjrs_tabledata1" colspan="10" align="center">No Records</td>
          </tr> <?php } ?>

      </table>

    </div>
  </div>
  </div>
  </div>
  <script type="text/javascript" language="javascript">
    function toggle_visibility(id) {
      var e = document.getElementById(id);
      e.style.display = 'none';
      //alert(e.style.display);
      window.print();
    }
  </script>
</body>

</html>