Simple General Helper on Code Igniter

1. Create general_helper.php on /sytem/application/helpers.

<?php

/**
 * change date format from dd/mm/yyyy become yyyy-mm-dd
 * @param <type> $date
 * @return string
 */
function encode_date($date) {
    list($day, $month, $year) = explode('/', $date);
    $new_date = $year . "-" . $month . "-" . $day;
    return $new_date;
}

/**
 * change date format from yyyy-mm-dd become dd/mm/yyyy
 * @param <type> $date
 * @return string
 */
function decode_date($date) {
    list($year, $month, $day) = explode('-', $date);
    $new_date = $day . "/" . $month . "/" . $year;
    return $new_date;
}

/**
 * create money value in Rupiah
 * @param <type> $uang
 * @return <type>
 */
function format_rupiah($uang) {
    return "Rp. ". number_format($uang, 0, ",", ".");
}

function format_dana($uang) {
    return number_format($uang, 0, ".", "");
}
        
function indonesian_month($month) {
    switch ($month) {
        case "01" : $imonth = "Januari"; break;
        case "02" : $imonth = "Februari"; break;
        case "03" : $imonth = "Maret"; break;
        case "04" : $imonth = "April"; break;
        case "05" : $imonth = "Mei"; break;
        case "06" : $imonth = "Juni"; break;
        case "07" : $imonth = "Juli"; break;
        case "08" : $imonth = "Agustus"; break;
        case "09" : $imonth = "September"; break;
        case "10" : $imonth = "Oktober"; break;
        case "11" : $imonth = "November"; break;
        case "12" : $imonth = "Desember"; break;
        default  : $imonth = "-"; break;
    }
    return $imonth;
}

/**
 * change date format to indonesia
 * @param <type> $month
 * @return string
 */
function indonesian_date($date) {
    list($year, $month, $day) = explode('-', $date);
    $new_date = $day ." ". indonesian_month($month) . " ". $year;
    return $new_date;
}

function indonesian_yearmonth($yearmonth) {
    list($month,$year) = explode(' ', $yearmonth);
    $new_yearmonth =  indonesian_month($month) . " ". $year;
    return $new_yearmonth;
}

function bulan_hari($day) {
    $tahun = floor($day/365);
    $bulan=floor(($day - ($tahun * 365))/30);
    $hari=$day - $bulan * 30;
    if($day=="30"){return $bulan." Bulan ";}
    elseif($day >= "30"){return $bulan." Bulan, ".$hari." Hari";}
    else{return $hari." Hari";}

}
?>

2. Controller script

<?php

/**
 * @property CI_DB_active_record $db
 */
class tryhelper extends MY_Controller {

    function cobapdf() {
        parent::MY_Controller();
  $this->load->helper('general_helper');
    }

    function index() {
        echo indonesia_month('01');
    }
}
?>

Read More

Exsport to PDF with dompdf in Code Igniter

1. cDownload dompf from here and exstract the file.
2. Then put to the directory ./system/application/plugins/.
3. After that then create new file on ./system/application/plugins/dompdf_pi.php like this

<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

/**
 * Try increasing memory available, mostly for PDF generation
 */
ini_set("memory_limit", "32M");

function pdf_create($html, $filename, $stream=TRUE, $orientation="portrait") {
    require_once(BASEPATH . "application/plugins/dompdf/dompdf_config.inc.php");

    $dompdf = new DOMPDF();
    $dompdf->set_paper("a4", $orientation);
    $dompdf->load_html($html);
    $dompdf->render();
    if ($stream) { //open only
        $dompdf->stream($filename . ".pdf");
    } else { // save to file only, your going to load the file helper for this one
        write_file("pdf/$filename.pdf", $dompdf->output());
    }
}

?>

4. Create controler mypdf.php

<?php

/**
 * @property CI_DB_active_record $db
 */
class mypdf extends MY_Controller {

    function mypdf() {
        parent::MY_Controller();
  $this->load->plugins('dompdf_pi');
    }

    function index() {
     $html="Hello Word";
  $filename="Mypdf";
        pdf_create($html, $filename, $stream=TRUE, $orientation='portrait');
    }

 }
?>

Read More

Count day, month and year from two date

$tgl1 = "2009-10-01";  // 1 October 2009
$tgl2 = "2009-11-10";  // 10 October 2009

// break dates to get the date, month and year
// from the first date

$pecah1 = explode("-", $tgl1);
$date1 = $pecah1[2];
$month1 = $pecah1[1];
$year1 = $pecah1[0];

// break dates to get the date, month and year
// from the second date

$pecah2 = explode("-", $tgl2);
$date2 = $pecah2[2];
$month2 = $pecah2[1];
$year2 =  $pecah2[0];

// count JDN from each of the dates

$jd1 = GregorianToJD($month1, $date1, $year1);
$jd2 = GregorianToJD($month2, $date2, $year2);

// compute difference the second day date

$selisih = $jd2 - $jd1;
$month=floor(($selisih - ($tahun * 365))/30);
$day=$selisih - $bulan * 30;

echo "difference the both of the day date is ".$month." month ".$day." day";

This Source is originaly from www.ms-room.com

Read More

Simple Script Exsport Excel With PHP

First example

<?
header("Content-Type: application/vnd.ms-excel");
echo "<table border=1>
<tr>
<td>Cell 1</td>
<td>Cell 2</td>
</tr>
</table>";
?>

Implementation

$header = "Header1" . "\t";
$header .= "Header2" . "\t";

//Reading the data thro' POST
$data= $_POST['header1']. "\t";
$data .= $_POST['header2'] . "\t";

header("Content-type: application/x-msdownload");
header("Content-Disposition: attachment; filename=xyz.xls");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";

Read More

Recovering Ubuntu GRUB After Installing Windows

There are two method that I often use to fix the grub on ubuntu, on time after installing windows including,
First Method

1. Boot into a LiveCD (recomanded Ubuntu 9.04)
2. Open a terminal
3. Open the GRUB Command-line utility by typing

sudo grub

4. Find where Grub is. If this gives a few different answers then you will need to find the correct one, perhaps by trial-and-error.

find /boot/grub/stage1

5. Tell GRUB which partition to tell the MBR your Grub is on by entering

root (hdA,B)

6. The coordinates A,B are where 'A' is the hard-drive number, starting at 0, and 'B' is the partition number, starting at 0. For example, if Ubuntu was installed on the second partition of the first hard-drive, the command should be

root (hd0,1)

7. Tell GRUB which drive's MBR to fix

setup (hd0)

8. Replace 0 only in the extremely unlikely event that your bios does not use the first hard-drive as the boot device. Typically Ubuntu might be on any drive but the bios will almost always go to the first drive's MBR to find out where to find the boot-loader.
9. Leave the GRUB Command line

quit

10. And reboot.

If that method still dont work, you should try
Second Method

1. Insert the Ubuntu CD (for recomanded Ubuntu 9.04) select live CD
2. Once inside the desktop, open Terminal
3. Check the Linux root partition is where the command

sudo fdisk-l

4. Once the device is known Linux root partition, suppose I have a /dev/sda6 and then type

sudo mount-t ext4 /dev/sda6 /mnt/
sudo mount-t proc proc /mnt/proc/ 
sudo mount-t sysfs sys /mnt/sys/ 
sudo mount-o bind /dev/ /mnt/dev/ 
sudo chroot /mnt/bin/bash

5. Install Grub on MBR command

grub-install /dev/sda

6. Install grub on linux partition

grub-install /dev/sda7

7. after all is finished please restart.

Read More