<? include "top.php"; ?>
<!DOCTYPE html>
<html>
   <head>
      <?php include('include/head.php'); 
         $stdt=$_POST['stdt'];
         $enddt=$_POST['enddt'];
         $customer=$_POST['customer'];
         
         $name=mysqli_real_escape_string($con,$_POST['search']);
            $custid=mysqli_real_escape_string($con,$_REQUEST['custid']);
            //echo "SELECT * FROM `adduser` WHERE name='$name' OR custid='$custid' AND is_cable='1'";
            $getcust=f(q("SELECT * FROM `adduser` WHERE id='$custid' AND is_cable='1'"));
            $getcomp=f(q("SELECT * FROM tbl_company WHERE c_id='6'"));
         ?>
      <title>Cable Printer Form </title>
      <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css" integrity="sha512-DTOQO9RWCH3ppGqcWaEA1BIZOC6xxalwEsw9c2QQeAIftl+Vegovlnee1c9QX4TctnWMn13TZye+giMm8e2LwA==" crossorigin="anonymous" referrerpolicy="no-referrer" />
      <style type="text/css">
         th{
         font-size: 14px !important;
         padding: 5px;
         }
         td{
         font-size: 14px !important;
         }
         table{

            width: 100%;

         }
         tr{

            width: 100%;
         }
         thead > tr > td{
            background-color: #bad5e4;

         }

         .ptop30{
            padding-top:30px;

         }
         .box{

            border:1px solid black;
            height:40px;
            width:40px;
         }
         .picbox{

            border:1px solid black;
            height:250px;
            width:200px;
         }

      </style>
   </head>
   <body style="background-color: white; padding: 1% 3%;">
   
   <br><center><h2><?php echo $getcomp['c_name']?></h2></center>
   <center><?php echo $getcomp['c_address']?> | Phone: <?php echo $getcomp['c_phone']?> | Office: <?php echo $getcomp['c_mobile']?></center>
   <br><div style="width:100%;border-bottom:1px solid black;"></div><br><br>
      <table class="stripe">
        
         <tbody>
            <tr>
                <td>
                    <table>
                        <tr>
                            <td style="width:20%;">
                                <b>Applicants Name: </b> 
                            </td>
                            <td style="border-bottom:1px solid black;">
                                : <?php echo $getcust['name']?>
                            </td>
                            <td  style="width:10%;text-align:right;">
                                <b>Age:</b>
                            </td>
                            <td  style="width:10%;border-bottom:1px solid black;">
                                
                            <?php echo $getcust['cage']?>
                            </td>
                        </tr>
                        <tr >
                            <td style="width:20%;padding-top:30px;">
                                <b>Installation Address: </b> 
                            </td>
                            <td style="border-bottom:1px solid black;" colspan="3">
                                :  <?php echo $getcust['address']?>
                            </td>
                           
                        </tr>
                        <tr>
                            <td style="width:20%;padding-top:30px;">
                                <b>Telephone / Mobile No: </b> 
                            </td>
                            <td style="border-bottom:1px solid black;">
                                :  <?php echo $getcust['phone']?>
                            </td>
                            <td  style="width:20%;text-align:right;">
                                <b>Email Id</b>
                            </td>
                            <td  style="width:30%;border-bottom:1px solid black;">
                                : <?php echo $getcust['email']?>
                            </td>
                        </tr>
                        
                    </table>
                </td>
                <td style="width:300px;">
                    <div class="picbox"></div><br><br>
                </td>
            </tr> 
            <tr>
                <td>
                        <table>
                            <tr>
                            <td style="width:20%;">
                                <b>Address Proof: Passport </b> 
                                <?php 

                                $getp=mysqli_query($con,"SELECT * FROM tbl_docs WHERE d_cid='$custid'");
                                while($arrp=mysqli_fetch_array($getp)){

                                    if($arrp['d_type']=='1'){

                                        $agreement=1;
                                    }elseif($arrp['d_type']=='2'){

                                        $adhaar=1;
                                    }elseif($arrp['d_type']=='3'){

                                        $pan=1;
                                    }elseif($arrp['d_type']=='4'){

                                        $voter=1;
                                    }elseif($arrp['d_type']=='5'){

                                        $gstdoc=1;
                                    }elseif($arrp['d_type']=='6'){

                                        $profimg=1;
                                    }elseif($arrp['d_type']=='7'){

                                        $bankpass=1;
                                    }elseif($arrp['d_type']=='8'){

                                        $passpo=1;
                                    }elseif($arrp['d_type']=='9'){

                                        $otherd=1;
                                    }



                                }
                                
                                
                                ?>
                            </td>
                            <td style="width:5%;">
                            <div class="box"><?php if($passpo==1){?><i class="fa fa-check"></i> <?php } ?></div>
                            </td>
                            <td  style="width:20%;text-align:right;">
                                <b>Voter Id&nbsp;</b>
                            </td>
                            <td  style="width:5%;">
                            <div class="box"><?php if($voter==1){?><i class="fa fa-check"></i> <?php } ?></div>
                            </td>
                            <td  style="width:20%;text-align:right;">
                                <b>Bank Passbook&nbsp;</b>
                            </td>
                            <td  style="width:5%;">
                            <div class="box"><?php if($bankpass==1){?><i class="fa fa-check"></i> <?php } ?></div>
                            </td>
                            </tr>
                        </table>
                </td>
                <td>
                        <table>
                            <tr>
                            
                            <td  style="width:20%;text-align:right;">
                                <b>Adhaar Card&nbsp;</b>
                            </td>
                            <td  style="width:5%;min-height:20px;">
                            <div class="box"><?php if($adhaar==1){?><i class="fa fa-check"></i> <?php } ?></div>
                            </td>
                            <td  style="width:20%;text-align:right;">
                                <b>Others&nbsp;</b>
                            </td>
                            <td  style="width:5%;">
                            <div class="box"><?php if($otherd==1){?><i class="fa fa-check"></i> <?php } ?></div>
                            </td>
                            </tr>
                        </table>

                </td>
                            
                          
                        </tr>     
         </tbody>
      </table>
      <br><div style="width:100%;border-bottom:1px solid black;"></div><br><br>
      <center><h2>Internet</h2></center><br>
      <table>
        <tr>
            <td>
                Material Price
            </td>
            <td>

            </td>
            <td>
                <b>Free</b>
            </td>
            <td>
                <b>Discount</b>
            </td>
            <td>
                <b>Amount</b>
            </td>
        </tr>
        <tr>
            <td>
                Xpon Device Rs.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:15%;border:1px solid black;">
                
            </td>
            <td style="width:15%;border:1px solid black;">
                
            </td>
            <td style="width:15%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td>
                Fibre per metre.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td>
                Piktel Rs.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td>
                TGP Box Rs.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td>
                Installation Rs.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td>
                Normal Router Rs.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td>
                Xpon Device Rs.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td>
                Gigabyte Router Rs.
            </td>
            <td>
                ______________________________
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>
            <td style="width:5%;border:1px solid black;">
                
            </td>

        </tr>
        <tr>
            <td class="ptop30">
                <b>Package</b>
            </td>
            <td colspan="2" class="ptop30">
                Name
            </td>
            <td style="width:5%;" class="ptop30">
                Discount
            </td>
            <td style="width:5%;" class="ptop30">
                Amount
            </td>
            

        </tr>
        <tr>
            <td class="ptop30">
                
            </td>
            <td colspan="2"  style="border-bottom:1px solid black;padding:0% 2%;" class="ptop30">
                
            </td>
            <td style="padding:0% 2%;" class="ptop30">
            <div class="box"></div>
            </td>
            <td style="padding:0% 2%;" class="ptop30">
            <div class="box"></div>
            </td>
            

        </tr>
      </table>
      <br><div style="width:100%;border-bottom:1px solid black;"></div><br><br>
      <center><h2>C.A. Cable (Cable T.V.)</h2></center><br>
      <table>
        <tr>
            <td>
            
            </td>
            <td>

            </td>
            <td>
                <b>Free</b>
            </td>
            <td>
                <b>Discount</b>
            </td>
            <td>
                <b>Amount</b>
            </td>
        </tr>
        <tr>
            <td>
            Normal Box Setup box rs.
            </td>
            <td>
            <?php echo $getcust['normalstb_pr']?>
            </td>
            <td style="width:15%;border:1px solid black;">
            <?php echo $getcust['normalstb_free']?>
            </td>
            <td style="width:15%;border:1px solid black;">
            <?php echo $getcust['normalstb_disc']?>
            </td>
            <td style="width:15%;border:1px solid black;">
            <?php echo $getcust['normalstb_amt']?>
            </td>

        </tr>
        <tr>
            <td>
                HD Rs.
            </td>
            <td>
            <?php echo $getcust['hdbox_pr']?>
            </td>
            <td style="width:15%;border:1px solid black;">
            <?php echo $getcust['hdbox_free']?>
            </td>
            <td style="width:15%;border:1px solid black;">
            <?php echo $getcust['hdbox_disc']?>
            </td>
            <td style="width:15%;border:1px solid black;">
            <?php echo $getcust['hdbox_amt']?>
            </td>

        </tr>
        <tr>
            <td>
                RD Six Coax Cable.
            </td>
            <td>
            <?php echo $getcust['rg_pr']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['rg_free']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['rg_disc']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['rg_amt']?>
            </td>

        </tr>
        <tr>
            <td>
                NUT & RING Rs.
            </td>
            <td>
            <?php echo $getcust['nut_pr']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['nut_free']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['nut_disc']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['nut_amt']?>
            </td>

        </tr>
        <tr>
            <td>
                Installation Rs.
            </td>
            <td>
            <?php echo $getcust['inst_pr']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['inst_free']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['inst_disc']?>
            </td>
            <td style="width:5%;border:1px solid black;">
            <?php echo $getcust['inst_amt']?>
            </td>

        </tr>
        <tr>
            <td class="ptop30">
               <b> Package</b>
            </td>
            <td colspan="2" class="ptop30">
                Name
            </td>
            <td style="width:5%;" class="ptop30">
                Discount :
            </td>
            <td style="width:5%;" class="ptop30">
                Amount: 
            </td>
            

        </tr>
        <tr>
            <td class="ptop30">
                
            </td>
            <td colspan="2"  style="border-bottom:1px solid black;padding:0% 2%;" class="ptop30">
                
            </td>
            <td style="padding:0% 2%;" class="ptop30">
            <div class="box"> <?php echo $getcust['discounts']?></div>
            </td>
            <td style="padding:0% 2%;" class="ptop30">
            <div class="box"><?php echo $getcust['price']?></div>
            </td>
            

        </tr>
        
      </table>
      <table>
        <tr>
            <td>
                <h4>Payment: </h4>
            </td>
            <td style="width:50px;padding-top:15px;"><br>Online: &nbsp;&nbsp;&nbsp;</td>
            <td>
                &nbsp;&nbsp;&nbsp;<div class="box"></div>
            </td>
            <td style="width:50px;padding-top:15px;"><br>Offline: &nbsp;&nbsp;&nbsp;</td>
            <td>
                &nbsp;&nbsp;&nbsp;<div class="box"></div>
            </td>
        </tr>
      </table>
      <table>
        <tr>
            <td>
                1. We provide <b>Prepaid Connection </b> so all the customers are requested to <b>make the payment before 24 hours</b><br>
                2. <b>Just in case if you can't pay monthly subscription amount on time, No problem! Just inform to us we will recharge but you have to pay within 24 hours after recharge.</b><br>
                3. For online payment, please send us the screenshot of your successfull transaction.<br>
                4. Installation charge is not refundable. <br>
                5. If you wish to <b>discontinue</b> our services please inform it before <b>2 days</b> or else you will have to <b>pay</b> for the <b>entire month</b><br>
                6. 50% amount will be returned on returning ONU/Router/Settop Box (<small>* T & C Apply</small>)<br>
                7. If somehow the previous month's amount is due, then during the next month's recharge, the full amount must be paid only then the recharge will be done. 
            </td>
           
        </tr>
      </table>

      <br>
      
      <br><br>

<script>
    window.print();
</script>
      <?php //include('include/script.php'); ?>
      
   </body>
</html>

