INCREASE |
/**** Your settings go here ****************/ define("DBHOST", "ksala.db.10118637.1b1.hostedresource.net"); //define("DBUSER", "mwphgladmin2012"); define("DBUSER", "ksala"); define("DBPWD", "OrientOfLouisiana@1"); //define("DBNAME", "grandlodge"); define("DBNAME", "ksala"); /*******************************************/ include ('baaGrid.php'); $conn = mysql_connect(DBHOST,DBUSER,DBPWD); mysql_select_db(DBNAME, $conn); // SHOW INCREASES $sqlOFF = "SELECT district, lodge_name, COUNT(memberraiseddate) AS 'Raised', COUNT(memberhealeddate) AS 'Heald', COUNT(memberreinstateddate) AS 'Reinstated' FROM sublodges WHERE `memberraiseddate` BETWEEN '".$_POST['date5']."' AND '".$_POST['date6']."' OR `memberhealeddate` BETWEEN '".$_POST['date5']."' AND '".$_POST['date6']."' OR memberreinstateddate BETWEEN '".$_POST['date5']."' AND '".$_POST['date6']."' AND lodge_name != 'ZZZ' AND memberlastname != '' GROUP BY lodge_name ORDER BY district, lodge_name"; $sql = "SELECT district, lodge_name, SUM(CASE WHEN memberraiseddate BETWEEN '".$_POST['date5']."' AND '".$_POST['date6']."' THEN 1 ELSE 0 END) AS RAISED, SUM(CASE WHEN memberhealeddate BETWEEN '".$_POST['date5']."' AND '".$_POST['date6']."' THEN 1 ELSE 0 END) AS HEALED, SUM(CASE WHEN memberreinstateddate BETWEEN '".$_POST['date5']."' AND '".$_POST['date6']."' THEN 1 ELSE 0 END) AS REINSTATED, SUM(CASE WHEN affiliationdate BETWEEN '".$_POST['date5']."' AND '".$_POST['date6']."' THEN 1 ELSE 0 END) AS AFFILATED FROM sublodges GROUP BY lodge_name ORDER BY district, lodge_name"; $grid2 = new baaGrid($sql); $grid2->setColClass('data1,data2'); $grid2->setHeaderClass('head1'); $grid2->setTableAttr('border="1" cellspacing="0" width="500"'); $grid2->setAlign(3,'3'); $grid2->setOnChange(0,1,3,4); $grid2->setSubTotalClass('T,T,TLB,border'); $grid2->setTotal(2); $grid2->setTotal(3); $grid2->setTotal(4); $grid2->setTotal(5); $grid2->setCount(1); $grid2->setHeadings("District,Lodge,Raised,Healed,Reinstated,Affilated"); $grid2->setDateFormat('j M y'); $grid2->showColNumbers(0); $grid2->display(); $grid3 = new baaGrid($sq2); $grid3->setColClass('data1,data2'); $grid3->setHeaderClass('head1'); $grid3->setTableAttr('border="1" cellspacing="0" width="400"'); $grid3->setAlign(3,'3'); $grid3->setOnChange(0,1,3,4); $grid3->setSubTotalClass('T,T,TLB,border'); $grid3->setTotal(2); $grid3->setTotal(3); $grid3->setTotal(4); $grid3->setCount(1); $grid2->setHeadings("District,Lodge,Raised,Healed,Reinstated,Affilated"); $grid3->setDateFormat('j M y'); $grid3->showColNumbers(0); $grid3->display(); // END INCREASE ?>
DECREASE |