public static function portalIndex() { //global $template; //$template->addTextToHead("<script src='"._SPPATH."app/BPlugin/Twitter/js/jquery-1.11.1.js'></script>"); //pr($template); /* * print breadcrumbs */ $t = time(); $getID = TextP::getP("id"); ?> <style> .webapps{ padding: 10px; cursor: pointer; border-bottom: 1px solid #dedede; } .borderless{ border-bottom: 0px; } .fullscreen { width: 100%; height: 100%; position: absolute; z-index: 10000; top:0; left: 0; } .iframeasli{ width: 100%; height: 650px; } </style> <script> function getwidth(){ return window.innerWidth||document.documentElement.clientWidth||document.body.clientWidth||0; } function getheight(){ return window.innerHeight||document.documentElement.clientHeight||document.body.clientHeight||0; } function callfullscreen() { var heit = $(window).height(); var wit = $(window).width(); $('.fullscreen').css({ width: getwidth(), height: getheight() }); // alert('resize'); } /*$(document).ready(function(){ callfullscreen(); });*/ function kerjakanFullScreen(){ $('#wepapps_menu').fadeToggle(); $('#webapps_iframe').toggleClass('col-md-9'); $('#iframeholder').toggleClass('fullscreen').toggleClass('iframeasli'); } //$('#wepapps_menu').fadeToggle();$('#webapps_iframe').toggleClass('fullscreen').toggleClass('col-md-9'); </script> <?php ?> <div onclick="kerjakanFullScreen();" style="position: fixed; padding: 10px; bottom: 0; right: 0; color:white; background-color: rgba(0,0,0,0.3); z-index: 10001;"><i class="glyphicon glyphicon-fullscreen"></i></div> <div class="col-md-3" id="wepapps_menu"> <div style="padding: 10px; background-color: #efefef; border-radius: 5px; margin-right: 10px;"> <?php $wb = new WebAppsPortal(); $chan = Account::getMyChannels(); $all = $wb->getByMyChannels($chan, " AND webapps_tech = 'web' ORDER BY webapps_name ASC"); //$all = $wb->get //pr($chan); //pr($all); foreach ($all as $num => $wp) { $num++; ?> <div id="webapps_<?php echo $wp->webapps_id; ?> _<?php echo $t; ?> " class="webapps <?php if ($num >= count($all)) { ?> borderless<?php } ?> "><?php echo $wp->webapps_name; ?> </div> <script> $('#webapps_<?php echo $wp->webapps_id; ?> _<?php echo $t; ?> ').click(function(){ <?php //if webmail if ($wp->webapps_id == 1) { ?> var url = '<?php echo $wp->webapps_url; ?> '; var win = window.open(url, '_blank'); win.focus(); <?php } else { ?> $("#webapps_iframe").empty().html('<iframe id="iframeholder" class="iframeasli" src="<?php echo $wp->webapps_url; ?> "></iframe> '); <?php } ?> }); <?php if ($getID == $wp->webapps_id) { ?> $(document).ready(function(){ $("#webapps_iframe").empty().html('<iframe id="iframeholder" class="iframeasli" src="<?php echo $wp->webapps_url; ?> "></iframe> '); }); <?php } ?> </script> <?php } ?> </div> </div> <div class="col-md-9" id="webapps_iframe"> <?php //pr($_SESSION); ?> </div> <?php }
public function AccountManagement() { /* * process search */ $s = TextP::getP("word"); $page = TextP::getP("page", 1); $new = TextP::getP("new", 0); if ($new) { $invert_new = 0; } else { $invert_new = 1; } $searchText = ''; if ($s != "") { $searchText = "\r\n WHERE\r\n admin_username LIKE '%{$s}%' OR admin_nama_depan LIKE '%{$s}%'"; if ($new) { $searchText = " AND (admin_username LIKE '%{$s}%' OR admin_nama_depan LIKE '%{$s}%') "; } } /* * sort */ $sort = TextP::getP("sort", "admin_nama_depan"); $ord = TextP::getP("order", "ASC"); $orderText = " {$sort} {$ord}"; /*define order and sort*/ $order = $_SESSION['account_man_order']; if ($order == "") { $order = "ASC"; } elseif ($order == "ASC") { $order = "DESC"; } else { $order = "ASC"; } $_SESSION['account_man_order'] = $order; /* * Pagination */ $limit = 20; $begin = ($page - 1) * $limit; global $db; $acc = new Account(); $rl = new RoleLevel(); $ro = new RoleOrganization(); $am = new AccountMeta(); if ($new) { $q = "SELECT * FROM `core__admin_account` WHERE NOT EXISTS (SELECT * FROM core__admin_account__metadata WHERE core__admin_account.admin_id = core__admin_account__metadata.account_id) {$searchText} ORDER BY\r\n {$orderText} LIMIT {$begin},{$limit}"; $qjumlah = "SELECT count(*) as nr FROM `core__admin_account` WHERE NOT EXISTS (SELECT * FROM core__admin_account__metadata WHERE core__admin_account.admin_id = core__admin_account__metadata.account_id) "; $nr = $db->query($qjumlah, 1); $jml = $nr->nr; } else { //normal query $q = "\r\nSELECT\r\n admin_id,admin_username,admin_nama_depan,admin_role,admin_email,\r\n org.meta_value as org,\r\n level.meta_value as level\r\nFROM {$acc->table_name}\r\n LEFT JOIN {$am->table_name} AS org ON org.account_id = admin_id\r\n AND org.meta_key='RoleOrganization'\r\n LEFT JOIN {$am->table_name} AS level ON level.account_id = admin_id\r\n AND level.meta_key='RoleLevel'\r\n {$searchText} \r\nORDER BY\r\n {$orderText} LIMIT {$begin},{$limit}"; $jml = $acc->getJumlah($searchText); } //echo $q; $arrCal = $db->query($q, 2); //pr($arr); /* * get All Active Department */ $dp = new RoleOrganization(); $arrOrg = $dp->getWhere("organization_active = 1 AND organization_parent_id != 0"); //simpan ke array yang mudah $arrOrg2 = array(); foreach ($arrOrg as $or) { $arrOrg2[$or->organization_id] = $or; } //pr($arrOrg2); /* * get All Active Level */ $dp = new RoleLevel(); $arrOrg = $dp->getWhere("level_active = 1"); //simpan ke array yang mudah $arrLevel = array(); foreach ($arrOrg as $or) { $arrLevel[$or->level_id] = $or; } /* * get All Active Role */ $dp = new Role(); $arrOrg = $dp->getWhere("role_active = 1"); //simpan ke array yang mudah $arrRoles = array(); foreach ($arrOrg as $or) { $arrRoles[$or->role_id] = $or; } $t = time(); ?> <style> .clickable{ cursor: pointer; } </style> <h1><?php echo Lang::t('Account Management'); ?> </h1> <div class="row hidden-print" style="margin-bottom: 10px;"> <div class="col-md-6 col-xs-12"> <div class="input-group"> <input type="text" class="form-control" value="<?php echo $s; ?> " id="Account2Deptsearchpat<?php echo $t; ?> " placeholder="<?php echo Lang::t('Username'); ?> ,<?php echo Lang::t('Name'); ?> "> <span class="input-group-btn"> <button class="btn btn-default" id="Account2Deptsearchpat2_<?php echo $t; ?> " type="button"><?php echo Lang::t('Search'); ?> </button> </span> <span class="input-group-btn"> <button class="btn btn-default <?php if ($new) { ?> btn-warning<?php } ?> " id="Account2Deptsearchpat2b_<?php echo $t; ?> " type="button"><?php echo Lang::t('w/o Departments and Level'); ?> </button> </span> </div> <!-- /input-group --> <script type="text/javascript"> $("#Account2Deptsearchpat2_<?php echo $t; ?> ").click(function () { var slc = encodeURI($('#Account2Deptsearchpat<?php echo $t; ?> ').val()); openLw(window.selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=1&new=<?php echo $new; ?> &word=' + slc, 'fade'); }); $("#Account2Deptsearchpat<?php echo $t; ?> ").keyup(function (event) { if (event.keyCode == 13) { //on enter var slc = encodeURI($('#Account2Deptsearchpat<?php echo $t; ?> ').val()); openLw(selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=1&new=<?php echo $new; ?> &word=' + slc, 'fade'); } }); $('#Account2Deptsearchpat2b_<?php echo $t; ?> ').click(function(){ var slc = encodeURI($('#Account2Deptsearchpat<?php echo $t; ?> ').val()); openLw(window.selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=1&new=<?php echo $invert_new; ?> &word=' + slc, 'fade'); }); </script> </div> </div> <table class="table table-bordered table-striped table-hover" style="background-color: white;"> <thead> <tr> <th class="clickable" onclick="openLw(selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page; ?> &word=<?php echo $s; ?> &sort=admin_id&order=<?php echo $order; ?> ', 'fade');"><?php echo Lang::t('ID'); ?> </th> <th class="clickable" onclick="openLw(selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page; ?> &word=<?php echo $s; ?> &sort=admin_username&order=<?php echo $order; ?> ', 'fade');"><?php echo Lang::t('Email'); ?> </th> <th class="clickable" onclick="openLw(selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page; ?> &word=<?php echo $s; ?> &sort=admin_nama_depan&order=<?php echo $order; ?> ', 'fade');"><?php echo Lang::t('Name'); ?> </th> <th class="clickable" onclick="openLw(selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page; ?> &word=<?php echo $s; ?> &sort=admin_role&order=<?php echo $order; ?> ', 'fade');"><?php echo Lang::t('Role'); ?> </th> <th class="clickable" onclick="openLw(selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page; ?> &word=<?php echo $s; ?> &sort=org.meta_value&order=<?php echo $order; ?> ', 'fade');"><?php echo Lang::t('Department'); ?> </th> <th class="clickable" onclick="openLw(selected_page, '<?php echo _SPPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page; ?> &word=<?php echo $s; ?> &sort=level.meta_value&order=<?php echo $order; ?> ', 'fade');"><?php echo Lang::t('Level'); ?> </th> <th><?php echo Lang::t('Action'); ?> </th> </tr> </thead> <tbody> <?php foreach ($arrCal as $acc) { ?> <tr> <td><?php echo $acc->admin_id; ?> </td> <td><?php echo $acc->admin_email; ?> </td> <td><input id="name_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> " type="text" value="<?php echo $acc->admin_nama_depan; ?> " class="form-control"></td> <td> <select id="role_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> " class="form-control"> <?php foreach ($arrRoles as $id => $org) { ?> <option <?php if ($id == $acc->admin_role) { echo "selected"; } ?> value="<?php echo $id; ?> "><?php echo $org->role_name; ?> </option> <?php } ?> </select> </td> <td> <select id="org_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> " class="form-control"> <?php foreach ($arrOrg2 as $id => $org) { ?> <option <?php if ($id == $acc->org) { echo "selected"; } ?> value="<?php echo $id; ?> "><?php echo $org->organization_name; ?> </option> <?php } ?> </select> </td> <td> <select id="level_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> " class="form-control"> <?php foreach ($arrLevel as $id => $org) { ?> <option <?php if ($id == $acc->level) { echo "selected"; } ?> value="<?php echo $id; ?> "><?php echo $org->level_name; ?> </option> <?php } ?> </select> </td> <td><button id="updater_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> " class="btn btn-default"><?php echo Lang::t('update'); ?> </button></td> <script> $("#updater_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> ").click(function(){ var name = encodeURI($("#name_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> ").val()); var role = encodeURI($("#role_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> ").val()); var lvl = encodeURI($("#level_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> ").val()); var org = encodeURI($("#org_<?php echo $acc->admin_id; ?> _<?php echo $t; ?> ").val()); $.post("<?php echo _LANGPATH; ?> PortalAdminWeb/updater",{ id : '<?php echo $acc->admin_id; ?> ', name :name, lvl : lvl, org : org, role : role },function(data){ console.log(data.post); console.log(data.isi); if(data.bool)alert('<?php echo Lang::t('Update Succesful'); ?> '); else alert(data.err); },'json'); }); </script> </tr> <?php } ?> </tbody> </table> <?php $halaman = $page; $jmlpage = ceil($jml / $limit); ?> <nav> <ul class="pagination"> <?php if ($halaman > 1) { ?> <li><a class="clickable" onclick="openLw(selected_page,'<?php echo _LANGPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page - 1; ?> &word=<?php echo $s; ?> &sort=<?php echo $sort; ?> &order=<?php echo $order; ?> &new=<?php echo $new; ?> ','fade');"><span aria-hidden="true">«</span><span class="sr-only">Previous</span></a></li> <?php } ?> <?php //ambil 3 bh terdekat // $mulai = $halaman - 2; $akhir = $halaman + 2; //echo $mulai.$akhir; $min = max($mulai, 1); $max = min($akhir, $jmlpage); //echo "<br> max :".$max; //echo "<br> min :".$min; for ($x = $min; $x <= $max; $x++) { ?> <li <?php if ($x == $halaman) { ?> class="active"<?php } ?> ><a onclick="openLw(selected_page,'<?php echo _LANGPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $x; ?> &word=<?php echo $s; ?> &sort=<?php echo $sort; ?> &order=<?php echo $order; ?> &new=<?php echo $new; ?> ','fade');"><?php echo $x; ?> </a></li> <?php } ?> <?php if ($jml > $begin + $limit) { ?> <li><a class="clickable" onclick="openLw(selected_page,'<?php echo _LANGPATH; ?> PortalAdminWeb/AccountManagement?page=<?php echo $page + 1; ?> &word=<?php echo $s; ?> &sort=<?php echo $sort; ?> &order=<?php echo $order; ?> &new=<?php echo $new; ?> ','fade');"><span aria-hidden="true">»</span><span class="sr-only">Next</span></a></li> <?php } ?> </ul> </nav> <h4><?php echo $jml; ?> <?php echo Lang::t('results in'); ?> <?php echo $jmlpage; ?> <?php echo Lang::t('pages'); ?> </h4> <?php }