%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream
<?php include APPPATH.'views/admin/includes/header.php';?> <div id="content-wrapper"> <div class="container-fluid"> <!-- Breadcrumbs--> <ol class="breadcrumb"> <li class="breadcrumb-item"> <a href="<?php echo site_url('admin/Dashboard'); ?>">Dashboard</a> </li> <li class="breadcrumb-item active">Manage Feedback Collection</li> </ol> <!-- DataTables Example --> <div class="card mb-3 fomr-news"> <div class="card-header card-header-new"><h3> <i class="fa fa-users"></i> Feedback Collection Details </h3> <a href="<?=base_url('admin/feedbackcollection/addrecords')?>"> <input type="button" name="button" id="button" value="Add New Feedback"></a> <button style="float:right;" class="btn button2" onclick="tableToExcel('#divId', 'Excel Report')">Excel</Button></div> </div> <div class="card-body"> <div class="main-chart"> <div class="wrapper"> <form method="GET" name="custom_search" action=""> <div class="row"> <div class="col-md-2"> <div class="coarform"> <label>From Date</label> <input type="date" name="search_fromdate" id="search_fromdate" value="<?=$_GET['search_fromdate']?>" class="form-control" /> </div> </div> <div class="col-md-2"> <div class="coarform"> <label>To Date</label> <input type="date" name="search_todate" id="search_todate" value="<?=$_GET['search_todate']?>" class="form-control" /> </div> </div> <div class="col-md-2"> <div class="coarform"> <label>Feedback Type</label> <select name="search_for" id="search_for" class="form-control"> <option value=''>Select Feedback Type</option> <option value='Appreciation' <?php if($_GET['search_for']=='Appreciation') { echo 'selected'; }?>>Appreciation</option> <option value='Suggestion' <?php if($_GET['search_for']=='Suggestion') { echo 'selected'; }?>>Suggestion</option> <option value='Complaint' <?php if($_GET['search_for']=='Complaint') { echo 'selected'; }?>>Complaint</option> <option value='Enquiry' <?php if($_GET['search_for']=='Enquiry') { echo 'selected'; }?>>Enquiry</option> <option value='Feedback' <?php if($_GET['search_for']=='Feedback') { echo 'selected'; }?>>Feedback</option> </select> </div> </div> <div class="col-md-2"> <div class="coarform"> <label>Feedback Source</label> <select name="title" id="title" class="form-control"> <option value=''>Select Source</option> <?php foreach($feedsourceArray as $row) { ?> <option value="<?=$row['id']?>" <?php if($row['id']==$_GET['title']) { echo 'selected'; }?>><?=$row['title']?></option> <?php } ?> </select> </div> </div> <div class="col-md-4"> <div class="coarform"> <label style="display:block;"><br/></label> <input type="submit" class="button2" name="submit" id="submit" value="Search" /> <a href="<?=base_url('admin/feedbackcollection')?>" class="button3">Reset </a> </div> </div> </div> </form> </div> </div> </div> <div class="card-body"> <div class="table-responsive"> <!---- Success Message ----> <?php if ($this->session->flashdata('success')) { ?> <p style="color:green; font-size:18px;"><?php echo $this->session->flashdata('success'); ?></p> </div> <?php } ?> <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0"> <thead> <tr> <th>#</th> <th>Feedback Source</th> <th>Feedback Type</th> <th>Remarks</th> <th>Department</th> <th>Details</th> <th>Date</th> <th>Action</th> </tr> </thead> <tbody> <?php if(count($recordsArray)) : $cnt=1; foreach ($recordsArray as $row) : ?> <tr> <td><?php echo htmlentities($cnt);?></td> <td><?php echo htmlentities($row['title'])?></td> <td> <?php if($row['feedback_type']=='Complaint') { ?> <a href="<?php echo base_url('admin/feedbackcollection/addcomplaint/'.$row['id'])?>" title=""><?php echo htmlentities($row['feedback_type'])?></a> <?php } else { ?> <?php echo htmlentities($row['feedback_type'])?> <?php } ?> </td> <td><?php echo $row['remarks']?></td> <td><?php $deptNewArray = explode(',',$row['department_id']); $multiArray = array(); foreach($deptNewArray as $val) { $multiArray[] = $departmentArray[$val]['department_name']; } echo implode('<b>, </b>',$multiArray); ?></td> <td> <?php if($row['full_name']) { echo 'Name: '.$row['full_name'].'<br/> Email ID: '.$row['email_id'].'<br/> UHID: '.$row['UHID'].'<br/> Contact No.: '.$row['contact_number']; } ?></td> <td><?php echo $row['createdon']; ?></td> <td><?php echo anchor("admin/feedbackcollection/editrecords/{$row['id']}",' ','class="fa fa-edit"')?> <?php if($this->session->userdata('adid')->role_id=='1'){ ?> <a href="<?=base_url('admin/feedbackcollection/deleterecord/'.$row['id'])?>" onclick="return confirm('Are you sure you want to delete this record?');" class="fa fa-trash confirm-delete" > </a> <?php } ?> <?php if($row['feedback_type']=='Complaint') { ?> <?php echo anchor("admin/feedbackcollection/addcomplaint/{$row['id']}",' ','class="fa fa-file"')?> <?php } ?> </td> </tr> <?php $cnt++; endforeach; else : ?> <tr> <td>No Record found</td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <?php endif; ?> </tbody> </table> </div> </div> </div> <!-- /.container-fluid --> <!-- Sticky Footer --> <?php include APPPATH.'views/admin/includes/footer.php';?> <script> var tableToExcel = (function () { var uri = 'data:application/vnd.ms-excel;base64,' , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>' , base64 = function (s) { return window.btoa(unescape(encodeURIComponent(s))) } , format = function (s, c) { return s.replace(/{(\w+)}/g, function (m, p) { return c[p]; }) } return function (table, name) { if (!table.nodeType) table = document.getElementById('dataTable'); var ctx = { worksheet: name || 'Worksheet', table: table.innerHTML } window.location.href = uri + base64(format(template, ctx)) } })() </script>