private function _getMessages($returnType = NULL, $limitFrom = NULL, $limitTo = NULL, $seeType = NULL, $close = FALSE)
{
Trace::output($this->traceID, "_getMessages");
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'function' => "_getMessages");
$array;
//----------------------------------------------------------
$num = !is_null($limitFrom) ? $limitFrom : 0;
//----------------------------------------------------------
$queryString = "SELECT " . GuestbookConst_v0::TBL_MESSAGES . "." . GuestbookConst_v0::CLM_EMAIL . ",";
$queryString .= GuestbookConst_v0::TBL_MESSAGES . "." . GuestbookConst_v0::CLM_ID . ",";
$queryString .= GuestbookConst_v0::TBL_MESSAGES . "." . GuestbookConst_v0::CLM_NAME . ",";
$queryString .= "DATE_FORMAT(" . GuestbookConst_v0::TBL_MESSAGES . "." . GuestbookConst_v0::CLM_DATETIME . ",'%M %e, %Y, %l:%i%p') as dateTimeFormat,";
$queryString .= GuestbookConst_v0::TBL_MESSAGES . "." . GuestbookConst_v0::CLM_MESSAGE . ",";
$queryString .= GuestbookConst_v0::TBL_MESSAGES . "." . GuestbookConst_v0::CLM_APPROVED;
$queryString .= " FROM " . GuestbookConst_v0::TBL_MESSAGES;
$queryString .= !is_null($seeType) ? " WHERE " . GuestbookConst_v0::CLM_APPROVED . " = " . $seeType : " ";
$queryString .= " ORDER BY " . GuestbookConst_v0::CLM_DATETIME . " DESC";
$queryString .= !is_null($limitFrom) ? " LIMIT " . $limitFrom : " ";
$queryString .= !is_null($limitTo) && !is_null($limitFrom) ? "," . $limitTo : " ";
$result = GlobalMas::$mysqli->query($queryString) or die("getMessages: query did not go through: " . $queryString);
//----------------------------------------------------------
$chk['query'] = $queryString;
//----------------------------------------------------------
if (sizeof($result) > 0) {
//------------------------------------------------------
$arr = array();
//------------------------------------------------------
$chk = $this->_getTotal($seeType);
//------------------------------------------------------
while ($row = $result->fetch_assoc()) {
//--------------------------------------------------
if ($chk["bool"]) {
$row["index"] = $chk["result"] - $num;
array_push($arr, $row);
$num++;
} else {
break;
}
}
//------------------------------------------------------
$json = $chk["bool"] && $returnType == "XML" ? json_encode(array("item" => $arr)) : $arr;
$chk["bool"] && $returnType == "XML" ? $chk["result"] = GenFun::json_to_xml($json) : ($chk["result"] = $json);
} else {
$chk["bool"] = false;
}
//----------------------------------------------------------
if ($close) {
GlobalMas::$mysqli->close($this->conn);
}
//----------------------------------------------------------
$chk['output'] = Trace::$output;
//----------------------------------------------------------
return $chk;
}
public function getImages($returnType = "XML")
{
Trace::output($this->traceID, "getImages");
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'traceID' => "getImages");
//----------------------------------------------------------
$chk = MySQL::getTable(NicKelmanConst_v0::TBL_IMAGES);
//----------------------------------------------------------
if ($returnType == "XML") {
if ($chk['bool']) {
$chk = GenFun::json_to_xml(json_encode(array("item" => $chk['result'])), true);
}
}
//----------------------------------------------------------
return $chk;
}
