<?php
ob_start();
session_name('CAKEPHP'); session_start();
$PageSecurity = 1;
include('config.php');
include('includes/ConnectDB.inc');
include('includes/function_lib.php');
include('includes/LanguageSetup.php');
include('includes/DateFunctions.inc');
include('cocoon_config.php');
date_default_timezone_set('Asia/Calcutta');
$s = new db_query();
?>

<?php
$sql1 = "SELECT * FROM companies where CompanyId='" . $_SESSION['ACGCompanyId'] . "'";
$sqlres = DB_query($sql1, $db);
$companyRow = DB_fetch_array($sqlres);

$GetRecord = $_SESSION['gst_sales_summary'];
$Compamies = DB_query("select * from companies", $db);
$CompamiesRow = DB_fetch_array($Compamies);
//unset($_SESSION['trf_req_rep']);
?>

<!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>GST Sales Summary</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">
    @print {
      size: portrait;
      margin: 10px;
    }

    @media print {
      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: 24px;
        font-weight: normal;
        font-family: Arial, Helvetica, sans-serif !important;
      }

      h2 {
        font-size: 18px;
        line-height: 22px;
        font-weight: normal;
        font-family: Arial, Helvetica, sans-serif !important;
      }

      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;
        /*border-bottom: #000000 1px solid;
  border-top: #000000 1px solid;*/
        /*border-left: #000000 1px solid;
  border-right: #000000 1px solid;*/
        float: left;
        position: relative;
      }

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

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

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

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

      .div_second,
      .div_third,
      .div_forth {
        width: 100%;
        height: auto;
        border-top: #000000 1px solid;
        /*border-bottom: #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 {
        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;
      }

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

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

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

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

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

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

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

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

      .mt27 {
        margin-top: 0px;
        width: 70%;
      }

      .mt28 {
        margin-top: 0px;
        width: 100%;
      }

      .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 */
      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: 28px;
        font-weight: bold;
        font-family: Arial, Helvetica, sans-serif !important;
      }

      h2 {
        font-size: 18px;
        line-height: 22px;
        font-weight: normal;
        font-family: Arial, Helvetica, sans-serif !important;
      }

      .div_first,
      .div_first .full {
        width: 100%;
        height: auto;
        /*border-bottom: #000000 1px solid;
  border-top: #000000 1px solid;*/
        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: 18%;
        text-align: center;
        height: auto;
        vertical-align: middle;
        padding: 1%;
      }

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

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

      .div_second,
      .div_third,
      .div_forth {
        width: 100%;
        height: auto;
        /*border-bottom: #000000 1px solid;*/
        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;
      }

      .div_forth {
        border-bottom: #000000 1px solid;
      }

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

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

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

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

      .mt27 {
        margin-top: 0px;
        width: 100%;
      }

      .mt28 {
        margin-top: 0px;
        width: 90%;
      }

      .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>

  <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>

</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'] == '') ? 'electra.jpg' : $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>
          <span class="f11"><span class="f12">From:</span> <?php echo $_SESSION['gst_from_date'] ?> - <span class="f12">To:</span> <?php echo $_SESSION['gst_to_date']; ?></span>
          <div class="cdate f11"><span class="f12">Date:</span><?php echo date('d/m/Y'); ?> | <span class="f12">Time:</span> <?php echo date('h:i:s a'); ?></div>
        </div>
        <h2>GST Sales Summary</h2>
      </div>
      <div class="right"></div>
    </div>


    <div class="div_second">
      <div class="panel">
        <table width="100%" cellpadding="3" cellspacing="0" border="0">
          <thead>
            <tr>
              <th width="25%" rowspan="2">Store</th>
              <th width="25%" colspan="3" style="text-align:center;">GST @ 5%</th>
              <th width="25%" colspan="3" style="text-align:center;">GST @ 12%</th>
              <th width="25%" colspan="3" style="text-align:center;">GST @ 18%</th>
              <th rowspan="2" style="text-align:center;">Total TurnOver</th>
            </tr>
            <tr>
              <th width="8%" style="text-align:center;">TurnOver</th>
              <th width="8%" style="text-align:center;">SGST</th>
              <th width="8%" style="text-align:center;">CGST</th>
              <th width="8%" style="text-align:center;">TurnOver</th>
              <th width="8%" style="text-align:center;">SGST</th>
              <th width="8%" style="text-align:center;">CGST</th>
              <th width="8%" style="text-align:center;">TurnOver</th>
              <th width="8%" style="text-align:center;">SGST</th>
              <th width="8%" style="text-align:center;">CGST</th>
            </tr>
          </thead>
          <tbody>
            <?php
            $GetRecord = $_SESSION['gst_sales_summary'];
            $result = mysqli_query($link1, $GetRecord);
            $i = 1;
            while ($in_fetch = mysqli_fetch_array($result)) {
            ?>
              <tr>
                <td><?php echo $in_fetch['store_desc']; ?></td>
                <td style="word-break:break-all;"><?php $GetRecord_five_per = mysqli_fetch_array(mysqli_query($link1, "SELECT sum(di.amount) as tot_amt,sum(tax_rate_amount) as tot_tax_amount,sum(di.sgst) as tot_sgst,sum(di.cgst) as tot_cgst FROM drugissues d
INNER JOIN drugissue_details di ON d.id=di.drugissue_id where " . $_SESSION['filter3'] . " and d.store_code='" . $in_fetch['store_code'] . "' and di.tax_rate='5.00' "));
                                                  echo $GetRecord_five_per['tot_amt'];
                                                  $turnover_five[] = $GetRecord_five_per['tot_amt'];

                                                  $sgst_five_per = $GetRecord_five_per['tot_tax_amount'] / 2;
                                                  $cgst_five_per = $GetRecord_five_per['tot_tax_amount'] / 2;
                                                  ?></td>
                <td><?php echo number_format((float)$sgst_five_per, 2, '.', '');
                    $sgst_five[] = $sgst_five_per; ?></td>
                <td style="word-break:break-all;"><?php echo number_format((float)$cgst_five_per, 2, '.', '');
                                                  $cgst_five[] = $cgst_five_per;  ?></td>
                <td><?php $GetRecord_twelve_per = mysqli_fetch_array(mysqli_query($link1, "SELECT sum(di.amount) as tot_amt,sum(tax_rate_amount) as tot_tax_amount,sum(di.sgst) as tot_sgst,sum(di.cgst) as tot_cgst FROM drugissues d
INNER JOIN drugissue_details di ON d.id=di.drugissue_id where " . $_SESSION['filter3'] . " and d.store_code='" . $in_fetch['store_code'] . "' and di.tax_rate='12.00' "));
                    echo $GetRecord_twelve_per['tot_amt'];
                    $turnover_twelve[] = $GetRecord_twelve_per['tot_amt'];

                    $sgst_twelve_per = $GetRecord_twelve_per['tot_tax_amount'] / 2;
                    $cgst_twelve_per = $GetRecord_twelve_per['tot_tax_amount'] / 2;

                    ?></td>
                <td style="text-align:center;"><?php echo number_format((float)$sgst_twelve_per, 2, '.', '');
                                                $twelve_sgst[] = $sgst_twelve_per; ?></td>
                <td style="text-align:center;"><?php echo number_format((float)$cgst_twelve_per, 2, '.', '');
                                                $twelve_cgst[] = $cgst_twelve_per; ?></td>
                <td><?php $GetRecord_eighteen_per = mysqli_fetch_array(mysqli_query($link1, "SELECT sum(di.amount) as tot_amt,sum(tax_rate_amount) as tot_tax_amount,sum(di.sgst) as tot_sgst,sum(di.cgst) as tot_cgst FROM drugissues d
INNER JOIN drugissue_details di ON d.id=di.drugissue_id where " . $_SESSION['filter3'] . " and d.store_code='" . $in_fetch['store_code'] . "' and di.tax_rate='18.00' "));
                    echo $GetRecord_eighteen_per['tot_amt'];
                    $turnover_eighteen[] = $GetRecord_eighteen_per['tot_amt'];

                    $sgst_eighteen_per = $GetRecord_eighteen_per['tot_tax_amount'] / 2;
                    $cgst_eighteen_per = $GetRecord_eighteen_per['tot_tax_amount'] / 2;
                    ?></td>
                <td style="text-align:center;"><?php echo number_format((float)$sgst_eighteen_per, 2, '.', '');
                                                $eighteen_sgst[] = $sgst_eighteen_per; ?></td>
                <td style="text-align:center;"><?php echo number_format((float)$cgst_eighteen_per, 2, '.', '');
                                                $eighteen_cgst[] = $cgst_eighteen_per; ?></td>
                <td style="text-align:right;"><?php echo $GetRecord_five_per['tot_amt'] + $GetRecord_twelve_per['tot_amt'] + $GetRecord_eighteen_per['tot_amt'];
                                              $store_total[] = $GetRecord_five_per['tot_amt'] + $GetRecord_twelve_per['tot_amt'] + $GetRecord_eighteen_per['tot_amt']; ?></td>
              </tr><?php $i++;
                  } ?>
            <tr>
              <td style="text-align:right;"><strong>Total</strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($turnover_five)) {
                                                      echo number_format((float)array_sum($turnover_five), 2, '.', ',');
                                                    } else {
                                                      echo "0.00";
                                                    } ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($sgst_five)) {
                                                      echo array_sum($sgst_five);
                                                    } else {
                                                      echo "0.00";
                                                    } ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($cgst_five)) {
                                                      echo array_sum($cgst_five);
                                                    } else {
                                                      echo "0.00";
                                                    } ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($turnover_twelve)) {
                                                      echo number_format((float)array_sum($turnover_twelve), 2, '.', ',');
                                                    } else {
                                                      echo "0.00";
                                                    } ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($twelve_sgst)) {
                                                      echo array_sum($twelve_sgst);
                                                    } else {
                                                      echo "0.00";
                                                    }  ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($twelve_cgst)) {
                                                      echo array_sum($twelve_cgst);
                                                    } else {
                                                      echo "0.00";
                                                    }  ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($turnover_eighteen)) {
                                                      echo number_format((float)array_sum($turnover_eighteen), 2, '.', ',');
                                                    } else {
                                                      echo "0.00";
                                                    } ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($eighteen_sgst)) {
                                                      echo array_sum($eighteen_sgst);
                                                    } else {
                                                      "0.00";
                                                    }  ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($eighteen_cgst)) {
                                                      echo array_sum($eighteen_cgst);
                                                    } else {
                                                      "0.00";
                                                    }  ?></strong></td>
              <td style="text-align:right;"><strong><?php if (!empty($store_total)) {
                                                      echo array_sum($store_total);
                                                    } else {
                                                      echo "0.00";
                                                    }  ?></strong></td>
            </tr>
          </tbody>
        </table>

      </div>
    </div>

</body>

</html>