public function viewCommentbyNews($newsID) { global $db; $db->select('News', array('NewsID' => $newsID), $limit = false, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin = ""); $news = $db->row_array(); $Page_Title = "التعليقات على " . $news['Subject']; $myFunctions = new TableView(); $msg = "هل انت متاكد من حذف التعليق ؟"; $myFunctions->addF("عرض صاحب التعليق ", "View", "v"); $myFunctions->addF("خذف التعليق", "Delete", "d"); $myTable = new TableView(); $myTable->addE("ID", "CommentID", "`CommentID`"); $myTable->addE("اسم العضو", "name", "`name`"); $myTable->addE("القبيله", "Gname", "`Gname`"); $myTable->addElement("الصوره الشخصيه", "ProfilePic", "`ProfilePic`", "<img class=\"img-responsive thumbnail\" src='../image.php?id=", "&t=150x150' />"); $myTable->addE("التعليق", "comment", "`comment`"); $keyid = "CommentID"; global $per_page; $what = $myTable->returnArray(); $where = array('POSTID' => $newsID); $table = "comments"; $innerJoin = "INNER JOIN\n (SELECT `groups`.`Gname` Gname ,\n `members`.`id`,`members`.`name` name,`members`.`ProfilePic` ProfilePic\n FROM groups INNER JOIN members ON members.groupID=groups.Gid)\n `members` ON `members`.`id`=`NewsComments`.`memberID`"; $getArray = $_GET; require "functions/generalFunctions.php"; $start = getStartPage($getArray, $per_page); $db->select('NewsComments', $where, $limit = $start . "," . $per_page, $order = false, $where_mode = "AND", $print_query = false, $what, $innerJoin); $input = $db->result_array(); include "views/list.php"; }
public function getAvatarsList() { $Page_Title = "الصور الرمزيه"; global $db; require_once "views/tablelist.php"; $myTable = new TableView(); $myTable->addE("id", "id", "`id`"); $myTable->addElement("الصوره الشخصيه", "imageID", "`imageID`", "<img class=\"img-responsive thumbnail\" src='../image.php?id=", "&t=150x150' />"); $msg = "هل انت متاكد من حذف الصوره ؟"; $keyid = "id"; global $per_page; $myFunctions = new TableView(); $myFunctions->addF("عرض", "View", "v"); $myFunctions->addF("تعديل", "Edit", "e"); $myFunctions->addF("حذف", "delete", "d"); $what = $myTable->returnArray(); $table = "Avatars"; $innerJoin = ""; $getArray = $_GET; require "functions/generalFunctions.php"; $start = getStartPage($getArray, $per_page); $db->select($table, "", $limit = $start . "," . $per_page, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin); $input = $db->result_array(); include "views/list.php"; }
public function ViewNewsList() { $Page_Title = "عرض حميع الاخبار المنشوره"; $where = array('1' => 1); $myFunctions = new TableView(); $myFunctions->addF("عرض", "View", "v"); $myFunctions->addF("تعديل", "Edit", "e"); global $db; $myTable = new TableView(); $myTable->addE("ID", "NewsID", "`NewsID`"); $myTable->addE("عنوان الخبر", "Subject", "`Subject`"); $myTable->addE("تفاصيل الخبر", "Description", "`Description`"); $myTable->addElement("صوره الخبر", "Image", "`Image`", "<img class=\"img-responsive thumbnail\" src='../image.php?id=", "&t=150x150' />"); $keyid = "NewsID"; global $per_page; $what = $myTable->returnArray(); $table = "News"; $innerJoin = ""; $getArray = $_GET; require "functions/generalFunctions.php"; $start = getStartPage($getArray, $per_page); $db->select($table, $where, $limit = $start . "," . $per_page, $order = false, $where_mode = "AND", $print_query = false, $what, $innerJoin); $input = $db->result_array(); include "views/list.php"; }
public function viewFeedbackList() { $Page_Title = "الشكاوى و المقترحات"; global $db; require_once "views/tablelist.php"; $myTable = new TableView(); $myTable->addE("id", "FeedbackID", "`FeedbackID`"); $myTable->addE("الراسل", "name", "`name`"); $myTable->addElement("الصوره الشخصيه", "ProfilePic", "`ProfilePic`", "<img class=\"img-responsive thumbnail\" src='../image.php?id=", "&t=150x150' />"); $myTable->addE("نوع الرساله", "FeedbackType", "`FeedbackType`"); $myTable->addE("العنوان", "Subject", "`Subject`"); $myTable->addE("الرسالة", "Message", "`Message`"); $keyid = "FeedbackID"; global $per_page; $myFunctions = new TableView(); $myFunctions->addF("عرض", "View", "v"); $myFunctions->addF("تعديل", "Edit", "e"); $what = $myTable->returnArray(); $table = "Feedbacks"; $innerJoin = "inner join members on members.id=Feedbacks.SenderID"; $getArray = $_GET; require "functions/generalFunctions.php"; $start = getStartPage($getArray, $per_page); $db->select($table, "", $limit = $start . "," . $per_page, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin); $input = $db->result_array(); include "views/list.php"; }
public function viewGroupList() { $Page_Title = "القبائل"; global $db; require_once "views/tablelist.php"; $myTable = new TableView(); $myTable->addE("id", "Gid", "`Gid`"); $myTable->addE("اسم القبيله", "Gname", "`Gname`"); $myTable->addElement("صوره القبيله", "GProfilePic", "`GProfilePic`", "<img class=\"img-responsive thumbnail\" src='../image.php?id=", "&t=150x150' />"); $keyid = "Gid"; global $per_page; $myFunctions = new TableView(); $myFunctions->addF("عرض", "View", "v"); $myFunctions->addF("تعديل", "Edit", "e"); $what = $myTable->returnArray(); $table = "groups"; $innerJoin = ""; $getArray = $_GET; require "functions/generalFunctions.php"; $start = getStartPage($getArray, $per_page); $db->select($table, "", $limit = $start . "," . $per_page, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin); $input = $db->result_array(); include "views/list.php"; }
public function getEventsbyGroup($GroupID) { global $db; $db->select('groups', array('Gid' => $GroupID), $limit = false, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin = ""); $Group = $db->row_array(); $Page_Title = "مناسبات قبيله " . $Group['Gname']; $where = array('members`.`groupID' => $GroupID); $myFunctions = new TableView(); $myFunctions->addF("عرض", "ViewEvent", "v"); $myFunctions->addF("تعديل", "Edit", "e"); events::ViewList($where, $Page_Title, $myFunctions); }
public function viewMemberByGroup($groupID) { global $db; $db->select('groups', array('Gid' => $groupID), $limit = false, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin = ""); $Group = $db->row_array(); $Page_Title = "اعضاء قبيله " . $Group['Gname']; $where = array('groupID' => $groupID); $myFunctions = new TableView(); $myFunctions->addF("عرض", "View", "v"); $myFunctions->addF("تعديل", "Edit", "e"); members::getMembersList($where, $Page_Title, $myFunctions); }