filephp fin2@agn

FilePHP

/home/u902783705/domains/azkapersada.com/public_html/sub/fin/

common.function.php

<?php
$ar['abjad']=array('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z');
$ar['month_name']=array('','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Okt','Nov','Dec');
$ar['month_seq']=array('','01','02','03','04','05','06','07','08','09','10','11','12');
$ar['manp']=array(
1670000842202=>3,
1670001143709=>7,
);
    $ar['c22']=array(
      '3'=>'11110',
      '1'=>'11120',
      '2'=>'11130',
      '4'=>'11140',
      '7'=>'11150',
    );

function nodec($l) {
  $l=number_format($l, 0, '', '');
  return $l;
}

function ang($l) {
  $l=number_format($l, 0, ',', '.');
  return $l;
} 
function ang2($l) {
    if($l!=0) {
  $l=number_format($l, 0, '.', ',');
  return $l;
    } else {
        return "";
    }
}

function ang3($l) {
    if($l!=0) {
  $l=number_format($l, 0, '.', '');
  return $l;
    } else {
        return "";
    }
}

function CommaToDot($grade) {
$grade = str_replace(',', '.', $grade);
return $grade;
}

function to_numeric($ang) {
$sid = preg_replace("/[^0-9]/","",$ang);
return $sid;
}

function NoSpace($ang) {
$sid = preg_replace("/[^A-Za-z0-9]/","",$ang);
return $sid;
}

function to_hp($ang) {
    $sid = preg_replace("/[^0-9]/","",$ang);

$awalan=substr($sid,0,2);
    if($awalan=='08') {
        $newhp="628".substr($sid,2);
    } else {
        $newhp=$sid;
    }

return $newhp;
}

//list foto by modul, by item_id
function viewImage($modul,$item_id) {
  global $db,$ar;

$sql2 = "SELECT * FROM `files` WHERE modul='".$modul."' and item_id='".$item_id."' and `type`='image' ";
  $run2 = mysqli_query($db, $sql2);
  $ret= "<hr><h3>Images</h3><div class='row'>";
  while($r2 = mysqli_fetch_assoc($run2)) {
    $img_small=$modul."/".$r2['path']."/".$r2['seq']."/image/small/".$r2['url'];
    $img_big=$modul."/".$r2['path']."/".$r2['seq']."/image/big/".$r2['url'];

$ret .= '
    <div class="col-sm-3 col-lg-2 col-xs-6">
      <div class="card">
    ';
    $ret .= '<img src="'.$ar['url_img'].''.$img_small.'" alt="">';
    $ret .= '';
    $ret .= '
      </div>
    </div>';

}
  $ret .= "</div>";

return $ret;

}

# Insert Data 
function Insert($mysqli,$table,$data,$v=0){

//global $mysqli;
  //print_r($data);

$fields = array_keys( $data );  
  $values = array_map( array($mysqli, 'real_escape_string'), array_values( $data ) );
  if($v==1) {
      echo "INSERT INTO $table(`".implode("`,`",$fields)."`) VALUES ('".implode("','", $values )."');<br>";
  }
  //exit;  
  mysqli_query($mysqli, "INSERT INTO $table(`".implode("`,`",$fields)."`) VALUES ('".implode("','", $values )."');") or die( mysqli_error($mysqli) );

}

// Update Data, Where clause is left optional
function InsertUpdate($mysqli,$table_name,$i_data,$u_data,$v=0)
{   
    //global $mysqli;
    // check for optional where clause
    
    $i_fields = array_keys( $i_data );  
    $i_values = array_map( array($mysqli, 'real_escape_string'), array_values( $i_data ) );

$u_fields = array_keys( $u_data );  
    $u_values = array_map( array($mysqli, 'real_escape_string'), array_values( $u_data ) );

$sql = "INSERT INTO $table_name (`".implode("`,`",$i_fields)."`) VALUES ('".implode("','", $i_values )."') ";

// start the actual SQL statement
    $sql .= " on duplicate key UPDATE ";

// loop and build the column /
    $sets = array();
    foreach($u_data as $column => $value) {
         $sets[] = "`".$column."` = '".$value."'";
    }
    $sql .= implode(', ', $sets);

// append the where statement
    //$sql .= $whereSQL;
         
    // run and return the query result
    //echo $sql;
    if($v==1) {
      echo $sql.";<br>";
    }
    return mysqli_query($mysqli,$sql);
}

// Update Data, Where clause is left optional
function Update($mysqli,$table_name, $form_data, $where_clause='',$v=0)
{   
    //global $mysqli;
    // check for optional where clause
    $whereSQL = '';
    if(!empty($where_clause))
    {
        // check to see if the 'where' keyword exists
        if(substr(strtoupper(trim($where_clause)), 0, 5) != 'WHERE')
        {
            // not found, add key word
            $whereSQL = " WHERE ".$where_clause;
        } else
        {
            $whereSQL = " ".trim($where_clause);
        }
    }
    // start the actual SQL statement
    $sql = "UPDATE ".$table_name." SET ";

// loop and build the column /
    $sets = array();
    foreach($form_data as $column => $value)
    {
         $sets[] = "`".$column."` = '".$value."'";
    }
    $sql .= implode(', ', $sets);

// append the where statement
    $sql .= $whereSQL;
         
    // run and return the query result
    if($v==1) {
      echo $sql.";<br>";
    }
    return mysqli_query($mysqli,$sql);
}

//Delete Data, the where clause is left optional incase the user wants to delete every row!
function Delete($mysqli,$table_name, $where_clause='')
{   
    //global $mysqli;
    // check for optional where clause
    $whereSQL = '';
    if(!empty($where_clause))
    {
        // check to see if the 'where' keyword exists
        if(substr(strtoupper(trim($where_clause)), 0, 5) != 'WHERE')
        {
            // not found, add keyword
            $whereSQL = " WHERE ".$where_clause;
        } else
        {
            $whereSQL = " ".trim($where_clause);
        }
    }
    // build the query
    $sql = "DELETE FROM ".$table_name.$whereSQL;
     
    // run and return the query result resource
    return mysqli_query($mysqli,$sql);
}

function backup_tables($tables = '*') {
    global $db,$ar;

$link=$db;

mysqli_query($db, "SET NAMES 'utf8'");

//get all of the tables
    if($tables == '*')
    {
        $tables = array();
        $result = mysqli_query($link, 'SHOW TABLES');
        while($row = mysqli_fetch_row($result))
        {
            $tables[] = $row[0];
        }
    }
    else
    {
        $tables = is_array($tables) ? $tables : explode(',',$tables);
    }

$return = "SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';\n\n";
    //cycle through
    foreach($tables as $table)
    {
        $result = mysqli_query($link, 'SELECT * FROM '.$table);
        $num_fields = mysqli_num_fields($result);
        $num_rows = mysqli_num_rows($result);

$return.= 'DROP TABLE IF EXISTS `'.$table.'`;';
        $row2 = mysqli_fetch_row(mysqli_query($link, 'SHOW CREATE TABLE '.$table));
        $return.= "\n".$row2[1].";\n\n";
        $counter = 1;

//Over tables
        for ($i = 0; $i < $num_fields; $i++) 
        {   //Over rows
            while($row = mysqli_fetch_row($result))
            {   
                $return.= 'INSERT INTO `'.$table.'` VALUES(';

//Over fields
                for($j=0; $j<$num_fields; $j++) 
                {
                    $row[$j] = gpc($row[$j]);
                    $row[$j] = str_replace("\n","\\n",$row[$j]);
                    if (isset($row[$j])) { $return.= "'".$row[$j]."'" ; } else { $return.= "''"; }
                    if ($j<($num_fields-1)) { $return.= ","; }
                }

$return.= ");\n";
                ++$counter;
            }
        }
        $return.="\n\n";
    }

//save file
    $fileName = 'fin2_'.date("Y_m_d").'.sql';
    $handle = fopen($fileName,'w+');
    fwrite($handle,$return);
    if(fclose($handle)){
        echo 'Done, the file name is: <a href="'.$ar['siteurl'].'/'.$fileName.'">'.$ar['siteurl'].'/'.$fileName.'</a>';
        exit; 
    }
}

function getDistance($latitude1, $longitude1, $latitude2, $longitude2) 
{
    $theta = $longitude1 - $longitude2;
    $miles = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) + (cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) * cos(deg2rad($theta)));
    $miles = acos($miles);
    $miles = rad2deg($miles);
    $miles = $miles * 60 * 1.1515;
    $feet = $miles * 5280;
    $yards = $feet / 3;
    $kilometers = $miles * 1.609344;
    $meters = $kilometers * 1000;
    //return compact('miles','feet','yards','kilometers','meters'); 
    return $kilometers;
}

function dfjson($data){
    if(is_array($data)){
      return json_encode($data, JSON_NUMERIC_CHECK);
    }
  }

if(isset($r2['id']) && ($r2['id']>0)) {
        $iid=$r2['id']+1;
    } else {
        $iid=1;
    }

//get last seq
    $sql9= "select seq from `files` where item_id=".$_POST['id']." and modul='".$modul."' order by seq desc limit 1";
    $res9=mysqli_query($db,$sql9);
    $r9=mysqli_fetch_assoc($res9);

if(isset($r9['seq']) && ($r9['seq']>0)) {
        $seq=$r9['seq']+1;
    } else {
        $seq=1;
    }

$folder_y=$ar['img_path']."/".$modul."/".date("y");
    if (!is_dir($folder_y)) {
        mkdir($folder_y, 0777, true);
    }
    $folder_ym=$folder_y."/".date("m");
    if (!is_dir($folder_ym)) {
        mkdir($folder_ym, 0777, true);
    }

$folder_ymd=$folder_ym."/".date("d");
    if (!is_dir($folder_ymd)) {
        mkdir($folder_ymd, 0777, true);
    }

$folder_ymdh=$folder_ymd."/".date("H");
    if (!is_dir($folder_ymdh)) {
        mkdir($folder_ymdh, 0777, true);
    }

$folder_main=$folder_ymdh."/".$_POST['id'];

if (!is_dir($folder_main)) {
        mkdir($folder_main, 0777, true);
    }
    $folder_seq=$folder_main."/".$seq;
    if (!is_dir($folder_seq)) {
        mkdir($folder_seq, 0777, true);
    }

$folder_tmp=$folder_seq."/tmp";
    if (!is_dir($folder_tmp)) {
        mkdir($folder_tmp, 0777, true);
    }

/*$sub_folder=$_POST['id']."/".$seq."/";
    switch($_POST['file_type']) {
      case "Image";

}*/

$path=date("y")."/".date("m")."/".date("d")."/".date("H")."/".$_POST['id'];

$e_ext=explode("/",$_FILES['file']['type']);
    $file_name=date("YmdHis").".".$e_ext[1];

if($_POST['file_type']=='image') {
        if (move_uploaded_file($_FILES['file']['tmp_name'], $folder_tmp.'/'. $_FILES["file"]['name'])) {
              //echo "Image Card Front Uploaded";
              //$file_name=date("YmdHis").".jpg";

$sub_folder=$folder_seq."/image";
              $sub_folder_big=$folder_seq."/image/big";
              $sub_folder_medium=$folder_seq."/image/medium";
              $sub_folder_small=$folder_seq."/image/small";

if(!is_dir($sub_folder)){ mkdir($sub_folder, 0755); }
              if(!is_dir($sub_folder_big)){ mkdir($sub_folder_big, 0755); }
              if(!is_dir($sub_folder_medium)){ mkdir($sub_folder_medium, 0755); }
              if(!is_dir($sub_folder_small)){ mkdir($sub_folder_small, 0755); }

$source_image=$folder_tmp.'/'. $_FILES["file"]['name'];
              $img_big= $sub_folder_big."/".$file_name;
              $img_medium= $sub_folder_medium."/".$file_name;
              $img_small= $sub_folder_small."/".$file_name;
              //$destination=$ar['img_path']."".$img_url;
              //resize(640, $destination, $source_image);
              image_handler($source_image,$img_big,1080,540,90,false);
              image_handler($source_image,$img_medium,800,400,90,false);
              image_handler($source_image,$img_small,150,150,90,false);

$udata2=array(
                'id'=>$iid,
                'seq'=>$seq,
                'modul'=>$modul,
                'item_id'=>$_POST['id'],
                'type'=>'image',
                'title'=>gpc($title),
                'caption'=>gpc($caption),
                'url_original'=>'tmp/'.$_FILES["file"]['name'],
                'create_at'=>time(),
                'path'=>$path,
                'url'=>$file_name
                );
              Insert($db,"files",$udata2,0);

$udt2=array(
                'img'=>$modul."/".$path."/".$seq."/image/small/".$file_name,
              );
              Update($db,$modul,$udt2,"id=".$_POST['id']);
        }

} else {

if (move_uploaded_file($_FILES['file']['tmp_name'], $folder_seq.'/'.$file_name)) {
              
            //echo "Image Card Front Uploaded";

$udata2=array(
                'id'=>$iid,
                'seq'=>$seq,
                'modul'=>$modul,
                'item_id'=>$_POST['id'],
                'type'=>$_POST['file_type'],
                'title'=>gpc($title),
                'caption'=>gpc($caption),
                'url_original'=>'tmp/'.$_FILES["file"]['name'],
                'create_at'=>time(),
                'path'=>$path,
                'url'=>$file_name,
                );
            Insert($db,"files",$udata2,0);
            $udt2=array(
              'url_pdf'=>$modul."/".$path."/".$seq."/".$file_name,
            );
            Update($db,$modul,$udt2,"id=".$_POST['id']);

}
    }   
}

// Now actually apply the crop and resize!
  $newpic = imagecreatetruecolor(round($new_w), round($new_h));
  imagecopyresampled($newpic, $source, 0, 0, 0, 0, $new_w, $new_h, $src_w, $src_h);
  $final = imagecreatetruecolor($tn_w, $tn_h);
  imagecopyresampled($final, $newpic, 0, 0, ($x_mid-($tn_w/2)), ($y_mid-($tn_h/2)), $tn_w, $tn_h, $tn_w, $tn_h);
  // 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.
  if($wmsource) {
  $info = getimagesize($wmsource);
  $imgtype = image_type_to_mime_type($info[2]);
  switch ($imgtype) {
    case 'image/jpeg':
      $watermark = imagecreatefromjpeg($wmsource);
      break;
    case 'image/gif':
      $watermark = imagecreatefromgif($wmsource);
      break;
    case 'image/png':
      $watermark = imagecreatefrompng($wmsource);
      break;
    default:
      die('Invalid watermark type.');
  }
  // 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.
  $wm_w = imagesx($watermark);
  $wm_h = imagesy($watermark);
  // 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.
  $wm_x = ($tn_w - $wm_w)/2;
  $wm_y = ($tn_h - $wm_h)/2;
  // Copy the watermark onto the original image
  // The last 4 arguments just mean to copy the entire watermark
  imagecopy($final, $watermark, $wm_x, $wm_y, 0, 0, $wm_w, $wm_h);
  }
  // Ok, save the output as a jpeg, to the specified destination path at the desired quality.
  // You could use imagepng or imagegif here if you wanted to output those file types instead.
  if(Imagejpeg($final,$destination,$quality)) {
  return true;
  }
  // If something went wrong
  return false;
}

function resize($newWidth, $targetFile, $originalFile) {

//$originalFile = file_get_contents($imgurl);

$info = getimagesize($originalFile);
    $mime = $info['mime'];

switch ($mime) {
            case 'image/jpeg':
                    $image_create_func = 'imagecreatefromjpeg';
                    $image_save_func = 'imagejpeg';
                    $new_image_ext = 'jpg';
                    break;

case 'image/png':
                    $image_create_func = 'imagecreatefrompng';
                    $image_save_func = 'imagepng';
                    $new_image_ext = 'png';
                    break;

case 'image/gif':
                    $image_create_func = 'imagecreatefromgif';
                    $image_save_func = 'imagegif';
                    $new_image_ext = 'gif';
                    break;

default: 
                    throw new Exception('Unknown image type.');
    }

$img = $image_create_func($originalFile);
    list($width, $height) = getimagesize($originalFile);

$newHeight = ($height / $width) * $newWidth;
    $tmp = imagecreatetruecolor($newWidth, $newHeight);
    imagecopyresampled($tmp, $img, 0, 0, 0, 0, $newWidth, $newHeight, $width, $height);

if (file_exists($targetFile)) {
            unlink($targetFile);
    }
    $image_save_func($tmp, "$targetFile");
}

function slug($text)
{
  // replace non letter or digits by -
  $text = preg_replace('~[^\pL\d]+~u', '-', $text);

// transliterate
  $text = iconv('utf-8', 'us-ascii//TRANSLIT', $text);

// remove unwanted characters
  $text = preg_replace('~[^-\w]+~', '', $text);

// trim
  $text = trim($text, '-');

// remove duplicate -
  $text = preg_replace('~-+~', '-', $text);

// lowercase
  $text = strtolower($text);

if (empty($text)) {
    return 'n-a';
  }

return $text;
}

function getUserIP()
{
    $client  = @$_SERVER['HTTP_CLIENT_IP'];
    $forward = @$_SERVER['HTTP_X_FORWARDED_FOR'];
    $remote  = $_SERVER['REMOTE_ADDR'];

if(filter_var($client, FILTER_VALIDATE_IP))
    {
        $ip = $client;
    }
    elseif(filter_var($forward, FILTER_VALIDATE_IP))
    {
        $ip = $forward;
    }
    else
    {
        $ip = $remote;
    }

return $ip;
}

function genRandom($length = 10) {
    $characters = '1234567890abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNPQRSTUVWXYZ';
    $charactersLength = strlen($characters);
    $randomString = '';
    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, $charactersLength - 1)];
    }
    return $randomString;
}

function mandiri_mutasi($text) {
global $db2;

$src= array (
      "# /#i",  // Strip out javascript
      "#MCM InhouseTrf#",
      '#Tarik ATM #',
      '#Tarif Link #',
      '#MONTHLY CARD CHARGE #',
      '#Biaya Adm #',
      '#Saldo Awal#',
      '#Bunga #',
      '#Tarik Via ATM #',
      '#,#',
    );

$rep = array (
      "/",
      "MCM_Inhouse_Trf",
      "Tarik_ATM_",
      "Tarif_Link_",
      'MONTHLY_CARD_CHARGE_',
      'Biaya_Adm_',
      'Saldo_Awal',
      'Bunga',
      'Tarik_Via_ATM_',
      '',
    );

$ret = preg_replace($src, $rep, $text);
  return $ret;
}

function IGtext($text) {
global $db2;

$search = array (
                "#<br\s*?/?>#i",  // Strip out javascript
                 "#<\/p>#i",
                 );                    // evaluate as php
 
$replace = array ("&#8291;",
                  "&#8291;",
                  );

$ret = preg_replace($search, $replace, $text);
    return $ret;
}

function WAtext($text) {
global $db2;

$search = ARRAY ("#<br\s*?/?>#i",  // Strip out javascript
                 "#<li\s*?/?>#i",
                 "#<\/li\s*?/?>#i",
                 "#<\/ol\s*?/?>#i",
                 "#<\/h4\s*?/?>#i",
                 "#<\/h2\s*?/?>#i",
                 "#<h4\s*?/?>#i",
                 "#<h2\s*?/?>#i",
                 "'<[/!]*?[^<>]*?>'si",          // Strip out HTML tags
                 );                    // evaluate as php
 
$replace = ARRAY ("\n",
                  "- ",
                  "\n",
                  "\n",
                  "*\n",
                  "*\n",
                  "\n*",
                  "\n*",
                 "",
                  );

$ret = preg_replace($search, $replace, $text);
    return $ret;
}