public static function getall($params)
{
$params = array_merge(array("category_id" => null, "order" => null, "limit" => null, "offset" => null), $params);
$params["limit"] = $params["limit"] ? (int) $params["limit"] : 20;
$params["offset"] = $params["offset"] ? (int) $params["offset"] : 0;
switch ($params["order"]) {
case 1:
$strOrder = " ORDER BY m.id DESC ";
break;
case 2:
$strOrder = " ORDER BY m.id ASC ";
break;
case 3:
$strOrder = " ORDER BY l.count DESC ";
case 4:
$strOrder = " ORDER BY l.count ASC ";
break;
default:
$strOrder = " ORDER BY m.id DESC ";
break;
}
$objDB = My_Database::getConnect("tgst", "tgst", "master");
$stmt = $objDB->prepare("\n SELECT m.id, m.name, l.count FROM truyenmain m \n LEFT JOIN (SELECT truyen_id, COUNT(id) count FROM truyenlike GROUP BY truyen_id) l ON m.id = l.truyen_id\n WHERE TRUE\n AND if(:category_id IS NOT NULL AND :category_id != '', FIND_IN_SET(:category_id,m.category), TRUE)\n " . $strOrder . "\n LIMIT :limit\n OFFSET :offset\n ");
$stmt->bindParam("category_id", $params["category_id"], PDO::PARAM_STR);
$stmt->bindParam("limit", $params["limit"], PDO::PARAM_INT);
$stmt->bindParam("offset", $params["offset"], PDO::PARAM_INT);
$stmt->execute();
$arrData = $stmt->fetchAll();
unset($objDB, $stmt);
return $arrData;
}
public static function getall($params)
{
$objDB = My_Database::getConnect("tgst", "tgst", "master");
$stmt = $objDB->prepare("SELECT * FROM truyencategory WHERE active = 1");
$stmt->execute();
$arrData = $stmt->fetchAll();
unset($objDB, $stmt);
return $arrData;
}
public static function get_count_img_cat_by_id($id_cat)
{
$db = My_Database::getConnect("tgst", "tgst", "master");
$stmt = $db->prepare("SELECT COUNT(*) as total_row FROM quotes WHERE FIND_IN_SET('" . $id_cat . "',quotes.category)");
$stmt->execute();
$arrData = $stmt->fetchAll();
unset($stmt, $db);
return $arrData;
}
public static function delete($params)
{
$params = array_merge(array("id" => null), $params);
$db = My_Database::getConnect("tgst", "tgst", "master");
$stmt = $db->prepare("DELETE FROM truyencategory WHERE `id` = :id");
$stmt->bindParam("id", $params["id"], PDO::PARAM_INT);
$result = $stmt->execute();
unset($stmt, $db);
return $result;
}
public static function getbyusername($params)
{
$params = array_merge(array('username' => null), $params);
$db = My_Database::getConnect("tgst", "tgst", "master");
$stmt = $db->prepare("SELECT * FROM users WHERE username = :username");
$stmt->bindParam("username", $params["username"], PDO::PARAM_STR);
$stmt->Execute();
$arrData = $stmt->fetch();
unset($stmt, $db);
return $arrData;
}
public static function sendlike($params)
{
$params = array_merge(array("like_id" => null, "truyen_id" => null), $params);
$objDB = My_Database::getConnect("tgst", "tgst", "master");
$stmt = $objDB->prepare("INSERT IGNORE INTO truyenlike (like_id,truyen_id) VALUES (:like_id,:truyen_id)");
$stmt->bindParam("like_id", $params["like_id"], PDO::PARAM_STR);
$stmt->bindParam("truyen_id", $params["truyen_id"], PDO::PARAM_STR);
$result = $stmt->execute();
unset($objDB, $stmt);
return $result;
}
