API tools faq
paste
Advertisement
punces

voucher_model.php

punces
Jun 1st, 2017
311
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.64 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. if (!defined('BASEPATH'))
  3. exit('No direct script access allowed');
  4.  
  5. class Voucher_model extends CI_Model {
  6.  
  7. function __construct() {
  8. parent::__construct();
  9. $this->load->model('stator');
  10. $this->load->model('log');
  11. }
  12.  
  13. //***MODEL VOUCHER.start
  14. function prosesGenerateVoucher($data = array()) {
  15. if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) { //.cek paka proxy atau tidak?
  16. $iptujuan = $_SERVER['HTTP_X_FORWARDED_FOR']; //pakai proxy
  17. } else {
  18. $iptujuan = $_SERVER['REMOTE_ADDR']; //tanpa proxy
  19. }
  20.  
  21. $namavoucher = $data['namavoucher'];
  22. $qty = $data['qty'];
  23. $userprofile = $data['userprofile'];
  24. $limituptime = $data['limituptime'];
  25. $tipepassword = $data['tipepassword'];
  26. $password = $data['password'];
  27. //$chars = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
  28. $chars = "0123456789abcdefghijklmnopqrstuvwxyz";
  29. ?>
  30. <style>
  31. table td, table th{font-size:11px;}
  32. .nowrap {white-space:nowrap;}
  33. </style>
  34. <div class="table-responsive">
  35. <h3 style="color:#008899;">Voucher <span style="color:#ff7777"><?php echo $namavoucher; ?></span></h3>
  36. <table class="table table-hover table-striped table-condensed table-bordered" id="table_generate_voucher" data-order='[[ 0, "asc" ]]'>
  37. <thead>
  38. <tr>
  39. <th class="text-nowrap" title="menu order">NO</th>
  40. <th class="text-nowrap" title="menu name">USERNAME</th>
  41. <th class="text-nowrap" title="menu link">PASSWORD</th>
  42. <th class="text-nowrap" title="menu link">USER PROFILE</th>
  43. <th class="text-nowrap" title="menu link">LIMIT UPTIME</th>
  44. </tr>
  45. </thead>
  46. <tbody>
  47. <?php
  48. date_default_timezone_set('Asia/Jakarta');
  49. for ($n = 1; $n <= $qty; $n++) {
  50. $res1 = '';
  51. $res2 = '';
  52. for ($i = 0; $i < 6; $i++) {
  53. $res1 .= $chars[mt_rand(0, strlen($chars) - 1)];
  54. }
  55. if ($tipepassword == 'at') {
  56. for ($i = 0; $i < 6; $i++) {
  57. $res2 .= $chars[mt_rand(0, strlen($chars) - 1)];
  58. }
  59. }
  60. if ($tipepassword == 'sm') {
  61. $res2 = $res1;
  62. }
  63. if ($tipepassword == 'mt') {
  64. $res2 = $password;
  65. }
  66. // } else {
  67. // $res2 = $password;
  68. // }
  69.  
  70.  
  71. $user = $res1;
  72. $password = $res2;
  73. $userprofile = $userprofile;
  74. $limit_uptime = $limituptime;
  75. $server = 'all';
  76.  
  77. $data = array(
  78. 'user' => $user,
  79. 'password' => $password,
  80. 'userprofile' => $userprofile,
  81. 'limit_uptime' => $limit_uptime,
  82. 'server' => $server,
  83. 'comment' => $namavoucher,
  84. );
  85.  
  86. $ARRAY = $this->mikrostator->addHotspotUserVoucher($data);
  87. if ($ARRAY[0] == "!done") { //.0 berarti tidak ada pesan tambahan/sukses
  88. $msg = "sukses";
  89. } else {
  90. $msg = "gagal";
  91. }
  92.  
  93. //.insert to db.begin
  94. $datax = array(
  95. 'voucher_name' => $namavoucher,
  96. 'voucher_username' => $res1,
  97. 'voucher_password_type' => $tipepassword,
  98. 'voucher_password' => $res2,
  99. 'voucher_qty' => $qty,
  100. 'voucher_user_profile' => $userprofile,
  101. 'voucher_limit_uptime' => $limituptime,
  102. 'voucher_status' => $msg,
  103. );
  104. $this->db->insert('wk_voucher', $datax);
  105. //.insert to db.end
  106. ?>
  107. <tr>
  108. <td class="text-nowrap"><?php echo $n; ?></td>
  109. <td class="text-nowrap"><?php echo $res1; ?></td>
  110. <td class="text-nowrap"><?php echo $res2; ?></td>
  111. <td class="text-nowrap"><?php echo $userprofile; ?></td>
  112. <td class="text-nowrap"><?php echo $limituptime; ?></td>
  113. </tr>
  114. <?php
  115. }
  116. ?>
  117. </tbody>
  118. </table>
  119. </div>
  120. <script>
  121. $(document).ready(function() {
  122. $('#table_generate_voucher').DataTable({
  123. });
  124. });
  125. </script>
  126. <?php
  127. }
  128.  
  129. function getVoucherList($data = array()) {
  130. $namavoucher = $data['namavoucher'];
  131. ?>
  132. <style>
  133. table td, table th{font-size:11px;}
  134. .nowrap {white-space:nowrap;}
  135. </style>
  136. <div class="table-responsive">
  137. <h3 style="color:#008899;">Voucher <span style="color:#ff7777"><?php echo $namavoucher; ?></span></h3>
  138. <table class="table table-hover table-striped table-condensed table-bordered" id="table_generate_voucher" data-order='[[ 0, "asc" ]]'>
  139. <thead>
  140. <tr>
  141. <th class="text-nowrap">NO</th>
  142. <th class="text-nowrap">USERNAME</th>
  143. <th class="text-nowrap">PASSWORD</th>
  144. <th class="text-nowrap">USER PROFILE</th>
  145. <th class="text-nowrap">LIMIT UPTIME</th>
  146. <th class="text-nowrap">STATUS</th>
  147. </tr>
  148. </thead>
  149. <tbody>
  150. <?php
  151. date_default_timezone_set('Asia/Jakarta');
  152. $this->db->select('*');
  153. $this->db->from('wk_voucher');
  154. $this->db->where('voucher_name', $namavoucher);
  155. $query = $this->db->get();
  156. $n = 0;
  157. foreach ($query->result() as $row) {
  158. $n++;
  159. $res1 = $row->voucher_username;
  160. $res2 = $row->voucher_password;
  161. $userprofile = $row->voucher_user_profile;
  162. $limituptime = $row->voucher_limit_uptime;
  163. $status = $row->voucher_status;
  164. ?>
  165. <tr>
  166. <td class="text-nowrap"><?php echo $n; ?></td>
  167. <td class="text-nowrap"><?php echo $res1; ?></td>
  168. <td class="text-nowrap"><?php echo $res2; ?></td>
  169. <td class="text-nowrap"><?php echo $userprofile; ?></td>
  170. <td class="text-nowrap"><?php echo $limituptime; ?></td>
  171. <td class="text-nowrap"><?php echo $status; ?></td>
  172. </tr>
  173. <?php
  174. }
  175. ?>
  176. </tbody>
  177. </table>
  178. </div>
  179. <script>
  180. $(document).ready(function() {
  181. $('#table_generate_voucher').DataTable({
  182. });
  183. });
  184. </script>
  185. <?php
  186. }
  187.  
  188. function getVoucherUsed($data = array()) {
  189. $namavoucher = $data['namavoucher'];
  190. ?>
  191. <style>
  192. table td, table th{font-size:11px;}
  193. .nowrap {white-space:nowrap;}
  194. </style>
  195. <div class="table-responsive">
  196. <h3 style="color:#008899;">Voucher <span style="color:#ff7777"><?php echo $namavoucher; ?></span></h3>
  197. <table class="table table-hover table-striped table-condensed table-bordered" id="table_voucher_used" data-order='[[ 0, "asc" ]]'>
  198. <thead>
  199. <tr>
  200. <th class="text-nowrap" title="name">NAMA</th>
  201. <th class="text-nowrap" title="password">SANDI</th>
  202. <th class="text-nowrap" title="profile">PROFIL</th>
  203. <th class="text-nowrap" title="sisa" style="background:#ffcc99;">SISA</th>
  204. <th class="text-nowrap" title="limit-uptime">BATAS</th>
  205. <th class="text-nowrap" title="uptime">DIPAKAI</th>
  206. <th class="text-nowrap" title="bytes-in">UP (MB)</th>
  207. <th class="text-nowrap" title="bytes-out">DOWN (MB)</th>
  208. <th class="text-nowrap" title="comment">KOMENTAR</th>
  209. <th class="text-nowrap" title="sisa menit">SM</th>
  210. <th class="text-nowrap" title="nyawa"><center><span class="glyphicon glyphicon-time" aria-hidden="true"></span></center></th>
  211. <th class="text-nowrap" title="status">STATUS</th>
  212. </tr>
  213. </thead>
  214. <tbody>
  215. <?php
  216. date_default_timezone_set('Asia/Jakarta');
  217. $query = $this->mikrostator->baca("/ip/hotspot/user/print", array(
  218. "?comment" => $namavoucher,
  219. ));
  220. foreach ($query as $row):
  221. $uid = $row['.id'];
  222. $name = $row['name'];
  223. $password = $row['password'];
  224. $profile = $row['profile'];
  225. $limit_uptime = "";
  226. if (isset($row['limit-uptime'])) {
  227. $limit_uptime = $row['limit-uptime'];
  228. }
  229. $uptime = $row['uptime'];
  230. $bytes_in = $row['bytes-in'];
  231. $bytes_out = $row['bytes-out'];
  232. $comment = isset($row['comment'])?$row['comment']:'';
  233. $disabled = $row['disabled'];
  234. $sisa_time = $this->stator->time_elapsed_A($this->stator->get_menit($limit_uptime, 's') - $this->stator->get_menit($uptime, 's'));
  235. $status = 'hidup';
  236. $status_msg = '';
  237. $hidup_mati = 'hidup';
  238. if ($disabled == 'true') {
  239. $status = 'mati';
  240. $status_msg = "style='background-color:#ffaaaa;color:#aaa;' title='tidak aktif (mati)'";
  241. $hidup_mati = 'mati';
  242. }
  243. //.list hotspot user.end
  244. ?>
  245. <tr <?php echo $status_msg; ?>>
  246. <td class="text-nowrap"><?php echo $name; ?></td>
  247. <td class="text-nowrap" title="<?php echo $password; ?>">***</td>
  248. <td class="text-nowrap"><?php echo $profile; ?></td>
  249. <td class="text-nowrap" style="background:#ffdfbf;" title="<?php echo "PC:Rp." . floor(($this->stator->get_menit($sisa_time, 's') / 3600) * 2500) . "|" . "HP:Rp." . floor(($this->stator->get_menit($sisa_time, 's') / 3600) * 2000); ?>"><?php echo $sisa_time; ?></td>
  250. <td class="text-nowrap"><?php echo $limit_uptime; ?></td>
  251. <td class="text-nowrap"><?php echo $uptime; ?></td>
  252. <td class="text-nowrap" title="<?php echo $bytes_in; ?>"><?php echo number_format($bytes_in / 1024 / 1024, 2); ?></td>
  253. <td class="text-nowrap" title="<?php echo $bytes_out; ?>"><?php echo number_format($bytes_out / 1024 / 1024, 2); ?></td>
  254. <td class="text-nowrap"><?php echo $comment; ?></td>
  255. <td class="text-nowrap"><?php echo $this->stator->get_menit($sisa_time, 'm'); ?></td>
  256. <td class="text-nowrap"><?php echo $this->stator->get_menit($sisa_time, 's'); ?></td>
  257. <td class="text-nowrap" title="<?php echo $status; ?>"><?php echo $hidup_mati; ?></td>
  258. </tr>
  259. <?php
  260. endforeach;
  261. ?>
  262. </tbody>
  263. </table>
  264. </div>
  265. <script>
  266. $(document).ready(function() {
  267. $('#table_voucher_used').DataTable({
  268. });
  269. });
  270. </script>
  271. <?php
  272. }
  273.  
  274. function getVoucherName() {
  275. $this->db->select('voucher_name');
  276. $this->db->from('wk_voucher');
  277. $this->db->distinct();
  278. $query = $this->db->get();
  279. return $query->result();
  280. }
  281.  
  282. function getVoucherByName($nama) {
  283. $this->db->select('voucher_name');
  284. $this->db->from('wk_voucher');
  285. $this->db->where('voucher_name', $nama);
  286. return $this->db->count_all_results();
  287. }
  288.  
  289. function prosesHapusVoucherList($data = array()) {
  290.  
  291. if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) { //.cek paka proxy atau tidak?
  292. $iptujuan = $_SERVER['HTTP_X_FORWARDED_FOR']; //pakai proxy
  293. } else {
  294. $iptujuan = $_SERVER['REMOTE_ADDR']; //tanpa proxy
  295. }
  296.  
  297. $namavoucher = $data['namavoucher'];
  298.  
  299. $this->db->select('*');
  300. $this->db->from('wk_voucher');
  301. $this->db->where('voucher_name', $namavoucher);
  302. $query = $this->db->get();
  303. foreach ($query->result() as $row) {
  304. $nama = $row->voucher_username;
  305. $ARRAY = $this->mikrostator->delHotspotUserByName($nama);
  306. /*
  307. return count($ARRAY);
  308. if (count($ARRAY) == 0) { //.0 berarti tidak ada pesan tambahan/sukses
  309. $msg = "dihapus";
  310. //.update to db.begin
  311. $datax = array(
  312. 'voucher_status' => $msg,
  313. );
  314. $this->db->where('voucher_username', $user);
  315. $this->db->update('wk_voucher', $data);
  316. //.update to db.end
  317. } else {
  318. $msg = "gagal dihapus";
  319. //.update to db.begin
  320. $datax = array(
  321. 'voucher_status' => $msg,
  322. );
  323. $this->db->where('voucher_username', $user);
  324. $this->db->update('wk_voucher', $data);
  325. //.update to db.end
  326. }
  327. *
  328. */
  329. $this->db->where('voucher_username', $row->voucher_username);
  330. $this->db->delete('wk_voucher');
  331. }
  332.  
  333. if ($this->getVoucherByName($nama) == 0) {
  334. $msg = "VOUCHER $nama BERHASIL DIHAPUS via $iptujuan";
  335. $this->log->writeLog($msg);
  336. return $msg;
  337. } else {
  338. $msg = "GAGAL MENGHAPUS VOUCHER $nama, SILAHKAN COBA LAGI!. msg: " . $this->db->_error_message();
  339. $this->log->writeLog($msg);
  340. return $msg;
  341. }
  342. }
  343.  
  344. function prosesCetakVoucherList($data = array()) {
  345. $namavoucher = $data['namavoucher'];
  346. ?>
  347. <style>
  348. table td, table th{font-size:11px;}
  349. .nowrap {white-space:nowrap;}
  350. </style>
  351. <div class="table-responsive">
  352. <h3 style="color:#008899;">Voucher <span style="color:#ff7777"><?php echo $namavoucher; ?></span></h3>
  353. <?php
  354. date_default_timezone_set('Asia/Jakarta');
  355. $this->db->select('*');
  356. $this->db->from('wk_voucher');
  357. $this->db->where('voucher_name', $namavoucher);
  358. $query = $this->db->get();
  359. $n = 0;
  360. foreach ($query->result() as $row) {
  361. $n++;
  362. $res1 = $row->voucher_username;
  363. $res2 = $row->voucher_password;
  364. $userprofile = $row->voucher_user_profile;
  365. $limituptime = $row->voucher_limit_uptime;
  366. ?>
  367.  
  368. <table style="display: inline-block; border: 1px solid #ccc; font-family: arial; font-size: 12px; margin: 1px;">
  369. <tr style="border-bottom:1px solid #ccc;background:#ddd;">
  370. <th style="text-align: center" colspan="2"><span style="padding:10px;font-size:15px;">SAFIRA HOTSPOT</span></th>
  371. </tr>
  372. <tr>
  373. <td><span style="padding:5px;">USERNAME</span></td><td><span style="padding:5px;"><b><?php echo $res1; ?></b></span></td>
  374. </tr>
  375. <tr>
  376. <td><span style="padding:5px;">PASSWORD</span></td><td><span style="padding:5px;"><b><?php echo $res2; ?></b></span></td>
  377. </tr>
  378. <tr style="border-bottom:1px solid #ccc;">
  379. <td style="text-align: center" colspan="2"><span style="padding:50px;">Voucher : <?php echo $namavoucher; ?></span></td>
  380. </tr>
  381. </table>
  382. <?php
  383. }
  384. ?>
  385. <?php
  386. }
  387.  
  388. function prosesCetakVoucherList2($namavoucher) {
  389. $namavoucher = rawurldecode($namavoucher);
  390. ?>
  391. <script>
  392. window.onload = function() {
  393. window.print();
  394. }
  395. </script>
  396. <style>
  397. table td, table th{font-size:11px;}
  398. .nowrap {white-space:nowrap;}
  399. </style>
  400. <div class="table-responsive">
  401. <?php
  402. date_default_timezone_set('Asia/Jakarta');
  403. $this->db->select('*');
  404. $this->db->from('wk_voucher');
  405. $this->db->where('voucher_name', $namavoucher);
  406. $this->db->where('voucher_status', 'sukses');
  407. $query = $this->db->get();
  408. $n = 0;
  409. foreach ($query->result() as $row) {
  410. $n++;
  411. $res1 = $row->voucher_username;
  412. $res2 = $row->voucher_password;
  413. $userprofile = $row->voucher_user_profile;
  414. $limituptime = $row->voucher_limit_uptime;
  415. ?>
  416.  
  417. <table style="display: inline-block; border: 1px solid #ccc; font-family: arial; font-size: 12px; margin: 2px;">
  418. <tr style="border-bottom:1px solid #ccc;background:#ddd;">
  419. <th style="text-align: center" colspan="2"><span style="padding:10px;font-size:15px;">*SAFIRA HOTSPOT*</span></th>
  420. </tr>
  421. <tr>
  422. <td><span style="padding:5px;">USERNAME</span></td><td><span style="padding:5px;"><b><?php echo $res1; ?></b></span></td>
  423. </tr>
  424. <tr>
  425. <td><span style="padding:5px;">PASSWORD</span></td><td><span style="padding:5px;"><b><?php echo $res2; ?></b></span></td>
  426. </tr>
  427. <tr>
  428. <td><span style="padding:5px;">LIMIT</span></td><td><span style="padding:5px;"><b><?php echo $limituptime; ?></b></span></td>
  429. </tr>
  430. <tr>
  431. <td colspan='2'><span style="padding:5px;font-size:9px;">w=minggu,d=hari,h=jam,m=menit,s=detik</span></td></td>
  432. </tr>
  433. <tr style="border-bottom:1px solid #ccc;background:#eee;">
  434. <td style="text-align: center" colspan="2"><span style="color:#008899;">Voucher <span style="color:#ff7777"><?php echo $namavoucher; ?></span></span></td>
  435. </tr>
  436. </table>
  437. <?php
  438. }
  439. ?>
  440. <?php
  441. }
  442.  
  443. //***MODEL VOUCHER.end
  444. }
  445.  
  446. /* End of file voucher_model.php */
  447. /* Location: ./application/models/voucher_model.php */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!