php - How to get last date from all dates for each student -


i'm making query, takes driving courses students had in period , compares if student has driven courses paid for. need each student, last drives starttime, example - "martin paid 5 courses , in july had last course. did 20 other people. , administrator needs make report, in report, last course last day of fulfillment.

my php

<?php ini_set("display_errors","1"); error_reporting(e_all); include("../../config.php"); $down= array(); $xx=0; $query = "select   jq.stud_id id,                    jq.subject name,                    jq.starttime endtime,                    (select sum(drives_count) jqcalendar                       stud_id=jq.stud_id ,                     description in(5, 6, 14, 17, 18, 34)) drive_count                     jqcalendar jq                    left join csn_bills b on jq.stud_id=b.student_id                    left join csn_bills_details bd on b.id=bd.bill_id                    jq.starttime > '".$_get['from']."' ,                     jq.starttime < '".$_get['till']."' ,                     jq.description in(5, 6, 14, 17, 18, 34) ,                     b.student_id=jq.stud_id"; $get_drives= $db->fetch_array($query);  foreach($get_drives $key ) {     $quant=0;     $bill_id= $db->fetch_array("select cb.id bill_id, cb.payment_type, cb.bill_doc_date, bd.quant quant  csn_bills cb                                 left join csn_bills_details bd on cb.id=bd.bill_id student_id=".$key['id']." , cb.atskaite=0");     if(isset($bill_id)){         foreach ($bill_id $key2 ) {             if($key2['payment_type']==1){                 $quant=$quant+$key2['quant'];                 $down[$xx]['id']=$key['id'];                 $down[$xx]['name']=$key['name'];                 $down[$xx]['drive_count']=$key['drive_count'];                 $down[$xx]['bill_id']=$key2['bill_id'];                 $down[$xx]['bill_date']=$key2['bill_doc_date'];                 $down[$xx]['endtime']=$key['endtime'];                 $down[$xx]['payment_type']=$key2['payment_type'];                 $down[$xx]['quant']=$quant;              }         }     }     else{         echo "no report";     }        $xx++;  }  //echo json_encode($get_drives); echo json_encode($down); //echo json_encode($bill_id); ?>


Comments

Post a Comment

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

i'm looking dynamically populate select element names of items stored array. for reason it's not working , i'm not sure why. html: <div class="col-md-4 col-md-offset-4"> <select class="select1"> </select> , <select class="select2"> </select> </div> note i'm using bootstrap layout. here's jquery i'm using try , populate ".select1" jquery: select: function() { $.each(state.greens, function(index, value) { $(".select1").append("<option value =' " + index + " '>" + state.greens[index].name + "</option>"); }); } note function 'select' stored within object called 'display'. state.greens name of array i'm trying access. so @ end of html page call display.select(); call function. no error messages showing in console. also, saw question: appending
Read more

Android soft keyboard reverts to default keyboard on orientation change -

i'm building android soft keyboard , can't seem fix bug - have arabic , qwerty keyboard , when rotate device on qwerty keyboard (or arabic shift), it's if program has "restarted" , becomes arabic keyboard without shift. the onsaveinstancestate(bundle savedinstancestate) not work because application not extend activity inputmethodservice . i put following in android manifest android:configchanges="keyboard|keyboardhidden|orientation" android:windowsoftinputmode="stateunchanged|adjustresize"> i tried using @override public void onconfigurationchanged(configuration newconfig) { super.onconfigurationchanged(newconfig); log.i(mydebug, "config changed " + currentkeyboard.equals(qwerty)); } however, currentkeyboard.equals(qwerty)) results false , made sure true before orientation change. any appreciated. i think applications fault. if application restarting on orientation change
Read more

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -

i rendering jbutton image on simulate jcheckbox behavior. why don't let jtable render jcheckbox? because need bigger checkboxes , there's no way can resize them (as far know). so, have own table cell renderer , editor. both renders jbutton , checkbox images on them. trying change image checked image unchecked image (or vice versa) , update cell value (boolean true or false). however, reason, getcelleditorvalue() not update table. so, release mouse, value goes original one. any appreciated! lot! public class tableexample extends jframe { jscrollpane pane; jpanel panel; jtable table; object[][] data; mytablemodel tm; renderer buttoncolumn; public tableexample(object[][] data) throws ioexception { string[] columns = {"column#1", "column#2", "column#3", "column#4", "column#5", "column#6"}; this.data = data; this.setpreferredsize(new dimension(700, 500));
Read more