EVOLUTION-NINJA
Edit File: client_bidding_report_new.php
<?php $this->load->view('includes/client_header');?> <section class="mid_work_one"> <div class="container"> <!-- <div class="row mid_container"> <form class="form-horizontal"> <div class="list_table"> <div class="table-responsive"> <table class="table"> <thead> <tr> <th>Sl No</th> <th>Bidding Title</th> <th>Date</th> <th>Time</th> <th>Action</th> </tr> </thead> <tbody> <?php foreach ($bidding as $key => $value) { ?> <tr class="row<?php echo $value->bidding_session_id; ?>"> <td><?php echo $key+1;?></td> <td><a href="<?php echo base_url('/edit-session'); ?>/<?php echo $value->bidding_session_id; ?>"><?php echo $value->bidding_title; ?></a></td> <?php if($value->final_bidding_date!='0000-00-00'){ ?> <td><?php echo Date('d M Y', strtotime($value->final_bidding_date)); ?></td> <?php } else { ?> <td></td> <?php } ?> <td><?php echo $value->bidding_time; ?></td> <td><span class="fa fa-trash" onclick="delete_iadmin(<?php echo $value->bidding_session_id;?>);" aria-hidden="true"></span>  </td> </tr> <?php } ?> </tbody> </table> </div> </div> </form> </div> --> <div class="row row_no"> <h4 class="info_text">Report</h4> <form class="form-horizontal"> <div class="row"> <div class="col-sm-9"> <div class="table-responsive"> <table class="table table1 text-nowrap" style="width: 50%;"> <tr> <td style="width: 28%;">Event Name:</td> <td style="width: 60%;"><?php echo $bid->bidding_title; ?></td> </tr> <tr> <td>Event Date:</td> <td><?php echo date('d F Y',strtotime($bid->final_bidding_date)); ?></td> </tr> <tr> <td>No. of Bidders:</td> <td><?php echo $vendor; ?></td> </tr> </table> </div> </div> <div class="col-sm-3"> <button type="button" style="float:right;" onclick="doit('xlsx')"; class="btn btn-primary">Export</button> </div> </div> <div class="table-responsive"> <table class="table prio_table" id="headerTable"> <thead> <tr> <th>#</th> <th>Product Name</th> <th>Specification</th> <th>Quantity</th> <th>Final Prices</th> <th>Vendor Name</th> <th>Contact Person</th> <th>Email</th> <th>Mobile</th> </tr> </thead> <tbody> <?php foreach($item as $key => $value) { $lent=count($value['price']); $len=$lent+1; ?> <tr> <td ><?php echo $key+1; ?></td> <td><?php echo $value['item_name']; ?></td> <td ><?php echo $value['specification']; ?></td> <td><?php echo $value['quantity']; ?></td> <td class=""> <?php echo $value['price'];?> </td> <td class=""> <?php echo $value['vendor']->company_name; ?> </td> <td class=""> <?php echo $value['vendor']->first_name; ?> </td> <td class=""> <?php echo $value['vendor']->email; ?> </td> <td class=""> <?php echo $value['vendor']->mobile_no; ?> </td> </tr> <?php } ?> </tbody> </table> </div> </form> </div> </section> </body> </html> <script type="text/javascript" src="<?php echo base_url('assets/js/shim.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/xlsx.full.min.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/Blob.js');?>"></script> <script type="text/javascript" src="<?php echo base_url('assets/js/FileSaver.js');?>"></script> <script> function doit(type, fn, dl) { var elt = document.getElementById('headerTable'); var wb = XLSX.utils.table_to_book(elt, {sheet:"Sheet JS"}); return dl ? XLSX.write(wb, {bookType:type, bookSST:true, type: 'base64'}) : XLSX.writeFile(wb, fn || ('vendor.' + (type || 'xlsx'))); } </script> <script type="text/javascript"> function tableau(pid, iid, fmt, ofile) { if(typeof Downloadify !== 'undefined') Downloadify.create(pid,{ swf: 'downloadify.swf', downloadImage: 'download.png', width: 100, height: 30, filename: ofile, data: function() { return doit(fmt, ofile, true); }, transparent: false, append: false, dataType: 'base64', onComplete: function(){ alert('Your File Has Been Saved!'); }, onCancel: function(){ alert('You have cancelled the saving of this file.'); }, onError: function(){ alert('You must put something in the File Contents or there will be nothing to save!'); } }); else document.getElementById(pid).innerHTML = ""; } tableau('biff8btn', 'xportbiff8', 'biff8', 'test.xls'); tableau('odsbtn', 'xportods', 'ods', 'test.ods'); tableau('fodsbtn', 'xportfods', 'fods', 'test.fods'); tableau('xlsbbtn', 'xportxlsb', 'xlsb', 'test.xlsb'); tableau('xlsxbtn', 'xportxlsx', 'xlsx', 'test.xlsx'); </script> <style type="text/css"> .table-responsive { /*overflow-x: hidden !important;*/ } @media only screen and (min-width:992px) and (max-width:1258px) { .table-responsive { /*overflow-x: initial !important;*/ } } .prio_table { border-bottom:1px solid #61b79c; } .price_td { padding: 0px !important; } .price_td p { margin: 0 0 0px !important; border-bottom:1px solid #555; padding-top: 5px; padding-bottom: 5px; text-align: center; } .table1 { margin-left: 3%; } .table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th { border-top: 1px solid #ddd !important; } .prio_table>tbody>tr>td, .prio_table>tbody>tr>th, .prio_table>tfoot>tr>td, .prio_table>tfoot>tr>th, .prio_table>thead>tr>td, .prio_table>thead>tr>th { border-top: 1px solid #61b79c !important; } .table1>tbody>tr>td, .table1>tbody>tr>th, .table1>tfoot>tr>td, .table1>tfoot>tr>th, .table1>thead>tr>td, .table1>thead>tr>th { border-top: 0px solid transparent !important; } </style>