Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/report/person/ drwxr-xr-x |
Viewing file: Select action/file-type: <?php include 'include/controllerAc.php'; $YearCount=$_GET['YearCount']; $id=$_GET['id']; $case=$_GET['case']; $no=1; //จำนวนชั่วโมงวิชาการ(พัฒนาภายใน) if($case==1){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_in<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_in<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาชีพ(พัฒนาภายใน) if($case==2){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายใน) if($case==3){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาการ(พัฒนาภายนอก) ใช้งบ if($case==4){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0 AND ac_money<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0 AND ac_money<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอก) ใช้งบ if($case==5){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0 AND pr_money<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0 AND pr_money<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอก) ใช้งบ if($case==6){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND moral_money<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND moral_money<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาการ(พัฒนาภายนอกไม่ใช้งบ) if($case==7){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอกไม่ใช้งบ) if($case==8){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } //จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอกไม่ใช้งบ) if($case==9){ $query1 = "SELECT * FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 "; $result1 = $conn->query($query1); $query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9 FROM v_report WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 "; $result3 = $conn->query($query3); while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);} } $query2 = "SELECT * FROM persontb WHERE personCode=$id "; $result2 = $conn->query($query2); while($values = $result2->fetch_assoc()){$name=$values['name']." ".$values['surName'];} ?> <!DOCTYPE HTML> <html> <head> <meta charset="UTF-8"> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous"> <link rel="preconnect" href="https://fonts.gstatic.com"> <link href="https://fonts.googleapis.com/css2?family=Niramit&display=swap" rel="stylesheet"> <style> body { font-family: 'Niramit', sans-serif; font-size: 12px; } </style> </head> <body> <table class="table table-striped"> <thead class="thead-dark"> <tr> <th colspan="13"><center>ข้อมูลจำนวนชั่วโมงวิชาการวิชาชีพและคุณธรรมจริยธรรม จำแนกตามปีการศึกษา <?=$YearCount?> ของ <?=$name?></center></th> </tr> <tr> <th class="text-center" width="5%">ครั้งที่</th> <th class="text-left" width="30%">ชื่อโครงการที่เข้าร่วม</th> <th class="text-center">เริ่มต้น</th> <th class="text-center">สิ้นสุด</th> <th class="text-center">ชม.วก.</th> <th class="text-center">ชม.วช.</th> <th class="text-center">ชม.คธ.</th> <th class="text-right">เงิน วก.</th> <th class="text-right">เงิน วช.</th> <th class="text-right">เงิน คธ.</th> <th class="text-right">รวมเงิน</th> <th class="text-center">รวมชั่วโมง</th> <th class="text-center">% รายโครงการ</th> </tr> </thead> <tbody> <?php $no=1; $sumary1=0; $sumary2=0; $sumary3=0; $sumary4=0; $sumary5=0; $sumary6=0; $sumary7=0; $sumary8=0; while($res1 = $result1->fetch_assoc()){ ?> <tr> <td class="text-center"><?=$no?></td> <td class="text-left"><?=$res1['projectName']?></td> <td class="text-center"><?=DateThai($res1['start'])?></td> <td class="text-center"><?=DateThai($res1['end'])?></td> <td class="text-center"><?=number_format($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out'])?></td> <td class="text-center"><?=number_format($res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out'])?></td> <td class="text-center"><?=number_format($res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out'])?></td> <td class="text-right"><?=number_format($res1['ac_money'])?></td> <td class="text-right"><?=number_format($res1['pr_money'])?></td> <td class="text-right"><?=number_format($res1['moral_money'])?></td> <td class="text-right"><?=number_format(($res1['ac_money']+$res1['pr_money']+$res1['moral_money']),2)?></td> <td class="text-center"><?=number_format(($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out']),2)?></td> <td class="text-center"><?=number_format((($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out'])/$sumAll)*100,2)?>%</td> </tr> <?php $no++; $sumary1+=$res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']; $sumary2+=$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']; $sumary3+=$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out']; $sumary4+=$res1['ac_money']; $sumary5+=$res1['pr_money']; $sumary6+=$res1['moral_money']; $sumary7+=($res1['ac_money']+$res1['pr_money']+$res1['moral_money']); $sumary8+=($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out']); } ?> <tr> <td class="text-right" colspan="4"><b>รวมทั้งหมด</b></td> <td class="text-center"><?=number_format($sumary1,2)?></td> <td class="text-right"><?=number_format($sumary2,2)?></td> <td class="text-right"><?=number_format($sumary3,2)?></td> <td class="text-right"><?=number_format($sumary4,2)?></td> <td class="text-right"><?=number_format($sumary5,2)?></td> <td class="text-right"><?=number_format($sumary6,2)?></td> <td class="text-right"><?=number_format($sumary7,2)?></td> <td class="text-center"><?=number_format($sumary8,2)?></td> <td class="text-center"></td> </tr> </tbody> </table> </body> </html> <?php function DateThai($strDate) { $strYear = date("Y",strtotime($strDate))+543; $strMonth= date("n",strtotime($strDate)); $strDay= date("j",strtotime($strDate)); $strHour= date("H",strtotime($strDate)); $strMinute= date("i",strtotime($strDate)); $strSeconds= date("s",strtotime($strDate)); $strMonthCut = Array("","ม.ค.","ก.พ.","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค."); $strMonthThai=$strMonthCut[$strMonth]; return "$strDay $strMonthThai $strYear"; } ?> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.006 ]-- |