public static function autoscroll($query, $param, $key, $sort = '', $isloadold = true, $minl = null, $maxl = null) { setifnn($minl, $param["minl"]); setifnn($maxl, $param["maxl"]); if ($key != null) { if ($isloadold) { $querylimit = "select * from (" . gtable($query, false) . ") outpquery where ({$key}<{min} OR {min}=-1) " . ($param["minl"] == -1 ? '' : "limit {minl} "); } else { $querylimit = "select * from (" . gtable($query, false) . ") outpquery where {$key}>{max} " . ($param["maxl"] == -1 ? '' : "limit {maxl} "); } } else { //max,maxl must be +ve int $querylimit = "select * from (" . $query . ") outpquery limit {maxl} offset {max} "; } if ($key != null) { $querysort = "select * from (" . $querylimit . ") sortquery " . $sort; } else { $querysort = $querylimit; } $qresult = Sqle::getA($querysort, $param); $outp["qresult"] = $qresult; $outp["maxl"] = $maxl; $outp["minl"] = $minl; $outp["qresultlen"] = count($qresult); if ($key == null) { $outp["max"] = $param["max"] + $param["maxl"]; } else { if (count($qresult) == 0) { $outp["min"] = $param["min"]; $outp["max"] = $param["max"]; } else { $e1 = $qresult[0][$key]; $e2 = $qresult[count($qresult) - 1][$key]; $s = new Special(); $outp["min"] = $s->min($e1, $e2, $param["min"]); $outp["max"] = $s->max($e1, $e2, $param["max"]); } } return $outp; }
public static function strtotime_t3($date, $format = null) { if ($date == '') { return 0; } setifnn($format, gi("dateformat")); $temp = DateTime::createFromFormat($format, $date); return strtotime($temp->format("M d Y h:i a")); }
<?php setifnn($width, count($rows) == 0 ? 0 : count($rows[0])); setifnn($height, count($rows)); if ($height > 0) { ?> <table class=" responsive-table"> <thead> <tr> <?php for ($i = 0; $i < $width; $i++) { ?> <th><?php if ($func == null || $func(0, $i) == null) { echo convchars(getval($i, getval(0, $rows))); } ?> </th> <?php } ?> </tr> </thead> <tbody> <?php for ($j = 1; $j < $height; $j++) { ?> <tr> <?php for ($i = 0; $i < $width; $i++) { ?>