function form($topic_id = FALSE, $id = FALSE)
{
$data['quiz'] = new Webboard_quiz($topic_id);
$data['faqs'] = new Faq($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/faqs_form', $data);
}
function index()
{
$data['registers'] = new Register();
$where = 'where 1 = 1 ';
if (@$_GET['center']) {
$where .= ' and center like \'%' . $_GET['center'] . '%\' ';
}
if (@$_GET['name']) {
$where .= ' and name like \'%' . $_GET['name'] . '%\' ';
}
if (@$_GET['position']) {
$where .= ' and position like \'%' . $_GET['position'] . '%\' ';
}
if (@$_GET['email']) {
$where .= ' and center like \'%' . $_GET['email'] . '%\' ';
}
if (@$_GET['from'] && @$_GET['to']) {
$where .= " and date(created) >= date('" . Date2DB($_GET['from']) . "') and date(created) <= date('" . Date2DB($_GET['to']) . "')";
}
$data['registers']->sql('select * from registers ' . $where . ' group by center,province_id order by id desc')->get_page();
/*if(@$_GET['center'])$data['registers']->like('center','%'.$_GET['center'].'%');
if(@$_GET['name'])$data['registers']->like('name','%'.$_GET['name'].'%');
if(@$_GET['position'])$data['registers']->like('position','%'.$_GET['position'].'%');
if(@$_GET['email'])$data['registers']->like('email','%'.$_GET['email'].'%');
if((@$_GET['from'])&&(@$_GET['to']))$data['registers']->where("date(created) >= date('".Date2DB($_GET['from'])."') and date(created) <= date('".Date2DB($_GET['to'])."')");
$data['registers']->group_by('center,province_id')->order_by('id desc')->get_page();*/
//$data['registers']->check_last_query();
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/index', $data);
}
function index()
{
$ga = new ga();
$this->ga->authen('*****@*****.**', 'rain2512', 'ga:98468001');
if ($_GET) {
$now = Date2DB($_GET['date']);
} else {
$now = date("Y-m-d");
}
$lastmonth = date('Y-m-d', strtotime('-29 days', mysql_to_unix($now)));
//Summery: visitors, unique visit, pageview, time on site, new visits, bounce rates
$data['summery'] = $this->ga->getSummery($lastmonth, $now);
//All time summery: visitors, page views
$data['allTimeSummery'] = $this->ga->getAllTimeSummery();
//Last 10 days visitors (for graph)
$data['visits'] = $this->ga->getVisits($lastmonth, $now, 30);
//Top 10 search engine keywords
$data['topKeywords'] = $this->ga->getTopKeyword($lastmonth, $now, 10);
//Top 10 visitor countries
$data['topCountries'] = $this->ga->getTopCountry($lastmonth, $now, 10);
//Top 10 page views
$data['topPages'] = $this->ga->getTopPage($lastmonth, $now, 10);
//Top 10 referrer websites
$data['topReferrer'] = $this->ga->getTopReferrer($lastmonth, $now, 10);
//Top 10 visitor browsers
$data['topBrowsers'] = $this->ga->getTopBrowser($lastmonth, $now, 10);
//Top 10 visitor operating systems
$data['topOs'] = $this->ga->getTopOs($lastmonth, $now, 10);
$this->template->append_metadata(js_datepicker());
$this->template->build("index", $data);
}
function view($id)
{
$data['question'] = new Question($id);
$data['meeting'] = new Meeting($data['question']->meeting_id);
$data['room_type'] = array(1 => 'ห้องพักเดี่ยวระดับ 9 และระดับ 8 ผู้อำนวยการเท่านั้น', 2 => 'ต้องการพักห้องเดี่ยว กรณีไม่มีสิทธิพักเดี่ยวต้องเสียส่วนเกินเอง คืนละ ' . $data['meeting']->money . ' บาท', 3 => 'ต้องการพักห้องคู่ โดย พักคู่กับ ' . $data['question']->r->profile->first_name . ' ' . $data['question']->r->profile->last_name, 4 => 'ต้องการพักห้องคู่ กรณีมีผู้ติดตาม ' . $question->roommate, 5 => 'ให้คณะผู้ดำเนินการจัดให้');
$data['meal_type'] = array(1 => 'ตามที่คณะคำเนินการจัดให้', 2 => 'อิสลาม', 3 => 'มังสะวิรัต');
$this->template->append_metadata(js_datepicker());
$this->template->build('view', $data);
}
function form($id = FALSE)
{
$data['user'] = new User($id);
$data['levels'] = new Level();
$data['levels']->get();
$data['groups'] = new Group();
$data['groups']->get();
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/user_form', $data);
}
function form($id = FALSE)
{
$categories = new Category();
$categories->where("module = 'galleries' and parents = 0")->get();
$data['parent'] = $categories->get_clone();
$categories->clear();
$data['category'] = $categories->get_by_id($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/category_form', $data);
}
function index()
{
$data['topics'] = new Topic();
if (@$_GET['search']) {
$data['topics']->like('title', '%' . $_GET['search'] . '%');
}
if (@$_GET['group_id']) {
$data['topics']->where_related('user', 'group_id', $_GET['group_id']);
}
if (@$_GET['start']) {
$data['topics']->where('DATE(question_topics.created) >= DATE(\'' . Date2DB($_GET['start']) . '\')');
}
if (@$_GET['end']) {
$data['topics']->where('DATE(question_topics.created) <= DATE(\'' . Date2DB($_GET['end']) . '\')');
}
$data['topics']->where('status', '1');
$data['topics']->order_by('id', 'desc')->get_page();
$this->template->append_metadata(js_datepicker());
$this->template->build('public_index', $data);
}
function index()
{
//Addlog("read",'ดูรายการจำนวนคนเข้าเว็บไซต์');
//$this->ga->authen('*****@*****.**','F@vourite','ga:75710162');
$ga = new analytics();
if ($_GET) {
$now = Date2DB($_GET['date']);
} else {
$now = date("Y-m-d");
}
$lastmonth = date('Y-m-d', strtotime('-29 days', mysql_to_unix($now)));
//Last 10 days visitors (for graph)
//$data['visits']=$this->ga->getVisits($lastmonth,$now,30);
$visits = $ga->getResultDate('visits', $lastmonth, $now);
foreach ($visits as $key => $v) {
$data['visits'][$key]['ga:date'] = $v['0'];
$data['visits'][$key]['ga:visits'] = $v['1'];
}
//Summery: visitors, unique visit, pageview, time on site, new visits, bounce rates
//$data['summery']=$this->ga->getSummery($lastmonth,$now);
$data['summery']['ga:visits'] = $ga->getResult('visits', $lastmonth, $now);
$data['summery']['ga:visitors'] = $ga->getResult('visitors', $lastmonth, $now);
$data['summery']['ga:pageviews'] = $ga->getResult('pageviews', $lastmonth, $now);
$data['summery']['ga:timeOnSite'] = $ga->getResult('timeOnSite', $lastmonth, $now);
$data['summery']['ga:newVisits'] = $ga->getResult('newVisits', $lastmonth, $now);
$data['summery']['ga:bounces'] = $ga->getResult('bounces', $lastmonth, $now);
$data['summery']['ga:entrances'] = $ga->getResult('entrances', $lastmonth, $now);
//All time summery: visitors, page views
//$data['allTimeSummery']=$this->ga->getAllTimeSummery();
$data['allTimeSummery']['ga:visits'] = $ga->getResult('visits', '2005-01-01', $now);
$data['allTimeSummery']['ga:pageviews'] = $ga->getResult('pageviews', '2005-01-01', $now);
//Top 10 visitor countries
//$data['topCountries']=$this->ga->getTopCountry($lastmonth,$now,10);
$topCountries = $ga->getResultDate('visits', $lastmonth, $now, 'country', '10', '-ga:visits');
foreach ($topCountries as $key => $v) {
$data['topCountries'][$key]['ga:country'] = $v['0'];
$data['topCountries'][$key]['ga:visits'] = $v['1'];
}
//Top 10 search engine keywords
//$data['topKeywords'] = $this->ga->getTopKeyword($lastmonth,$now,10);
$topKeywords = $ga->getResultDate('visits', $lastmonth, $now, 'keyword', '10', '-ga:visits');
foreach ($topKeywords as $key => $v) {
$data['topKeywords'][$key]['ga:keyword'] = $v['0'];
$data['topKeywords'][$key]['ga:visits'] = $v['1'];
}
//Top 10 referrer websites
//$data['topReferrer']=$this->ga->getTopReferrer($lastmonth,$now,10);
$topReferrer = $ga->getResultDate('visits', $lastmonth, $now, 'source', '10', '-ga:visits');
foreach ($topReferrer as $key => $v) {
$data['topReferrer'][$key]['ga:source'] = $v['0'];
$data['topReferrer'][$key]['ga:visits'] = $v['1'];
}
//Top 10 page views
//$data['topPages']=$this->ga->getTopPage($lastmonth,$now,10);
$topPages = $ga->getResultDate('visits', $lastmonth, $now, 'pagePath', '10', '-ga:visits');
foreach ($topPages as $key => $v) {
$data['topPages'][$key]['ga:pagePath'] = $v['0'];
$data['topPages'][$key]['ga:visits'] = $v['1'];
}
//Top 10 visitor operating systems
//$data['topOs']=$this->ga->getTopOs($lastmonth,$now,10);
$topOs = $ga->getResultDate('visits', $lastmonth, $now, 'operatingSystem', '10', '-ga:visits');
foreach ($topOs as $key => $v) {
$data['topOs'][$key]['ga:operatingSystem'] = $v['0'];
$data['topOs'][$key]['ga:visits'] = $v['1'];
}
//Top 10 visitor browsers
//$data['topBrowsers']=$this->ga->getTopBrowser($lastmonth,$now,10);
$topBrowsers = $ga->getResultDate('visits', $lastmonth, $now, 'browser', '10', '-ga:visits');
foreach ($topBrowsers as $key => $v) {
$data['topBrowsers'][$key]['ga:browser'] = $v['0'];
$data['topBrowsers'][$key]['ga:visits'] = $v['1'];
}
$this->template->append_metadata(js_datepicker());
$this->template->build("index", $data);
}
function form($id = false)
{
$data['coverpage'] = new Coverpage($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/cover_form', $data);
}
function form($id = FALSE)
{
$data['hilight'] = new hilight($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/hilight_form', $data);
}
function form($id = FALSE)
{
$data['calendar'] = new Calendar($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/calendar_form', $data);
}
function form($id = FALSE)
{
$data['information'] = new Information($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/information_form', $data);
}
function form($id = FALSE)
{
$data['executive'] = new Executive($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/executive_form', $data);
}
function form($id = FALSE)
{
$data['agency'] = new Agency($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/form', $data);
}
function form($id = FALSE)
{
$data['document'] = new Document($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('document_form', $data);
}
function form($id = FALSE)
{
$data['law'] = new Law($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/law_form', $data);
}
function form($id = FALSE)
{
$data['weblinks'] = new Weblink($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/weblinks_form', $data);
}
function form($id = FALSE)
{
$data['article'] = new Article($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/article_form', $data);
}
function form($id = FALSE)
{
$data['academics'] = new Academic($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/academic_form', $data);
}
function form($id = FALSE)
{
$data['notice'] = new Notice($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/notice_form', $data);
}
function form($id = FALSE)
{
/* include('themes/fundv2/odbc_connect.php');
$this->load->helper('html');
$data['rs'] = $db->Execute("select * from INTRANET_ACTCALENDAR WHERE ID=".$id);
$this->template->build('admin/form_mso',$data);*/
$data['rs'] = new content_calendar($id);
$this->template->append_metadata(js_datepicker());
if (@$_GET['module']) {
$data['module'] = $_GET['module'];
//$data['category'] = $_GET['category'];
} else {
$calendar = new content_calendar($id);
$data['module'] = $calendar->module;
//$data['category'] = $calendar->category;
}
$this->template->build('admin/form_mso', $data);
}
function form($id = FALSE)
{
$data['english_zone'] = new English_zone($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/english_zone_form', $data);
}
function form($id = FALSE)
{
$data['rs'] = new Download($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/form', $data);
}
function form($id = FALSE)
{
$data['mediapublics'] = new Mediapublic($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/mediapublic_form', $data);
}
function index()
{
$data['user'] = new User($this->session->userdata('id'));
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/user_profile', $data);
}
function form($id = NULL)
{
$data['user'] = new User($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('form', $data);
}
function form($id = FALSE)
{
$data['knowledge'] = new Knowledge($id);
$this->template->append_metadata(js_datepicker());
$this->template->build('admin/knowledge_form', $data);
}
