-
Notifications
You must be signed in to change notification settings - Fork 0
/
myspend.php
535 lines (226 loc) · 7.8 KB
/
myspend.php
1
<?php/** * Created by PhpStorm. * User: WsKLab * Date: 10/6/2016 * Time: 4:20 PM */session_start();if(!isset($_SESSION['mysession'])){header('location:index.php');}/*This is the detail page */?><?php require_once('template/head.php'); ?>}</style> </head><body><div class="container-fluid"> <?php require_once('template/nav.php'); require_once('class/Person.php'); ?> <div> <table class="table table-hover table-responsive"><colgroup> <col span="5" style="background-color:yellow"> <col style="background-color:beige"> <col style="background-color:#f1fff8"> <col style="background-color:darkorange"> <col style="background-color:#febbff"> <col style="background-color:rgba(76, 175, 219, 0.31)"> <col style="background-color:rgba(116, 219, 18, 0.31)"> <col style="background-color:rgba(219, 128, 131, 0.31)"> <col style="background-color:rgba(184, 131, 219, 0.31)"> <col style="background-color:rgba(154, 219, 26, 0.31)"> <col style="background-color:rgba(219, 206, 133, 0.31)"> <col style="background-color:rgba(150, 200, 130, 0.31)"> <col style="background-color:rgba(140, 150, 120, 0.31)"> <col style="background-color:rgba(104, 184, 102, 0.31)"> </colgroup> <tr> <th> No </th> <th> Date </th> <th> Item Name</th> <th>Paid Person </th> <th>Amount</th> <th>Wsk Share</th> <th>Imd Share</th> <th>Brk Share</th> <th>Ijz Share</th> <th>nwb Share</th> <th>isn Share</th> <th>jal Share</th> <th>kas Share</th> <th>nsr Share</th> <!--Change one T3--> <th>isr Share</th> <th>nwbc Share</th> <th>ans Share</th><th>mua Share</th><th>isq Share</th><th>asf Share</th><th>irf Share</th><th>nae Share</th><th>wzr Share</th> <th>Select</th> </tr> <?php if(isset($_GET['work'])){ $id=$_GET['id']; $evdate=$_GET['edate']; $d=date_difference($evdate,$actor); $q="UPDATE bills SET status=3,actor='$actor' WHERE no=$id"; if($d<1){ mysqli_query($con,$q)or die('error in delete'); } else{ echo '<h2 class="bg-danger text-center"> Not allowed after one day </h2>'; } }//function is defined in sandbox.$no_of_record=select_one_col($con,"setting","records",$actor);$num_rec_per_page=$no_of_record;if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };$start_from = ($page-1) * $num_rec_per_page; //$q="SELECT * FROM bills WHERE status=1 AND $shareholdser>0 ORDER BY no DESC LIMIT $start_from,$num_rec_per_page"; $q="SELECT * FROM bills WHERE status=1 AND $shareholdser>0 ORDER BY no DESC LIMIT $start_from,$num_rec_per_page";$exe=mysqli_query($con,$q);$i=1; while($exer=mysqli_fetch_assoc($exe)){$p=$exer['paid_person'];if($p=="waqas"){echo '<tr class="">';}else if($p=="ijaz"){echo '<tr class="">';}else if($p=="barkat"){echo '<tr class="">';}else if($p=="imdad"){echo '<tr class="">';}else if($p=="nawab"){echo '<tr class="">';}else if($p=="ihsan"){echo '<tr class="">'; }else if($p=="jalil"){echo '<tr class="">'; } else if($p=="kashif"){echo '<tr class="">'; } else if($p=="nasar"){ echo '<tr class="">'; } //chage two T4 else if($p=="israr"){ echo '<tr class="">'; } else if($p=="nawabc"){ echo '<tr class="">'; } else if($p=="ansar"){ echo '<tr class="">'; } else if($p=="mehboob"){ echo '<tr class="">'; } else if($p=="mushtaq"){ echo '<tr class="">'; } else if($p=="ishaq"){ echo '<tr class="">'; }else if($p=="asif"){ echo '<tr class="">'; }/*label area code starts*/ $amount=$exer['paid_amount']; $wsk_share=$exer['wsk_share']."<br>"; $ijz_share=$exer['ijz_share']."<br>"; $imd_share=$exer['imd_share']."<br>"; $brk_share=$exer['brk_share']."<br>"; $nwb_share=$exer['nwb_share']."<br>"; $isn_share=$exer['isn_share']."<br>"; $jal_share=$exer['jal_share']."<br>"; $kas_share=$exer['kas_share']."<br>"; $nsr_share=$exer['nsr_share']."<br>"; // chage three T5 $isr_share=$exer['isr_share']."<br>"; $nwbc_share=$exer['nwbc_share']."<br>"; $ans_share=$exer['ans_share']."<br>"; $mhb_share=$exer['mhb_share']."<br>"; $mus_share=$exer['mus_share']."<br>"; $isq_share=$exer['isq_share']."<br>"; $asf_share=$exer['asf_share']."<br>"; $irf_share=$exer['irf_share']."<br>"; $nae_share=$exer['nae_share']."<br>"; $wzr_share=$exer['wzr_share']."<br>"; //for calution of one share i neeed the sum of all shares; //change four T6 $ts=$sh->total_share($wsk_share,$ijz_share,$imd_share,$brk_share,$nwb_share,$isn_share,$jal_share,$kas_share,$nsr_share,$isr_share,$nwbc_share,$ans_share,$mhb_share,$mus_share,$isq_share,$asf_share,$irf_share,$nae_share,$wzr_share); $one_share=$sh->one_share_price($amount,$ts);/*lable area code ends*/ // change five T7 echo '<td> '.$i.'</td> <td>'.$exer['eventdate'].'</td> <td>'.$exer['item_name'].'</td> <td>'.$p.'</td> <td>'.$exer['paid_amount'].'</td> <td>'.$wsk_share.' <span class="label label-success">'.round($wsk_share*$one_share,1).'</span></td> <td>'.$imd_share.' <span class="label label-success">'.round($imd_share*$one_share,1).'</span></td> <td>'.$brk_share.' <span class="label label-success">'.round($brk_share*$one_share,1).'</span></td> <td>'.$ijz_share.' <span class="label label-success">'.round($ijz_share*$one_share,1).'</span></td> <td>'.$nwb_share.' <span class="label label-success">'.round($nwb_share*$one_share,1).'</span></td> <td>'.$isn_share.' <span class="label label-success">'.round($isn_share*$one_share,1).'</span></td> <td>'.$jal_share.' <span class="label label-success">'.round($jal_share*$one_share,1).'</span></td> <td>'.$kas_share.' <span class="label label-success">'.round($kas_share*$one_share,1).'</span></td> <td>'.$nsr_share.' <span class="label label-success">'.round($nsr_share*$one_share,1).'</span></td> <td>'.$isr_share.' <span class="label label-success">'.round($isr_share*$one_share,1).'</span></td> <td>'.$nwbc_share.' <span class="label label-success">'.round($nwbc_share*$one_share,1).'</span></td> <td>'.$ans_share.' <span class="label label-success">'.round($ans_share*$one_share,1).'</span></td> <td>'.$mhb_share.' <span class="label label-success">'.round($mhb_share*$one_share,1).'</span></td> <td>'.$mus_share.' <span class="label label-success">'.round($mus_share*$one_share,1).'</span></td> <td>'.$isq_share.' <span class="label label-success">'.round($isq_share*$one_share,1).'</span></td> <td>'.$asf_share.' <span class="label label-success">'.round($asf_share*$one_share,1).'</span></td> <td>'.$irf_share.' <span class="label label-success">'.round($irf_share*$one_share,1).'</span></td> <td>'.$nae_share.' <span class="label label-success">'.round($nae_share*$one_share,1).'</span></td> <td>'.$wzr_share.' <span class="label label-success">'.round($wzr_share*$one_share,1).'</span></td> '. $a=$exer['actor'];if($actor==$a){echo '<td> <a href="edit.php?id='.$exer['no'].'"class="btn btn-info btn-xs">Edit </a> <a href="spend.php?work=del&id='.$exer['no'].'&edate='.$exer['eventdate'].'"class="btn btn-danger btn-xs align-right">Delete</a> </td>';}else{}echo' <tr>';$i++; }?> </table> </div> <div ><?php $sql = "SELECT * FROM bills where status=1 AND $shareholdser>0";$rs_result = mysqli_query($con,$sql); //run the query$total_records = mysqli_num_rows($rs_result); //count number of records$total_pages = ceil($total_records / $num_rec_per_page);echo'<ul class="pagination pagination-lg">';for($i=1; $i<=$total_pages; $i++) { echo '<li><a href="myspend.php?page='.$i.'">'.$i.'</a></li>'; }echo'</ul>';?></div> <?php require_once('template/foot.php'); ?>