\n
\n \n
\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