function getMainpic($gid)
{
global $db;
$q = "SELECT * FROM {$this->table_name} WHERE gallery_id = '{$gid}' AND photo_mainpic = 1 LIMIT 0,1";
$obj = $db->query($q, 1);
$this->fill(toRow($obj));
}
public function getLatestNewsFeature()
{
global $db;
$q = "SELECT * FROM {$this->table_name} WHERE ID!=1 AND ID!=6 AND post_image !='' ORDER BY post_modified DESC LIMIT 0,1";
$obj = $db->query($q, 1);
$this->fill(toRow($obj));
}
public function getLastCommentByID($wid)
{
global $db;
$q = "SELECT {$this->default_read_coloms} FROM {$this->table_name} WHERE wid = '{$wid}' ORDER BY c_date DESC LIMIT 0,1";
$obj = $db->query($q, 1);
$this->fill(toRow($obj));
}
public function getDefaultChannel()
{
global $db;
$q = "SELECT * FROM {$this->table_name} WHERE channel_default = 1 LIMIT 0,1";
$obj = $db->query($q, 1);
$this->fill(toRow($obj));
}
public function getLastReply($id)
{
global $db;
$q = "SELECT * FROM {$this->table_name} WHERE inbox_id = '{$id}' ORDER BY inbox_createdate DESC LIMIT 0,1";
$obj = $db->query($q, 1);
$row = toRow($obj);
$this->fill($row);
}
public function getSelfAndAccount($id)
{
global $db;
$acc = new Account();
$q = "SELECT {$this->default_read_coloms} FROM {$this->table_name},{$acc->table_name} WHERE account_id = '{$id}' AND admin_id = account_id";
$obj = $db->query($q, 1);
$row = toRow($obj);
$this->fill($row);
}
public function myHomeroomTeacher()
{
$ta = TahunAjaran::ta();
$kelas = Account::getMyKelas($ta);
$guru = new Guru();
$row = $guru->getHomeroomFromKelas($ta, $kelas->kelas_id);
$guru->fill(toRow($row));
//pr($guru);
Mold::both("leap/homeroom_widget", array("guru" => $guru, "kelas" => $kelas));
}
public function saveFromJS()
{
$user = json_decode($_POST['user']);
//pr($user);
$fb = new FBUser();
$fb->fill(toRow($user));
//pr($fb);
$fb->save();
$fb->saveToSession();
}
public function getLatest($begin = 0, $limit = 20)
{
global $db;
$q = "SELECT * FROM {$this->table_name} ORDER BY wall_update DESC LIMIT {$begin},{$limit}";
$muridkelas = $db->query($q, 2);
$newMurid = array();
$classname = get_called_class();
foreach ($muridkelas as $databasemurid) {
$m = new WallPortal();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
return $newMurid;
}
public function getWhereFromMultipleTable($whereClause, $arrTables = array(), $selectedColom = "*")
{
global $db;
//implode the tables
if (count($arrTables) < 1) {
die("please use normal getWhere");
}
foreach ($arrTables as $tableClassname) {
$m = new $tableClassname();
$imp[] = $m->table_name;
}
$implode = implode(",", $imp);
$q = "SELECT {$selectedColom} FROM {$this->table_name},{$implode} WHERE {$whereClause}";
$muridkelas = $db->query($q, 2);
$newMurid = array();
$classname = get_called_class();
foreach ($muridkelas as $databasemurid) {
$m = new $classname();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
return $newMurid;
}
public function getByMyChannels($array_channels, $sort = "")
{
//pr($array_channels);
if (count($array_channels) < 1) {
return array();
}
$strpp = array();
foreach ($array_channels as $chn) {
$strpp[] = " webapps_channel_id = '{$chn}' ";
}
$imp = implode(" OR ", $strpp);
//echo $imp;
global $db;
$q = "SELECT {$this->default_read_coloms} FROM {$this->table_name} WHERE ({$imp}) {$sort}";
$muridkelas = $db->query($q, 2);
$newMurid = array();
$classname = get_called_class();
foreach ($muridkelas as $databasemurid) {
$m = new $classname();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
return $newMurid;
}
var data = [
<?php
function toRow($array)
{
$string = "['{$array['0']}'";
for ($i = 1; $i < count($array); $i++) {
$string = $string . ",'" . $array[$i] . "'";
}
$string = $string . "]";
return $string;
}
foreach ($resultarray as $key => $value) {
if ($key == 0) {
echo toRow($value);
} else {
echo "," . toRow($value);
}
}
?>
];
var store = new Ext.data.Store({
proxy: new Ext.data.MemoryProxy(data),
reader: new Ext.data.ArrayReader({}, [
{name: 'fenxi'}
<?php
for ($i = 0; $i < count($row); $i++) {
echo ",{name: '{$i}'}";
}
function sync_articletagging()
{
$token = IMBAuth::createOAuth();
$url = "http://localhost:8888/tbsecom/LLProdWeb/LL_ArticleTagging_wbase?cmd=ws&mws=getall&token=" . $token;
// echo $url;
// pr($_POST);
$contents = file_get_contents($url);
// pr($contents);
$obj = json_decode($contents);
// pr($obj);
// $nn = new MProdModel();
// global $db;
// $db->query("UPDATE {$nn->table_name} SET prod_active = 0",1);
if ($_POST['radio'] == "truncate") {
$nn = new MArticleTagging();
$nn->truncate();
}
// pr($obj);
$num = 0;
$gagal = 0;
$gagalArr = array();
foreach ($obj->results as $new) {
$nn = new MArticleTagging();
$nn->fill(toRow($new));
// $nn->prod_active = 1;
if ($nn->save(1)) {
$num++;
} else {
$gagal++;
$gagalArr = $new->rel_id;
}
}
$json['success'] = $num;
$json['failed'] = $gagal;
$json['failed_arr'] = $gagalArr;
echo json_encode($json);
die;
}
public function getAllMyKelas()
{
global $db;
$kelas = new Kelas();
$q = "SELECT kelas_id,kelas_tingkatan,kelas_name,mk_ta_id FROM {$this->table_murid_kelas},{$kelas->table_name} WHERE mk_murid_id = '{$this->murid_id}' AND mk_kelas_id = kelas_id ORDER BY mk_ta_id ASC";
//echo $q;
$muridkelas = $db->query($q, 2);
//pr($muridkelas);
$newMurid = array();
foreach ($muridkelas as $databasemurid) {
$m = new Kelas();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
return $newMurid;
}
public function loadByUserLogin()
{
//get parameters
$username = $this->admin_username;
$password = $this->admin_password;
$rememberme = $this->rememberme;
$ldap = $this->admin_ldap;
//checksyarat
if (!isset($username) || !isset($password)) {
Redirect::loginFailed();
}
//load from db
global $db;
if (!$ldap) {
$sql = "SELECT * FROM {$this->table_name} WHERE admin_username = '******' AND admin_password = '******' AND admin_aktiv = 1 ";
} else {
$sql = "SELECT * FROM {$this->table_name} WHERE admin_username = '******' AND admin_aktiv = 1 ";
}
$obj = $db->query($sql, 1);
$row = toRow($obj);
$this->fill($row);
if (isset($this->admin_id)) {
$_SESSION["admin_session"] = 1;
$_SESSION["account"] = $obj;
//Update setlastlogin
return self::setLastUpdate($_SESSION["account"]->admin_id);
} else {
return 0;
}
}
function searchCb($word, $accid, $begin = 0, $limit = 20)
{
global $db;
$acc = new Account();
$reply = new InboxReply();
$q = "\n \n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_from = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n )\n UNION\n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_to = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n ) \n ORDER BY inbox_changedate DESC LIMIT {$begin},{$limit}\n \n ";
$arr = $db->query($q, 2);
// pr($arr);
// echo $q;
$newMurid = array();
foreach ($arr as $databasemurid) {
$m = new Inbox();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
//return jumlah totalnya
$q = " \n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_from = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n )\n UNION\n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_to = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n ) \n ";
$arr2 = $db->query($q, 2);
return array("arrMsg" => $newMurid, "total" => count($arr2));
//die();
}
public function getCalInMonthOptimized($mon, $year)
{
global $db;
$q = "SELECT * FROM {$this->table_name} WHERE (YEAR(cal_mulai) = {$year} AND MONTH(cal_mulai) = {$mon}) OR (YEAR(cal_akhir) = {$year} AND MONTH(cal_akhir) = {$mon}) ORDER BY cal_mulai ASC";
$muridkelas = $db->query($q, 2);
$newMurid = array();
$classname = get_called_class();
foreach ($muridkelas as $databasemurid) {
$m = new Calendar();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
return $newMurid;
}
public function getByUsername($username, $readcoloums = "*")
{
global $db;
$q = "SELECT {$readcoloums} FROM {$this->table_name} WHERE admin_username = '******'";
$obj = $db->query($q, 1);
$row = toRow($obj);
$this->fill($row);
$this->load = 1;
}
public function process_login_fb()
{
$email = $_SESSION['sementara']['admin_email'];
$fbid = $_SESSION['sementara']['admin_fb_id'];
if ($fbid == "" || $email == "") {
Redirect::loginFailed();
}
$arr = $this->getWhere("admin_email = '{$email}' AND admin_fb_id='{$fbid}' AND admin_aktiv = 1 ");
if (count($arr) > 0) {
//load by login ID
$obj = $arr[0];
$row = toRow($obj);
$this->fill($row);
if (isset($this->admin_id)) {
$_SESSION["admin_session"] = 1;
$_SESSION["account"] = $obj;
//Update setlastlogin
self::setLastUpdate($_SESSION["account"]->admin_id);
//lanjut
//loading metadata
$meta = new AccountMeta();
$meta->getMeta($this->admin_id);
//now loading roles
$this->loadRole();
//set cookie
Auth::setCookie($this->rememberme, $this->admin_id, $this->admin_email, $this->admin_password);
//kalau sukses
if (Auth::isLogged()) {
//load school setting
// $ss = new Schoolsetting();
// $ss->loadToSession();
//redirect
//Account::setRedirection ();
$acl = new AccountLogin();
Hook::processHook($acl->login_hook);
//login hook doesnt seem to work =>bypass
$qp = new QuizPoints();
$qp->getPoints();
$qp->saveUnsaved();
Redirect::firstPage();
} else {
Redirect::loginFailed();
}
} else {
return 0;
}
}
}
public function getOrderBy($orderAndLimit, $selectedColom = "*")
{
global $db;
$q = "SELECT {$selectedColom} FROM {$this->table_name} ORDER BY {$orderAndLimit}";
$muridkelas = $db->query($q, 2);
//pr($muridkelas);
$newMurid = array();
$classname = get_called_class();
foreach ($muridkelas as $databasemurid) {
$m = new $classname();
$m->fill(toRow($databasemurid));
$newMurid[] = $m;
}
return $newMurid;
}
public function loginMe()
{
//POST
//uname ( username / email )
//pwd
IMBAuth::checkOAuth();
//dapat hash..hash dikirim tiap request
$username = addslashes($_POST["uname"]);
$password = addslashes($_POST["pwd"]);
//checksyarat
if (!isset($username) || $username == "") {
$json['status_code'] = 0;
$json['status_message'] = "Username/Email Empty";
echo json_encode($json);
die;
}
if (!isset($password) || $password == "") {
$json['status_code'] = 0;
$json['status_message'] = "Password Empty";
echo json_encode($json);
die;
}
$acc = new Account();
$sel = "admin_id,admin_username,admin_hash,admin_aktiv,admin_email,admin_nama_depan,admin_password,admin_isAgent,admin_phone,admin_marketer,admin_npwp,admin_ktp,admin_total_paid_sales,admin_total_free_sales";
//load from db
global $db;
$sql = "SELECT {$sel} FROM {$acc->table_name} WHERE (admin_username = '******' OR admin_email = '{$username}') AND admin_aktiv = 1 ";
$obj = $db->query($sql, 1);
$row = toRow($obj);
$acc->fill($row);
if (hash_equals($obj->admin_password, crypt($password, $obj->admin_password))) {
$json['status_code'] = 1;
//unset uneeded data
unset($obj->admin_password);
$newhash = Account::updateHash($obj->admin_id);
$obj->admin_hash = $newhash;
//Update setlastlogin
Account::setLastUpdate($obj->admin_id);
$json['status_message'] = "Login Success";
$json['acc'] = $obj;
echo json_encode($json);
die;
}
$json['status_code'] = 0;
$json['status_message'] = "Username/Email and Password Mismatched";
echo json_encode($json);
die;
}
public static function setSession($data, $remember)
{
$_SESSION['member'] = $data;
$_SESSION['member_token'] = self::generateRandomString(15);
$_SESSION["member_session"] = 1;
$acc = new LL_Account();
$acc->macc_id = $data->macc_id;
$acc->fill(toRow($data));
$acc->macc_login_date = leap_mysqldate();
$acc->macc_token = $_SESSION['member_token'];
$acc->save(1);
self::setCookie($data, $remember, $acc->macc_acquire_date);
return array('id' => $data->macc_id, 'token' => $acc->macc_token, 'name' => $data->macc_first_name . " " . $data->macc_last_name);
}
