PHP Name::getFields Examples

Example #1

File: PersonDetail.php Project: redbugz/rootstech2013

 static function getFields($tbl = 'p', $name = 'n', $birth = 'b', $death = 'd')
 {
     global $currentRequest;
     $fields = array("person_id", "gender");
     $ret = Base::addFields($tbl, $fields);
     $prefix = "";
     $tbl_pref = "";
     if (strlen($tbl) > 0) {
         $prefix = $tbl . "_";
         $tbl_pref = $tbl . ".";
     }
     $ret .= ", DATE_FORMAT(" . $birth . ".date1, " . $currentRequest->datefmt . ") AS " . $prefix . "DOB";
     $ret .= ", " . $birth . ".date1 AS " . $prefix . "date_of_birth";
     $ret .= ", DATE_FORMAT(" . $death . ".date1, " . $currentRequest->datefmt . ") AS " . $prefix . "DOD";
     $ret .= ", " . $death . ".date1 AS " . $prefix . "date_of_death";
     $ret .= ", " . Name::getFields($name);
     return $ret;
 }