troli - inc/functions.inc.php

<?php
function kira($kiraan)
{
    return number_format($kiraan,2,'.',',');
}


function writeShoppingCart()
{
    $cart = $_SESSION['beli'];
    if (!$cart)
    {
        return '<p>Tiada item dalam pesanan</p>';
    } else
    {
        // Parse the cart session variable
        $items = explode(',',$cart);
        return '<p>Ada <a href="cart.php">' . count($items) . ' item dalam pesanan</a></p>';
    }
}

function showCart($arah)
{
    global $db;
    $cart    = $_SESSION['beli'];
    $myTable = 'senaraikek';
    $myJoin  = 'hargakek';
    $medan   = 'T.idkek, namakek, kategori, T.catatan, oum, saiz, harga';

    if ($cart)
    {
        $items = explode(',',$cart);
        $contents = array();
        foreach ($items as $item)
        {
            $contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
        }

        $output[] = ($arah=='lihat') ? '<form action="cart.php?action=update" method="post" id="cart">'
            : '<form action="tempahan_proses.php" method="post">';
        $output[] = "\r" . '<table>';

        foreach ($contents as $barang=>$qty)
        {
            $brg = explode('|',$barang);
            $id=$brg[0];
            $saiz=$brg[1];
            $sql= "\r\t\t\t\t" . 'SELECT ' . $medan . ' FROM
                ' . $myTable . ' T RIGHT JOIN ' . $myJoin . ' J
                ON T.idkek = J.idkek
                WHERE T.idkek =  "' . $id . '"
                AND saiz =  "' . $saiz . '" ';

            $result = @$db->query($sql);
            $row = @$result->fetch();
            @extract($row);

            $output[] = "\r" . '<tr>';
            $output[] = "\r" . '<td><a href="cart.php?action=delete&idkek='.$barang.'" class="r">Buang</a></td>';
            //$output[] = "\r" . '<td><img src="../images/' . $row['kategori'] . '/' .  $row['idkek'] . '.jpg" ' .
            //          'alt="' . $row['namakek'] . '" width="100" height="100"></td>';
            $output[] = "\r" . '<td>'.$namakek.'<br>'.$catatan.'</td>';
            $output[] = "\r" . '<td> 1 ' . $oum . ' ' . $saiz . '=RM '.kira($harga).'</td>';
            $jumlah= $harga * $qty;
            $jumlahBesar += $harga * $qty;
            $output[] = "\r" . '<td><input type="text" name="qty'.$barang.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
            $output[] = "\r" . '<td align="right">RM '. kira($jumlah) . '</td>';
            $output[] = "\r" . '</tr>';
        }
        $output[] = "\r" . '</table>';
        $output[] = "\r" . '<p>Jumlah Besar: <strong>RM : '.kira($jumlahBesar).'</strong></p>';
        $output[] = "\r" . '<div><button type="submit">Ubah Tempahan</button>' .
                    '<a href="tempahan.php">Beli Tempahan</a></div>';
        $output[] = "\r" . '</form>';
    }
    else
    {
        $output[] = "\r" . '<p>Senarai Tempahan Anda adalah kosong.</p>';
    }
    return join('',$output);
}

function buyCart($arah)
{
    global $db;
    $beli    = $_SESSION['beli'];
    $myTable = 'senaraikek';
    $myJoin  = 'hargakek';
    $medan   = 'T.idkek, namakek, kategori, T.catatan, oum, saiz, harga';

    if ($beli)
    {
        $items = explode(',',$beli);
        $contents = array();
        foreach ($items as $item)
        {
            $contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
        }

        $output[] = ($arah=='lihat') ? '<form action="cart.php?action=update" method="post" id="cart">'
            : '<form action="tempahan_proses.php" method="post">';
        $output[] = "\r" . '<table>';

        foreach ($contents as $barang=>$qty)
        {
            $brg = explode('|',$barang);
            $id=$brg[0];
            $saiz=$brg[1];
            $sql= "\r\t\t\t\t" . 'SELECT ' . $medan . ' FROM
                ' . $myTable . ' T RIGHT JOIN ' . $myJoin . ' J
                ON T.idkek = J.idkek
                WHERE T.idkek =  "' . $id . '"
                AND saiz =  "' . $saiz . '" ';

            $result = @$db->query($sql);
            $row = @$result->fetch();
            @extract($row);

            $jadual='tempahan['.$barang.']';
            $ahli=$_SESSION['user'];

            $output[] = "\r" . '<tr>';
            $output[] = "\r" . '<td><input type="text" name="'.$jadual.'[idkek]" value="' .
                        $idkek . '" size="10" readonly /></td>';
            $output[] = "\r" . '<td><input type="text" name="'.$jadual.'[saiz]" value="' .
                        $saiz . '" size="10" readonly /></td>';
            $output[] = "\r" . '<td> 1 ' . $oum . ' =RM ' .
                        '<input type="text" name="'.$jadual.'[harga]" value="' .
                        kira($harga) . '" size="6" readonly /> X ';
            $output[] = "\r" . '<input type="text" name="'.$jadual.'[qty]" value="' .
                        $qty . '" size="3" maxlength="3" readonly /></td>';
            $jumlah= $harga * $qty;
            $jumlahBesar += $harga * $qty;
            $output[] = "\r" . '<td align="right">RM ' . kira($jumlah) .
                        '<input type="hidden" name="'.$jadual.'[nama_ahli]" value="' .
                        $ahli . '" /></td>';
            $output[] = "\r" . '</tr>';
        }
        $output[] = "\r" . '</table>';
        $output[] = "\r" . '<p>Jumlah Besar: <strong>RM : ' . kira($jumlahBesar) . '</strong></p>';
        $output[] = "\r" . '<div><input type="submit" value="Sahkan Tempahan"></div>';
        $output[] = "\r" . '</form>';
    }
    else
    {
        $output[] = "\r" . '<p>Senarai Tempahan Anda adalah kosong.</p>';
    }
    return join('',$output);
}

function insert_table($the_table, $data)
{
    // set blank values
    $primary_id = null;
    $fields = array();

    // find fields from table
    $sql = "show columns from $the_table";
    $res = mysql_query($sql) or die('query error 1');

    while ($field = mysql_fetch_array($res))
    {
    $fields[] = $field['Field'];
    if ($field['Key'] == 'PRI') { $primary_id = $field['Field']; }
    }

    $fields = array_flip( $fields ); // flip db field array
    $filtered = array_intersect_key( $data, $fields );
    // remove non exist array on post data
    array_walk($filtered, create_function('&$val', '$val = mysql_real_escape_string(trim($val));') ); // clean up value
    $statment = vsprintf( implode( "='%s',\r\t", array_keys( $filtered ) ) . "='%s'", array_values( $filtered ) ); // create statement update

     if ($primary_id && $data[$primary_id])
    $where = "$primary_id = '$data[$primary_id]'";

    $full_sql = "\tINSERT $the_table SET
    $statment ";

    return $full_sql;
}

function update_table($the_table, $data)
{
    // set blank values
    $primary_id = null;
    $fields = array();

    // find fields from table
    $sql = "show columns from $the_table";
    $res = mysql_query($sql) or die('query error 1');

    while ($field = mysql_fetch_array($res))
    {
    $fields[] = $field['Field'];
    if ($field['Key'] == 'PRI') { $primary_id = $field['Field']; }
    }

    $fields = array_flip( $fields ); // flip db field array
    $filtered = array_intersect_key( $data, $fields );
    // remove non exist array on post data
    array_walk($filtered, create_function('&$val', '$val = mysql_real_escape_string(trim($val));') ); // clean up value
    $statment = vsprintf( implode( "='%s',\r\t", array_keys( $filtered ) ) . "='%s'", array_values( $filtered ) ); // create statement update

     if ($primary_id && $data[$primary_id])
    $where = "$primary_id = '$data[$primary_id]'";

    $full_sql = "\tUPDATE $the_table SET
    $statment
    WHERE $where";

    return $full_sql;
}

function dpt_senarai_ahli($namaAhli)
{
    global $db;
    $myTable='ahli';
    //$myJoin='hargakek';
    $medan='id,nama,alamat,notel,email,catatan';

    $sql='
        SELECT ' . $medan . ' FROM
        ' . $myTable . ' WHERE nama="'.$namaAhli.'" ';

    $result = $db->query($sql);
    $row = @$result->fetch();
    @extract($row);

    $ahli['id']=$id;
    $ahli['nama']=$nama;
    $ahli['alamat']=$alamat;
    $ahli['notel']=$notel;
    $ahli['email']=$email;
    $ahli['catatan']=$catatan;

    return $ahli;

}

function hantar_email($ahli)
{
    // Receiving variables
    @$Pekedai= addslashes($ahli['pekedai']);
    @$Nama = addslashes($ahli['nama']);
    @$Alamat = addslashes($ahli['alamat']);
    @$Email = addslashes($ahli['email']);
    @$Handset = addslashes($ahli['notel']);

    // Validation
    $error = "<strong>Ralat!!!</strong><br />
    Email anda tidak dapat dihantar disebabkan beberapa<br />
    kesilapan mungkin berlaku semasa mengisi borang email.<br />
    sila tekan <a href='#' onClick='self.close();return false;'>di sini</a> untuk membuat pembetulan";

    #####################################################
    // take a given email address and split it into the username and domain.
    list($userName, $mailDomain) = split("@", $Email);
    if (checkdnsrr($mailDomain, "MX")) {
      // this is a valid email domain!
     $amaran="email anda adalah sah";
    }
    else {
      // this email domain doesn't exist! bad dog! no biscuit!
     $amaran="tak";
     $error2=0;
    }
    #####################################################

    //if ($error2 == 0 ){echo "<h1>email anda adalah tidak sah, mahu tipu kah!!!!!</h1>";exit;}
    /*
    if (strlen($Nama) == 0 ){echo "$error:$Nama";exit;}
    if (strlen($Alamat) == 0 ){echo "$error:$Alamat";exit;}
    if (! ereg('[A-Za-z0-9_-]+\@[A-Za-z0-9_-]+\.[A-Za-z0-9_-]+', $Email)){echo "$error:$Email";exit;}
    if (strlen($Email) == 0 ){echo "$error:$Email";exit;}
    if (strlen($Handset) == 0 ){echo "$error:$Handset";exit;}
    if (strlen($Mesej) == 0 ){echo "$error:$Mesej";exit;}
    */
    //Sending Email to form owner
    # Email to Owner
    $mail_dari = "From: $Nama <$Email>";
    $mail_subjek = "[Tempahan Kek]";
    $mail_to = $Pekedai;
    $mail_mesej = "[Tempahan Kek]
    -------------------------------------------------------------
    Nama Saya  : $Nama
    Email Saya : $Email
    Handset    : $Handset
    Tarikh :".date("Y-m-d")."
    -------------------------------------------------------------
    Mesej : Ada pesanan kek sudah sampai
    -------------------------------------------------------------";
    // cth -> mail (to, subject, body, headers)
    //mail ( string $to, string $subject, string $message [, string $additional_headers [, string $additional_parameters]] )
    @mail($mail_to, $mail_subjek ,$mail_mesej, $mail_dari);

    //echo $mail_to.'|'.$mail_subjek.'|'.$mail_mesej.'|'.$mail_dari;


}
function bersih($papar)
{
    # lepas lari aksara khas dalam SQL
    $papar = mysql_real_escape_string($papar);
    # buang ruang kosong (atau aksara lain) dari mula & akhir
    $papar = trim($papar);

    return $papar;
}
?>