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 viewInvitedMembers($eventID)
{
global $db;
$db->select('Events', array('id' => $eventID), $limit = false, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin = "");
$event = $db->row_array();
$Page_Title = "المدعوون الى " . $event['subject'];
$myFunctions = new TableView();
$myFunctions->addF("عرض", "View", "v");
$myFunctions->addF("تعديل", "Edit", "e");
$myTable = new TableView();
$myTable->addE("ID", "id", "`id`");
$myTable->addE("اسم العضو", "name", "`name`");
$myTable->addE("القبيله", "Gname", "`Gname`");
// $myTable->addE("ذاهب","IsGoing","`IsGoing`");
$myTable->addElement("الصوره الشخصيه", "ProfilePic", "`ProfilePic`", "<img class=\"img-responsive thumbnail\" src='../image.php?id=", "&t=150x150' />");
$keyid = "id";
global $per_page;
$what = $myTable->returnArray();
$where = array('EventID' => $eventID);
$table = "members";
$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`=`invitationsLog`.`memberID`";
// $innerJoin.="INNER JOIN `members` ON `members`.`id`=`invitationsLog`.`memberID`";
$getArray = $_GET;
require "functions/generalFunctions.php";
$start = getStartPage($getArray, $per_page);
$db->select('invitationsLog', $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 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 ViewList($where, $Page_Title, $myFunctions)
{
global $db;
$oldGet = $_GET;
$inlineMenu = "";
///////////////////////////////////// View approved only //////////////////////////
if (!array_key_exists('approved', $where)) {
$gArray = $oldGet;
$gArray['VA'] = false;
$va = true;
if (array_key_exists('VA', $_GET)) {
if ($_GET['VA'] == false) {
$va = false;
$_GET['VA'] = true;
$where['approved'] = 1;
}
}
$inlineMenu .= '<div class="checkbox inlineMenuItem"><label>
<input class="chBox" ch="?' . http_build_query($_GET) . '" unch="?' . http_build_query($gArray) . '" type="checkbox" ' . ($va ? "checked" : "") . '>اظهر المناسبات الغير مفعله </label></div>';
}
///////////////////////////////////// Sort BYy //////////////////////////
$_GET = $oldGet;
$gArray = $_GET;
$gArray['EX'] = false;
$ex = true;
if (array_key_exists('EX', $_GET)) {
if ($_GET['EX'] == false) {
$ex = false;
$_GET['EX'] = true;
$timeNow = Date("Y-m-d h:m:s");
$twhere = "`TimeEnded` >= '" . $timeNow . "'";
array_push($where, $twhere);
//$where['approved']=1;
}
}
$inlineMenu .= '<div class="checkbox inlineMenuItem"><label>
<input class="chBox" ch="?' . http_build_query($_GET) . '" unch="?' . http_build_query($gArray) . '" type="checkbox" ' . ($ex ? "checked" : "") . '>اظهار المناسبات المنتهيه</label></div>';
///////////////////////////////////// Sort BYy //////////////////////////
$inlineMenu .= '<div class="inlineMenuItem">ترتيب حسب
<select class="form-control" id="sel1">
<option>تاريخ الانشاء</option>
<option>تاريخ الانتهاء</option>
</select></div>';
///////////////////////////////////// catigories //////////////////////////
$nowSelectedCat = 0;
if (array_key_exists('catID', $_GET)) {
$where['eventType'] = $_GET['catID'];
$nowSelectedCat = $_GET['catID'];
}
$db->select('EventCatigories', "", $limit = false, $order = false, $where_mode = "AND", $print_query = false, $What = "*", $innerJoin = "");
$results = $db->result_array();
$eventTypeSelect = "";
foreach ($results as $value) {
$_GET['catID'] = $value['catID'];
$eventTypeSelect .= "<option " . ($nowSelectedCat == $value['catID'] ? "selected='selected'" : "") . " value='?" . http_build_query($_GET) . "'>" . $value['catName'] . "</option>";
}
unset($_GET['catID']);
$inlineMenu .= '<div class="inlineMenuItem">اظهار
<select class="form-control" id="dynamic_select">
<option value="?' . http_build_query($_GET) . '">جميع المناسبات</option>
' . $eventTypeSelect . '
</select></div>';
///////////////////////////////////// catigories //////////////////////////
$table = "Events";
$myTable = new TableView();
$myTable->addE("ID", "id", "`Events`.`id`");
$eventStatus = array('1' => "مفعله", '0' => "غير مفعله");
$myTable->addCustomeElement("vip", "VIP", array('0' => "لا", '1' => "نعم"));
$myTable->addE("الاسم", "name", "`members`.`name`");
$eventStatus = array('1' => "مفعله", '0' => "غير مفعله");
$myTable->addCustomeElement("حاله المناسبة", "approved", $eventStatus);
$myTable->addE("عنوان المناسبة", "subject", "`Events`.`subject`");
$myTable->addElement("الصوره", "picture", "`Events`.`picture`", "<img class=\"img-responsive thumbnail\" src='../image.php?id=", "&t=150x150' />");
$myTable->addE("التفاصيل", "description", "`Events`.`description`");
$myTable->addE("نوع المناسبة", "catName", "`EventCatigories`.`catName`");
$myTable->addE("القبيله", "Gname", "`Gname`");
$keyid = "id";
global $per_page;
$what = $myTable->returnArray();
$innerJoin = "INNER JOIN (SELECT `groups`.`Gname` Gname ,`members`.`name` ,`members`.`id`,`members`.`groupID`\n FROM groups INNER JOIN members ON members.groupID=groups.Gid)\n `members` ON `Events`.`CreatorID`=`members`.`id`\n INNER JOIN `EventCatigories` ON `Events`.`eventType`=`EventCatigories`.`catID`";
$getArray = $_GET;
$where;
require "functions/generalFunctions.php";
$start = getStartPage($getArray, $per_page);
$db->select($table, $where, $limit = $start . "," . $per_page, $order = "TimeEnded DESC", $where_mode = "AND", $print_query = false, $what, $innerJoin);
$input = $db->result_array();
include "views/list.php";
}
