PHP manage_person_devotion::CountDevotion Examples

Example #1

File: devotion.data.php Project: jafarkhani/rtfund

function selectDev()
{
    $where = " d.PersonID = :PID ";
    $whereParam = array();
    $whereParam[":PID"] = $_GET["Q0"];
    /*
    	$field = isset ( $_GET ["fields"] ) ? $_GET ["fields"] : "";
    	
    	if (isset ( $_GET ["query"] ) && $_GET ["query"] != "") {
    	switch ( $field) {
    		case "Title" :
    			$where .= " AND Title LIKE :qry " ;
    			$whereParam[":qry"] = "%" . $_GET["query"] . "%";
    	        
    		break;
    		case "enlisted" :	
    			$where .= " AND enlisted = :qry1 " ;
    			$whereParam[":qry1"] = "%" . $_GET["query"] . "%";
    	
    		break;
    		case "from_date" :
    			$where .= " AND from_date = :qry1 " ;
    			$whereParam[":qry1"] = $_GET["query"];
    			
    		break;
    		case "to_date" :
    			$where .= " AND to_date = :qry1 " ;
    			$whereParam[":qry1"] = $_GET["query"];
    			
    		break;
    		case "amount" :
    			$where .= " AND amount = :qry1 " ;
    			$whereParam[":qry1"] = $_GET["query"];
    		
    		break;
    		case "war_place" :
    			$where .= " AND war_place LIKE :qry ";
    			$whereParam[":qry"] = "%" . $_GET["query"] . "%";
    			
    		break;
    		
    		
    			}
    }
    */
    $no = manage_person_devotion::CountDevotion($where, $whereParam);
    $where .= dataReader::makeOrder();
    $where .= isset($_GET["start"]) ? " limit " . $_GET["start"] . "," . $_GET["limit"] : "";
    $temp = manage_person_devotion::GetAllDevotions($where, $whereParam);
    echo dataReader::getJsonData($temp, $no, $_GET["callback"]);
    die;
}