\n
\';
\n }
\n $ret .= "
\n \';
\n $ret .= \'
\';
\n $ret .= \'\';
\n $ret .= \'
\n
\n "; print_r($js); echo ""; \n //beli=add inout=1; jual=minus; inout=2 \n $sql4 = "select id from product_trx order by id desc limit 1"; \n $res4 = mysqli_query($db, $sql4); \n $rw4 = mysqli_fetch_assoc($res4); \n if(isset($rw4) && $rw4[\'id\']>0) { \n $id2=$rw4[\'id\']+1; \n } else { \n $id2=1; \n } \n $idt=array( \n \'id\'=>$id2, \n \'action_at\'=>$js[\'action_at\'], \n \'action_id\'=>$js[\'action_id\'], \n \'product_id\'=>$js[\'product_id\'], \n \'item_code\'=>$js[\'item_code\'], \n \'inout\'=>$js[\'inout\'], \n \'invoice\'=>$js[\'invoice\'], \n \'remark\'=>$js[\'descr\'], \n \'year\'=>date("Y",$js[\'action_at\']), \n \'month\'=>date("Ym",$js[\'action_at\']), \n \'tgl\'=>date("Y-m-d",$js[\'action_at\']), \n \'update_at\'=>time(), \n ); \n $udt=array( \n \'action_at\'=>$js[\'action_at\'], \n \'action_id\'=>$js[\'action_id\'], \n \'product_id\'=>$js[\'product_id\'], \n \'item_code\'=>$js[\'item_code\'], \n \'inout\'=>$js[\'inout\'], \n \'invoice\'=>$js[\'invoice\'], \n \'remark\'=>$js[\'descr\'], \n \'year\'=>date("Y",$js[\'action_at\']), \n \'month\'=>date("Ym",$js[\'action_at\']), \n \'tgl\'=>date("Y-m-d",$js[\'action_at\']), \n \'update_at\'=>time(), \n ); \n if($js[\'inout\']==1) { \n $idt[\'item_in\']=$udt[\'item_in\']=$js[\'qty\']; \n } else { \n $idt[\'item_out\']=$udt[\'item_out\']=$js[\'qty\']; \n } \n InsertUpdate($db,"product_trx",$idt,$udt,0); \n}','php','0','2','2','1748504043'); INSERT INTO `cp_sphp` VALUES('18','app','JournalCount','function JournalCount($year) { \n global $db,$ar; \n $sql6="update account set sel2=0"; \n $res6=mysqli_query($db,$sql6); \n $sql3="SELECT * from action order by action_at,seq"; \n $res3=mysqli_query($db,$sql3); \n while($r3=mysqli_fetch_assoc($res3)) { \n $udt3=array( \n \'seq\'=>$r3[\'seq\'], \n ); \n Update($db,"journal",$udt3,"action_id=".$r3[\'id\'],0); \n Update($db,"transaction",$udt3,"action_id=".$r3[\'id\'],0); \n } \n $sql="SELECT account_code from journal group by account_code"; \n $res=mysqli_query($db,$sql); \n while($r1=mysqli_fetch_assoc($res)) { \n $sql2="SELECT * from journal where year=".$year." and account_code=\'".$r1[\'account_code\']."\' order by action_at asc, seq asc"; \n //echo $sql2."
"; print_r($r4); echo ""; \n \n if($r4[\'debit\']==0) { \n $amount=$r4[\'kredit\']; \n $inout=2; \n $payto="Mandiri IDR ".substr($r4[\'rek\'],-3); \n $payfrom=""; \n } else { \n $amount=$r4[\'debit\']; \n $inout=1; \n $payfrom="Mandiri IDR ".substr($r4[\'rek\'],-3); \n $payto=""; \n } \n \n if($r4[\'payto\']!=\'\') { \n $payto2=$r4[\'payto\']; \n } else { \n $payto2=$payto; \n } \n \n $sql3 = "select * from action where bank=1 and amount=".$amount." and tgl=\'".$r4[\'tgl\']."\'"; \n echo $sql3."
"; print_r($r3); echo ""; \n $udt=array( \n \'action_id\'=>$r3[\'id\'], \n ); \n Update($db,"mandiri_mutasi",$udt,"id=".$r4[\'id\'],1); \n \n } else { \n $sql2 = "select id from action where id2=id order by id desc limit 1"; \n $res2 = mysqli_query($db, $sql2); \n $r2 = mysqli_fetch_assoc($res2); \n $id2=$r2[\'id\']+1; \n $idt=array( \n \'id\'=>$id2, \n \'action_at\'=>$r4[\'tgl2\'], \n \'tgl\'=>$r4[\'tgl\'], \n \'month\'=>$r4[\'month\'], \n \'year\'=>$r4[\'year\'], \n \'descr\'=>$r4[\'keterangan\']." ".$r4[\'remark\'], \n \'pay_to\'=>$payto2, \n \'pay_from\'=>$payfrom, \n \'cat\'=>$inout, \n \'seq\'=>$r4[\'seq\'], \n \'inout\'=>$inout, \n \'bank\'=>$ar[\'manp\'][$r4[\'rek\']], \n \'amount\'=>$amount, \n \'st\'=>1, \n \'update_at\'=>time(), \n ); \n Insert($db,"action",$idt,1); \n tool_id3("action"); \n $udt=array( \n \'action_id\'=>$id2, \n ); \n Update($db,"mandiri_mutasi",$udt,"id=".$r4[\'id\'],1); \n } \n}','php','0','2','2','1748499718'); INSERT INTO `cp_sphp` VALUES('21','app','SalesAction','function SalesAction($p,$v=0) { \n global $db,$ar; \n //echo "
"; print_r($p); echo ""; \n $ar[\'act_desc\'][1]=\'Penerimaan tunai atas\'; \n $ar[\'act_bank\'][1]=1; \n $ar[\'act__cat\'][1]=1; \n \n $ar[\'act_desc\'][2]=\'Piutang kredit \'.$p[\'days_due_date\'].\' atas\'; \n $ar[\'act_bank\'][2]=0; \n $ar[\'act__cat\'][2]=7; //piutang \n \n //cek dulu ref id, \n $sql1 = "select id,reff_sales_id from `action` where reff_sales_id=".$p[\'id\']; \n $res1 = mysqli_query($db, $sql1); \n if(mysqli_num_rows($res1)==0) { \n //insert \n $sql4 = "select * from `action` order by id desc limit 1"; \n $res4 = mysqli_query($db, $sql4); \n $r4 = mysqli_fetch_assoc($res4); \n $id1=$r4[\'id\']+1; \n $id2=$r4[\'id\']+2; \n \n $idt1=array( \n \'id\'=>$id1, \n \'action_at\'=>strtotime($p[\'sales_at\']), \n \'reff_sales_id\'=>$p[\'id\'], \n \'pay_from\'=>$p[\'buyer\'], \n \'invoice\'=>$p[\'invoice\'], \n \'inout\'=>1, \n \'descr\'=>$p[\'descr\'], \n \'bank\'=>0, \n \'cat\'=>4, \n \'amount\'=>$p[\'qty\']*$p[\'hpp\'], \n \'year\'=>date("Y",strtotime($p[\'sales_at\'])), \n \'month\'=>date("Ym",strtotime($p[\'sales_at\'])), \n \'tgl\'=>date("Y-m-d",strtotime($p[\'sales_at\'])), \n \'update_at\'=>time(), \n ); \n Insert($db,"action",$idt1,$v); \n $idt2=array( \n \'id\'=>$id2, \n \'action_at\'=>strtotime($p[\'sales_at\']), \n \'reff_sales_id\'=>$p[\'id\'], \n \'pay_from\'=>$p[\'buyer\'], \n \'invoice\'=>$p[\'invoice\'], \n \'inout\'=>1, \n \'descr\'=>$ar[\'act_desc\'][$p[\'cash_credit\']]." ".$p[\'descr\'], \n \'bank\'=>$ar[\'act_bank\'][$p[\'cash_credit\']], \n \'cat\'=>$ar[\'act__cat\'][$p[\'cash_credit\']], \n \'amount\'=>$p[\'qty\']*$p[\'price\'], \n \'year\'=>date("Y",strtotime($p[\'sales_at\'])), \n \'month\'=>date("Ym",strtotime($p[\'sales_at\'])), \n \'tgl\'=>date("Y-m-d",strtotime($p[\'sales_at\'])), \n \'update_at\'=>time(), \n ); \n Insert($db,"action",$idt2,$v); \n $udt_41=array( \n \'action_id_1\'=>$id1, \n \'action_id_2\'=>$id2, \n ); \n Update($db,"sales",$udt_41,"id=".$p[\'id\'],$v); \n //catat di product_trx \n $p[\'action_at\']=strtotime($p[\'sales_at\']); \n $p[\'inout\']=2; \n $p[\'remark\']=$p[\'descr\']; \n $p[\'action_id\']=$id1; \n product_trx($p); \n \n \n } else { \n $sql2=$sql1." order by id"; \n $res2 = mysqli_query($db, $sql2); \n $dt=array(); \n while($r2=mysqli_fetch_assoc($res2)) { \n $dt[\'id\'][]=$r2[\'id\']; \n } \n $udt1=array( \n \'action_at\'=>strtotime($p[\'sales_at\']), \n \'reff_sales_id\'=>$p[\'id\'], \n \'pay_from\'=>$p[\'buyer\'], \n \'invoice\'=>$p[\'invoice\'], \n \'inout\'=>1, \n \'descr\'=>$p[\'descr\'], \n \'bank\'=>0, \n \'cat\'=>4, \n \'amount\'=>$p[\'qty\']*$p[\'hpp\'], \n \'year\'=>date("Y",strtotime($p[\'sales_at\'])), \n \'month\'=>date("Ym",strtotime($p[\'sales_at\'])), \n \'tgl\'=>date("Y-m-d",strtotime($p[\'sales_at\'])), \n \'update_at\'=>time(), \n ); \n Update($db,"action",$udt1,"id=".$dt[\'id\'][0],$v); \n $udt2=array( \n \'action_at\'=>strtotime($p[\'sales_at\']), \n \'reff_sales_id\'=>$p[\'id\'], \n \'pay_from\'=>$p[\'buyer\'], \n \'invoice\'=>$p[\'invoice\'], \n \'inout\'=>1, \n \'descr\'=>$ar[\'act_desc\'][$p[\'cash_credit\']]." ".$p[\'descr\'], \n \'bank\'=>$ar[\'act_bank\'][$p[\'cash_credit\']], \n \'cat\'=>$ar[\'act__cat\'][$p[\'cash_credit\']], \n \'amount\'=>$p[\'qty\']*$p[\'price\'], \n \'year\'=>date("Y",strtotime($p[\'sales_at\'])), \n \'month\'=>date("Ym",strtotime($p[\'sales_at\'])), \n \'tgl\'=>date("Y-m-d",strtotime($p[\'sales_at\'])), \n \'update_at\'=>time(), \n ); \n Update($db,"action",$udt2,"id=".$dt[\'id\'][1],$v); \n $udt_41=array( \n \'action_id_1\'=>$dt[\'id\'][0], \n \'action_id_2\'=>$dt[\'id\'][1], \n ); \n Update($db,"sales",$udt_41,"id=".$p[\'id\'],$v); \n //catat di product_trx \n $p[\'action_at\']=strtotime($p[\'sales_at\']); \n $p[\'inout\']=2; \n $p[\'remark\']=$p[\'descr\']; \n $p[\'action_id\']=$dt[\'id\'][0]; \n product_trx($p); \n } \n}','php','0','2','2','1748499742'); INSERT INTO `cp_sphp` VALUES('22','app','to_money','function to_money($ang) { \n $sid = preg_replace("/[^0-9+-]/","",$ang); \n return $sid; \n}','php','0','2','2','1748499764'); INSERT INTO `cp_sphp` VALUES('23','app','list_equ_2','function list_equ_2(){ \n global $ar,$db; \n $dt=array(); \n \n $sql = "select a.*, b.descr as descr,b.seq as seq from account_equation a JOIN `action` b ON a.action_id=b.id where a.st>0 "; \n \n $sql .= " and a.`year`=\'".date("Y")."\' "; \n \n \n //$sql .= " order by a.".$sortby." asc, a.id asc"; \n $res = mysqli_query($db, $sql); \n foreach ($ar[\'equ\'] as $k => $v) { \n $j[$v]=0; \n } \n \n while($rw = mysqli_fetch_assoc($res)) { \n foreach ($ar[\'equ\'] as $k1 => $v1) { \n $j[$v1]=$j[$v1]+$rw[$v1]; \n } \n } \n \n $j[\'aktiva_lancar\']=$j[\'c11\']=$j[\'c11101\']+$j[\'c11201\']+$j[\'c11202\']+$j[\'c11203\']+$j[\'c11204\']+$j[\'c11205\']; \n \n $j[\'aktiva_tak_lancar\']=$j[\'c12\']=$j[\'c12101\']+$j[\'c12201\']+$j[\'c12202\']+$j[\'c12301\']+$j[\'c12302\']+$j[\'c12401\']+$j[\'c12402\']; \n \n $j[\'utang\']=$j[\'c21\']=$j[\'c21100\']+$j[\'c22100\']+$j[\'c23100\']; \n \n $j[\'equity\']=$j[\'c31\']=$j[\'c31100\']+$j[\'c31200\']+$j[\'c31300\']; \n \n $j[\'pendapatan\']=$j[\'c41\']=$j[\'c41100\']+$j[\'c41200\']+$j[\'c41300\']; \n \n $j[\'hpp\']=$j[\'c51\']=$j[\'c51100\']+$j[\'c51200\']+$j[\'c51300\']; \n \n $j[\'beban_penjualan\']=$j[\'c61\']=$j[\'c61101\']+$j[\'c61102\']+$j[\'c61103\']+$j[\'c61104\']+$j[\'c61105\']+$j[\'c61106\']; \n \n $j[\'beban_administrasi\']=$j[\'c62\']=$j[\'c62101\']+$j[\'c62102\']+$j[\'c62103\']+$j[\'c62104\']+$j[\'c62106\']+$j[\'c62107\']; \n \n $j[\'pendapatan_lain\']=$j[\'c71\']=$j[\'c71000\']; \n \n $j[\'beban_lain\']=$j[\'c81\']=$j[\'c81100\']+$j[\'c81200\']; \n \n $j[\'beban\']=$j[\'beban_penjualan\']+$j[\'beban_administrasi\']; \n \n $j[\'aktiva\']=$j[\'aktiva_lancar\']+$j[\'aktiva_tak_lancar\']; \n \n $j[\'laba_kotor\']=$j[\'pendapatan\']+$j[\'hpp\']+$j[\'beban_penjualan\']; \n \n $j[\'laba_sebelum_pph\']=$j[\'laba_kotor\']+$j[\'beban_administrasi\']; \n \n $j[\'pph\']=0; \n \n $j[\'laba_setelah_pph\']=$j[\'laba_bersih\']=$j[\'laba_sebelum_pph\']-$j[\'pph\']; \n \n $j[\'pasiva\']=$j[\'utang\']+$j[\'equity\']+$j[\'laba_setelah_pph\']; \n echo "aktiva:
"; print_r($POST); echo ""; \n //echo "
"; print_r($FILES); echo ""; \n if(isset($POST[\'title\']) && ($POST[\'title\']!=\'\')) { \n $title=$POST[\'title\']; \n } else { \n $title=""; \n } \n if(isset($POST[\'caption\']) && ($POST[\'caption\']!=\'\')) { \n $caption=$POST[\'caption\']; \n } else { \n $caption=""; \n } \n //get last id \n $sql2= "select id from `files` order by id desc limit 1"; \n $res2=mysqli_query($db,$sql2); \n $r2=mysqli_fetch_assoc($res2); \n \n if(isset($r2[\'id\']) && ($r2[\'id\']>0)) { \n $iid=$r2[\'id\']+1; \n } else { \n $iid=1; \n } \n \n //get last seq \n $sql9= "select seq from `files` where item_id=".$POST[\'id\']." and modul=\'".$modul."\' order by seq desc limit 1"; \n $res9=mysqli_query($db,$sql9); \n $r9=mysqli_fetch_assoc($res9); \n \n if(isset($r9[\'seq\']) && ($r9[\'seq\']>0)) { \n $seq=$r9[\'seq\']+1; \n } else { \n $seq=1; \n } \n \n $folder_y=$ar[\'img_path\']."".$modul."/".date("y"); \n if (!is_dir($folder_y)) { \n mkdir($folder_y, 0777, true); \n } \n $folder_ym=$folder_y."/".date("m"); \n if (!is_dir($folder_ym)) { \n mkdir($folder_ym, 0777, true); \n } \n \n $folder_ymd=$folder_ym."/".date("d"); \n if (!is_dir($folder_ymd)) { \n mkdir($folder_ymd, 0777, true); \n } \n \n $folder_ymdh=$folder_ymd."/".date("H"); \n if (!is_dir($folder_ymdh)) { \n mkdir($folder_ymdh, 0777, true); \n } \n \n $folder_main=$folder_ymdh."/".$POST[\'id\']; \n \n if (!is_dir($folder_main)) { \n mkdir($folder_main, 0777, true); \n } \n $folder_seq=$folder_main."/".$seq; \n if (!is_dir($folder_seq)) { \n mkdir($folder_seq, 0777, true); \n } \n \n $folder_tmp=$folder_seq."/tmp"; \n if (!is_dir($folder_tmp)) { \n mkdir($folder_tmp, 0777, true); \n } \n \n /*$sub_folder=$_POST[\'id\']."/".$seq."/"; \n switch($_POST[\'file_type\']) { \n case "Image"; \n \n }*/ \n \n $path=date("y")."/".date("m")."/".date("d")."/".date("H")."/".$POST[\'id\'];; \n $data=$img_data; \n $image_info = getimagesize($img_data); \n $extension = (isset($image_info["mime"]) ? explode(\'/\', $image_info["mime"] )[1]: ""); \n $file_name=date("YmdHis").".".$extension; \n \n $data = str_replace(\'data:image/\'.$extension.\';base64,\', \'\', $data); \n $data = str_replace(\' \',\'+\',$data); \n $bin = base64_decode($data); \n if ($bin === false) { \n //$dt[\'info\']="convert invalid"; \n } \n //$img = imageCreateFromString($bin); \n //tmp file \n $tmp_file=$folder_tmp.\'/\'.$file_name; \n file_put_contents($tmp_file, $bin); \n \n $sub_folder=$folder_seq."/image"; \n $sub_folder_big=$folder_seq."/image/big"; \n $sub_folder_medium=$folder_seq."/image/medium"; \n $sub_folder_small=$folder_seq."/image/small"; \n \n if(!is_dir($sub_folder)){ mkdir($sub_folder, 0755); } \n if(!is_dir($sub_folder_big)){ mkdir($sub_folder_big, 0755); } \n if(!is_dir($sub_folder_medium)){ mkdir($sub_folder_medium, 0755); } \n if(!is_dir($sub_folder_small)){ mkdir($sub_folder_small, 0755); } \n \n $source_image=$tmp_file; \n $img_big= $sub_folder_big."/".$file_name; \n $img_medium= $sub_folder_medium."/".$file_name; \n $img_small= $sub_folder_small."/".$file_name; \n //$destination=$ar[\'img_path\']."".$img_url; \n //resize(640, $destination, $source_image); \n image_handler($source_image,$img_big,1080,1080,90,false); \n image_handler($source_image,$img_medium,800,800,90,false); \n image_handler($source_image,$img_small,150,150,90,false); \n \n $udata2=array( \n \'id\'=>$iid, \n \'seq\'=>$seq, \n \'modul\'=>$modul, \n \'item_id\'=>$POST[\'id\'], \n \'type\'=>\'image\', \n \'title\'=>gpc($title), \n \'caption\'=>gpc($caption), \n \'url_original\'=>"temp/".$file_name, \n \'create_at\'=>time(), \n \'path\'=>$path, \n \'url\'=>$file_name \n ); \n Insert($db,"files",$udata2,0); \n \n $udt2=array( \n \'img\'=>$modul."/".$path."/".$seq."/image/small/".$file_name, \n ); \n Update($db,$modul,$udt2,"id=".$POST[\'id\']); \n}','php','0','2','3','1748687899'); INSERT INTO `cp_sphp` VALUES('38','common','genToken','function genToken($length = 10) { \n $characters = \'abcdefghijkmnpqrstuvwxyzABCDEFGHJKLMNPRSTUVWXYZ_@!)(^%\'; \n $charactersLength = strlen($characters); \n $randomString = \'\'; \n for ($i = 0; $i < $length; $i++) { \n $randomString .= $characters[rand(0, $charactersLength - 1)]; \n } \n return $randomString; \n}','php','0','2','3','1748687964'); INSERT INTO `cp_sphp` VALUES('39','common','arCss','function arCss($css) { \n $cleanCss = []; \n \n // Remove css comments \n $clean1 = explode(\'/*\', $css); \n foreach($clean1 as $clean2) { \n $clean3 = explode(\'*/\', $clean2); \n $cleanCss[] = $clean3[count($clean3) -1]; \n } \n $css = implode(\'\', $cleanCss); \n $temp = explode(\'}\', $css); \n $params = []; \n $type = \'all\'; \n $nextBracketIsNotMediaEnd = false; \n foreach($temp as $tem2) { \n $data = explode(\'{\', $tem2); \n if (count($data) == 1) { \n if ($nextBracketIsNotMediaEnd) { \n $nextBracketIsNotMediaEnd = false; \n } else { \n $type = \'all\'; \n continue; \n } \n } \n if (count($data) == 3) { \n $typeTemp = trim($data[0]); \n if (substr( $typeTemp, 0, 6 ) === "@media" ) { \n $type = $typeTemp; \n array_shift($data); \n } else { \n $data[1] = $data[0].$data[1]; \n $nextBracketIsNotMediaEnd = true; \n } \n } \n if (count($data) == 2) { \n $rows = explode(\';\',$data[1]); \n \n $tempData = []; \n foreach($rows as $row) { \n $paramsinline = explode(\':\', $row); \n if (empty($paramsinline[0]) || empty($paramsinline[1])){ \n continue; \n } \n $tempData[trim($paramsinline[0])] = trim($paramsinline[1]); \n } \n $selector = trim($data[0]); \n if (!empty($tempData)) { \n if (empty($params[$type][$selector])) { \n $params[$type][$selector] = $tempData; \n } else { \n $params[$type][$selector] = array_merge($params[$type][$selector], $tempData); \n } \n } \n } \n } \n return $params; \n}','php','0','2','3','1748687993'); INSERT INTO `cp_sphp` VALUES('40','common','genRandom','function genRandom($length = 10) { \n $characters = \'1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ\'; \n $charactersLength = strlen($characters); \n $randomString = \'\'; \n for ($i = 0; $i < $length; $i++) { \n $randomString .= $characters[rand(0, $charactersLength - 1)]; \n } \n return $randomString; \n}','php','0','2','3','1748688025'); INSERT INTO `cp_sphp` VALUES('41','common','genCode','function genCode($length = 10) { \n $characters = \'abcdefghijkmnpqrstuvwxyzABCDEFGHJKLMNPRSTUVWXYZ\'; \n $charactersLength = strlen($characters); \n $randomString = \'\'; \n for ($i = 0; $i < $length; $i++) { \n $randomString .= $characters[rand(0, $charactersLength - 1)]; \n } \n return $randomString; \n}','php','0','2','3','1748688046'); INSERT INTO `cp_sphp` VALUES('42','common','getUserIP','function getUserIP(){ \n $client = @$_SERVER[\'HTTP_CLIENT_IP\']; \n $forward = @$_SERVER[\'HTTP_X_FORWARDED_FOR\']; \n $remote = $_SERVER[\'REMOTE_ADDR\']; \n \n if(filter_var($client, FILTER_VALIDATE_IP)){ \n $ip = $client; \n } \n elseif(filter_var($forward, FILTER_VALIDATE_IP)){ \n $ip = $forward; \n } \n else{ \n $ip = $remote; \n } \n return $ip; \n}','php','0','2','3','1748688096'); INSERT INTO `cp_sphp` VALUES('43','common','emptyDir','function emptyDir($dir) { \n if (is_dir($dir)) { \n $scn = scandir($dir); \n foreach ($scn as $files) { \n if ($files !== \'.\') { \n if ($files !== \'..\') { \n if (!is_dir($dir . \'/\' . $files)) { \n unlink($dir . \'/\' . $files); \n } else { \n emptyDir($dir . \'/\' . $files); \n rmdir($dir . \'/\' . $files); \n } \n } \n } \n } \n } \n}','php','0','2','3','1748688148'); INSERT INTO `cp_sphp` VALUES('44','common','slug','function slug($text){ \n // replace non letter or digits by - \n $text = preg_replace(\'~[^pLd]+~u\', \'-\', $text); \n // transliterate \n $text = iconv(\'utf-8\', \'us-ascii//TRANSLIT\', $text); \n // remove unwanted characters \n $text = preg_replace(\'~[^-w]+~\', \'\', $text); \n // trim \n $text = trim($text, \'-\'); \n // remove duplicate - \n $text = preg_replace(\'~-+~\', \'-\', $text); \n // lowercase \n $text = strtolower($text); \n if (empty($text)) { \n return \'n-a\'; \n } \n return $text; \n}','php','0','2','3','1748688192'); INSERT INTO `cp_sphp` VALUES('45','common','image_resize','function image_resize($newWidth, $targetFile, $originalFile) { \n $info = getimagesize($originalFile); \n $mime = $info[\'mime\']; \n \n switch ($mime) { \n case \'image/jpeg\': \n $image_create_func = \'imagecreatefromjpeg\'; \n $image_save_func = \'imagejpeg\'; \n $new_image_ext = \'jpg\'; \n break; \n \n case \'image/png\': \n $image_create_func = \'imagecreatefrompng\'; \n $image_save_func = \'imagepng\'; \n $new_image_ext = \'png\'; \n break; \n \n case \'image/gif\': \n $image_create_func = \'imagecreatefromgif\'; \n $image_save_func = \'imagegif\'; \n $new_image_ext = \'gif\'; \n break; \n \n default: \n throw new Exception(\'Unknown image type.\'); \n } \n \n $img = $image_create_func($originalFile); \n list($width, $height) = getimagesize($originalFile); \n $newHeight = ($height / $width) * $newWidth; \n $tmp = imagecreatetruecolor($newWidth, $newHeight); \n imagecopyresampled($tmp, $img, 0, 0, 0, 0, $newWidth, $newHeight, $width, $height); \n if (file_exists($targetFile)) { \n unlink($targetFile); \n } \n $image_save_func($tmp, "$targetFile"); \n}','php','0','2','3','1748692193'); INSERT INTO `cp_sphp` VALUES('46','common','image_resize_w_mark','function image_resize_w_mark($img_src,$img_dst,$new_w,$quality=80,$wmsource=false) { \n // The getimagesize functions provides an "imagetype" string contstant, which can be passed to the image_type_to_mime_type function for the corresponding mime type \n $info = getimagesize($img_src); \n $imgtype = image_type_to_mime_type($info[2]); \n // Then the mime type can be used to call the correct function to generate an image resource from the provided image \n switch ($imgtype) { \n case \'image/jpeg\': \n $source = imagecreatefromjpeg($img_src); \n break; \n case \'image/gif\': \n $source = imagecreatefromgif($img_src); \n break; \n case \'image/png\': \n $source = imagecreatefrompng($img_src); \n break; \n default: \n die($img_src.\'Invalid image type.\'); \n } \n // Now, we can determine the dimensions of the provided image, and calculate the width/height ratio \n $src_w = imagesx($source); \n $src_h = imagesy($source); \n $src_ratio = $src_h/$src_w; \n // Now we can use the power of math to determine whether the image needs to be cropped to fit the new dimensions, and if so then whether it should be cropped vertically or horizontally. We\'re just going to crop from the center to keep this simple. \n \n /* \n if ($tn_w/$tn_h > $src_ratio) { \n $new_h = $tn_w/$src_ratio; \n $new_w = $tn_w; \n } else { \n $new_w = $tn_h*$src_ratio; \n $new_h = $tn_h; \n } \n */ \n \n $new_h=$new_w*$src_ratio; \n $tn_w=$new_w; \n $tn_h=$new_h; \n \n $x_mid = $new_w/2; \n $y_mid = $new_h/2; \n \n // Now actually apply the crop and resize! \n $newpic = imagecreatetruecolor(round($new_w), round($new_h)); \n imagecopyresampled($newpic, $source, 0, 0, 0, 0, $new_w, $new_h, $src_w, $src_h); \n $final = imagecreatetruecolor($tn_w, $tn_h); \n imagecopyresampled($final, $newpic, 0, 0, ($x_mid-($tn_w/2)), ($y_mid-($tn_h/2)), $tn_w, $tn_h, $tn_w, $tn_h); \n // If a watermark source file is specified, get the information about the watermark as well. This is the same thing we did above for the source image. \n if($wmsource) { \n $info = getimagesize($wmsource); \n $imgtype = image_type_to_mime_type($info[2]); \n switch ($imgtype) { \n case \'image/jpeg\': \n $watermark = imagecreatefromjpeg($wmsource); \n break; \n case \'image/gif\': \n $watermark = imagecreatefromgif($wmsource); \n break; \n case \'image/png\': \n $watermark = imagecreatefrompng($wmsource); \n break; \n default: \n die(\'Invalid watermark type.\'); \n } \n // Determine the size of the watermark, because we\'re going to specify the placement from the top left corner of the watermark image, so the width and height of the watermark matter. \n $wm_w = imagesx($watermark); \n $wm_h = imagesy($watermark); \n // Now, figure out the values to place the watermark in the bottom right hand corner. You could set one or both of the variables to "0" to watermark the opposite corners, or do your own math to put it somewhere else. \n $wm_x = ($tn_w - $wm_w)/2; \n $wm_y = ($tn_h - $wm_h)/2; \n // Copy the watermark onto the original image \n // The last 4 arguments just mean to copy the entire watermark \n imagecopy($final, $watermark, $wm_x, $wm_y, 0, 0, $wm_w, $wm_h); \n } \n // Ok, save the output as a jpeg, to the specified img_dst path at the desired quality. \n // You could use imagepng or imagegif here if you wanted to output those file types instead. \n if(Imagejpeg($final,$img_dst,$quality)) { \n return true; \n } \n // If something went wrong \n return false; \n}','php','0','2','3','1748693189'); INSERT INTO `cp_sphp` VALUES('47','common','image_handler','function image_handler($source_image,$destination,$tn_w = 100,$tn_h = 100,$quality = 80,$wmsource = false) { \n // The getimagesize functions provides an "imagetype" string contstant, which can be passed to the image_type_to_mime_type function for the corresponding mime type \n $info = getimagesize($source_image); \n $imgtype = image_type_to_mime_type($info[2]); \n // Then the mime type can be used to call the correct function to generate an image resource from the provided image \n switch ($imgtype) { \n case \'image/jpeg\': \n $source = imagecreatefromjpeg($source_image); \n break; \n case \'image/gif\': \n $source = imagecreatefromgif($source_image); \n break; \n case \'image/png\': \n $source = imagecreatefrompng($source_image); \n break; \n default: \n die($source_image.\'Invalid image type.\'); \n } \n // Now, we can determine the dimensions of the provided image, and calculate the width/height ratio \n $src_w = imagesx($source); \n $src_h = imagesy($source); \n $src_ratio = $src_w/$src_h; \n // Now we can use the power of math to determine whether the image needs to be cropped to fit the new dimensions, and if so then whether it should be cropped vertically or horizontally. We\'re just going to crop from the center to keep this simple. \n if ($tn_w/$tn_h > $src_ratio) { \n $new_h = $tn_w/$src_ratio; \n $new_w = $tn_w; \n } else { \n $new_w = $tn_h*$src_ratio; \n $new_h = $tn_h; \n } \n $x_mid = $new_w/2; \n $y_mid = $new_h/2; \n // Now actually apply the crop and resize! \n $newpic = imagecreatetruecolor(round($new_w), round($new_h)); \n imagecopyresampled($newpic, $source, 0, 0, 0, 0, $new_w, $new_h, $src_w, $src_h); \n $final = imagecreatetruecolor($tn_w, $tn_h); \n imagecopyresampled($final, $newpic, 0, 0, ($x_mid-($tn_w/2)), ($y_mid-($tn_h/2)), $tn_w, $tn_h, $tn_w, $tn_h); \n // If a watermark source file is specified, get the information about the watermark as well. This is the same thing we did above for the source image. \n if($wmsource) { \n $info = getimagesize($wmsource); \n $imgtype = image_type_to_mime_type($info[2]); \n switch ($imgtype) { \n case \'image/jpeg\': \n $watermark = imagecreatefromjpeg($wmsource); \n break; \n case \'image/gif\': \n $watermark = imagecreatefromgif($wmsource); \n break; \n case \'image/png\': \n $watermark = imagecreatefrompng($wmsource); \n break; \n default: \n die(\'Invalid watermark type.\'); \n } \n // Determine the size of the watermark, because we\'re going to specify the placement from the top left corner of the watermark image, so the width and height of the watermark matter. \n $wm_w = imagesx($watermark); \n $wm_h = imagesy($watermark); \n // Now, figure out the values to place the watermark in the bottom right hand corner. You could set one or both of the variables to "0" to watermark the opposite corners, or do your own math to put it somewhere else. \n $wm_x = ($tn_w - $wm_w)/2; \n $wm_y = ($tn_h - $wm_h)/2; \n // Copy the watermark onto the original image \n // The last 4 arguments just mean to copy the entire watermark \n imagecopy($final, $watermark, $wm_x, $wm_y, 0, 0, $wm_w, $wm_h); \n } \n // Ok, save the output as a jpeg, to the specified destination path at the desired quality. \n // You could use imagepng or imagegif here if you wanted to output those file types instead. \n if(Imagejpeg($final,$destination,$quality)) { \n return true; \n } \n // If something went wrong \n return false; \n}','php','0','2','3','1748688345'); INSERT INTO `cp_sphp` VALUES('48','common','UploadImage','function UploadImage($POST,$FILES,$modul) { \n global $db,$ar; \n if(isset($POST[\'title\']) && ($POST[\'title\']!=\'\')) { \n $title=$POST[\'title\']; \n } else { \n $title=""; \n } \n if(isset($POST[\'caption\']) && ($POST[\'caption\']!=\'\')) { \n $caption=$POST[\'caption\']; \n } else { \n $caption=""; \n } \n //get last id \n $sql2= "select id from `files` order by id desc limit 1"; \n $res2=mysqli_query($db,$sql2); \n $r2=mysqli_fetch_assoc($res2); \n \n if(isset($r2[\'id\']) && ($r2[\'id\']>0)) { \n $iid=$r2[\'id\']+1; \n } else { \n $iid=1; \n } \n \n //get last seq \n $sql9= "select seq from `files` where item_id=".$POST[\'id\']." and modul=\'".$modul."\' order by seq desc limit 1"; \n echo $sql9."
\n 
\n 
\n
\n
\n
\n This is a blank page. You can add as many pages as you want in your app and build them using all the components and features included in the template.
\nYou can then link the pages to any classical link or button to open it.
','','','','','0','0','2','1','1','1','0','0','1','0','0','url','','','','5','0','1759722334','0','1'); INSERT INTO `t6_h_page` VALUES('38','icons/','','icons','Icons F7','','more','','','','','\n \n','','0','1','2','2','1','1','0','1','1','0','0','componentUrl','','','','5','0','1747964630','0','1'); INSERT INTO `t6_h_page` VALUES('40','password_change/','','password_change','Change Password','','','','','','','This is a blank page. You can add as many pages as you want in your app and build them using all the components and features included in the template.
\nYou can then link the pages to any classical link or button to open it.
\nOpen Popup','','','This is a blank page. You can add as many pages as you want in your app and build them using all the components and features included in the template.
\nYou can then link the pages to any classical link or button to open it.
\n Open Popup\n \n
\nTechnology\nGaming\nGaming technology has come a long way since the days of Pong and Space Invaders. Today’s gamers have access to a wide variety of consoles, PCs, and mobile devices, all of which offer immersive experiences that rival those of traditional forms of entertainment. But what does the future hold for gaming technology? Let’s take a look.
\nVirtual and augmented reality are two of the most exciting developments in gaming technology. These technologies offer gamers a completely immersive experience, where they can explore virtual worlds and interact with objects in real-time.
\nWhile virtual reality has been around for a few years now, the technology is still in its early stages. In the coming years, we can expect to see more advanced VR headsets and hardware, which will offer gamers an even more realistic experience.
\nCloud gaming is another exciting development in gaming technology. This technology allows gamers to stream games from servers, eliminating the need for a powerful console or PC. This means that gamers will be able to play high-quality games on lower-end devices, which will make gaming more accessible than ever before.
\n
\n As internet speeds continue to improve, we can expect cloud gaming to become even more popular. Some major players in the gaming industry, such as Google and Microsoft, have already launched their own cloud gaming services, and it’s likely that other companies will follow suit.
\nMobile gaming has exploded in popularity in recent years, with millions of people playing games on their smartphones and tablets. While mobile games were once seen as simple and casual, the rise of more advanced mobile hardware and software has led to the development of high-quality mobile games that rival those on consoles and PCs.
\nIn the future, we can expect to see even more advanced mobile games, with more complex gameplay and graphics. As smartphones and tablets continue to evolve, mobile gaming will become an even more important part of the gaming industry.
\nThe future of gaming technology is incredibly exciting, with new developments and innovations emerging all the time. From virtual and augmented reality to cloud gaming, artificial intelligence, and mobile gaming, gamers can expect to enjoy even more immersive and engaging experiences in the years to come.
\n
\n \n \n plusFollow\n
\n 
\n 
\n 
\n 
\n \n Technology\n Gaming\n Gaming technology has come a long way since the days of Pong and Space Invaders. Today’s gamers have access to a wide variety of consoles, PCs, and mobile devices, all of which offer immersive experiences that rival those of traditional forms of entertainment. But what does the future hold for gaming technology? Let’s take a look.
\nVirtual and augmented reality are two of the most exciting developments in gaming technology. These technologies offer gamers a completely immersive experience, where they can explore virtual worlds and interact with objects in real-time.
\nWhile virtual reality has been around for a few years now, the technology is still in its early stages. In the coming years, we can expect to see more advanced VR headsets and hardware, which will offer gamers an even more realistic experience.
\nCloud gaming is another exciting development in gaming technology. This technology allows gamers to stream games from servers, eliminating the need for a powerful console or PC. This means that gamers will be able to play high-quality games on lower-end devices, which will make gaming more accessible than ever before.
\n\n As internet speeds continue to improve, we can expect cloud gaming to become even more popular. Some major players in the gaming industry, such as Google and Microsoft, have already launched their own cloud gaming services, and it’s likely that other companies will follow suit.
\nMobile gaming has exploded in popularity in recent years, with millions of people playing games on their smartphones and tablets. While mobile games were once seen as simple and casual, the rise of more advanced mobile hardware and software has led to the development of high-quality mobile games that rival those on consoles and PCs.
\nIn the future, we can expect to see even more advanced mobile games, with more complex gameplay and graphics. As smartphones and tablets continue to evolve, mobile gaming will become an even more important part of the gaming industry.
\nThe future of gaming technology is incredibly exciting, with new developments and innovations emerging all the time. From virtual and augmented reality to cloud gaming, artificial intelligence, and mobile gaming, gamers can expect to enjoy even more immersive and engaging experiences in the years to come.
\n\n \n \n plusFollow\n \n \n \n \n \n 
\n \n ${v.name} ${v.pid} (${v.id})
\nColor: ${v.colors}
\n \n `; \n }); \n content +=``; \n $("#home_new_release").html(content); \n \n}','js','0','2','2','1760014756'); INSERT INTO `t6_js` VALUES('40','item','item_detail','$(document).on(\'page:beforein\', \'.page[data-name="item_detail"]\', async function(e) { \n console.log(\'app item_detail ready\') \n var cat = e.detail.route.params.cat; \n var id = e.detail.route.params.id; \n console.log(id + \', \' + cat); \n let dt2=get_localstorage(\'item_pria\'); \n let dt=dt2.data.byid.data[id]; \n console.log(dt) \n //item_detail_load(dt) \n let category =`${dt.brand}`; \n category +=`${dt.kategory1}`; \n category +=`${dt.kategory2}`; \n category +=`${dt.kategory3}`; \n let btn_popup =` \n `; \n \n \n let k=0; \n console.log(\'k:\'+k) \n let top_img=` \n
\n