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); }