historymonthly.php

#!/usr/local/bin/php
<?php
    $bulan = date('n-Y');
    $arrlike = array("f.%.o", "c.%", "f.%");
    $arrcode = array("OLT", "SC", "SCF");

    include('konek34iqp.php');      // $con34
    include('konek50iqp.php');      // $con50
    // bantai dulu too old history
    $query = "delete from jlh_total_monthly where tmstmp < date_sub(now(), interval 2 year)";
    mysql_query($query,$con34);

    for($i=0;$i<count($arrcode);$i++) {
        $like = $arrlike[$i];
        $code = $arrcode[$i];
        $query = "SELECT iqp_sc.wks as total,iqp_sc.user_id as lokasi,iqp_sc.status FROM iqp_user,iqp_sc
                where iqp_user.user_id=iqp_sc.user_id and iqp_user.sctyp='S' and iqp_user.user_id  like '$like'
                order by iqp_user.user_id";
        $result = mysql_query($query,$con50);
        while( $data=mysql_fetch_array($result) ) {
            $sum= $data['total'];
            $status= $data['status'];
            $lokasi= $data['lokasi'];
            $query = "INSERT INTO jlhtotal_monthly VALUES (null,'$bulan','$code', '$sum','$lokasi','$status', 'system', NOW())";
            mysql_query($query,$con34);
        }
        mysql_free_result($result);
    }
    mysql_close($con50);
    mysql_close($con34);
?>