Jack Hau Story: 2014

Admin Page :

Create a search function at admin main page.
Login password using md5 encryption function which human not readable to protect the system.
Who approved the member becomes an owner.
Updated the latest status which is promotion or announcement.
Increase the font size of the page wills more prefects.

Member Page :

Login validation error.
Create the password with md5 encryption function.
Add random number in front of picture.
Split the user and owner if not will mess up the database.
Homestay list can list can open a new column for action for delete or edit function.
When users change their password must force them the logout and login with new password because we using session.
Upload multiple pictures with Jquery.

md5 encryption : Php

$member_signup_pass = md5(trim($_POST["member_signup_pass"]));
$member_signup_Conpass = md5(trim($_POST["member_signup_Conpass"]));

No comments

Datepicker is tied to a standard form input field which allow user click to open an interactive calendar in a small overlay. Implemented Jquery to set min Date and max Date

<script>
$(function() {
$( "#check_in" ).datepicker({
    defaultDate: "+1w",
    changeMonth: true,
    minDate: 0,
    onClose: function( selectedDate ) {
        var selectedDate = $(this).datepicker('getDate');
            if (selectedDate) {
                  selectedDate.setDate(selectedDate.getDate() + 1);
            }
    $( "#check_out" ).datepicker( "option", "minDate", selectedDate );
    }
    });
$( "#check_out" ).datepicker({
    defaultDate: "+1w",
    changeMonth: true,
    minDate: 0,
    onClose: function( selectedDate ) {
    $( "#check_in" ).datepicker( "option", "maxDate", selectedDate );
    }
    });
});
</script>

No comments

FPDF is a PHP class which allows to generate PDF files with pure PHP.

Design and generate PDF. Reservation statement

Sample code :

<?php 

require('fpdf.php');
include("../connection.php");

$reservation_id = $_REQUEST['reservation_id'];
$member_id = $_REQUEST['member_id'];

$sql = "select member_name from member where member_id = $member_id";
$result_member = mysql_query($sql);
$row_member = mysql_fetch_assoc($result_member);
$member_name = $row_member['member_name'];

$sql = "select * from reservation join homestay on reservation.homestay_id = homestay.homestay_id ".
        "join member on homestay.member_id = member.member_id where reservation.reservation_id = $reservation_id";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$start = $row['checkIn_date'];
$end = $row['checkOut_date'];
$reservation_date = $row['reservation_date'];
$night = (strtotime($end)- strtotime($start))/24/3600; 

class PDF extends FPDF
{
// Page header
function Header()
{
    // Logo
    $this->Image('../images/homestay-logo.png',10,10,50);   
    // Move to the right
    $this->Cell(100);
    // Arial bold 15
    $this->SetFont('Arial','B',20);
    // Title
    $this->Cell(0,20,'Statement of Reservation','C');
    // Line break
    $this->Ln(20);
}

// Page footer
function Footer()
{
    // Position at 1.5 cm from bottom
    $this->SetY(-15);
    // Arial italic 8
    $this->SetFont('Arial','I',8);
    // Page number
    $this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
}
}


// Instanciation of inherited class
$pdf = new PDF();
$pdf->AddPage();

$pdf->SetFont('Times','B',18);
$pdf->Cell(80,10,'MyHomestay');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,0,'1234 ST.');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,7.5,'Denver, CO 80202');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,0,'Phone:(60)123-4567');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,7.5,'myhomestaymmu@gmail.com');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,0,'www.homestay.com');
$pdf->Ln();
$pdf->Cell(130);
$pdf->SetFont('Arial','',12);
$reservation_date = date("Y-m-d",strtotime($reservation_date));
$pdf->Cell(0,-40,'Reservation Date :  '.$reservation_date,'C');
$pdf->Cell(0,-40,'','C');

$date = date("Y-m-d");
$pdf->Cell(-53.5,-25,'Generate Date :  '.$date,0,1,'C');

$pdf->Cell(0,40,'',0,1,'R');



$word = "To,".
        "\n$member_name".
        "\nDear Sir/Madam,".
        "\nThank you for your reservation. We confirm with pleasure your accommodation.".
        "\nPlease note the information below for accuracy".
        "\nPlease review it and report any discrepancies.";
$pdf->Multicell(160,6,$word);

$pdf->Cell(0,10,'',0,1,'R');

$pdf->SetFillColor(169, 169, 169);
$pdf->SetTextColor(0);
$pdf->SetDrawColor(255, 255, 255);
$pdf->Cell(18,7,'Res.Id',0,0,'L',true);
$pdf->Cell(35,7,'Guest Name',0,0,'L',true);
$pdf->Cell(35,7,'Homestay Name',0,0,'L',true);
$pdf->Cell(28,7,'Check In',0,0,'C',true);
$pdf->Cell(28,7,'Check Out',0,0,'C',true);
$pdf->Cell(18,7,'Nights',0,0,'C',true);
$pdf->Cell(26,7,'Amount',0,1,'C',true);

$pdf->Cell(0,0,'',0,1,'R');
$pdf->Cell(15,7,$row['reservation_id'],1,0,'C',0);
$pdf->Cell(28,7,$member_name,1,0,'C',0);
$pdf->Cell(44,7,$row['homestay_name'],1,0,'C',0);
$pdf->Cell(28,7,$row['checkIn_date'],1,0,'C',0);
$pdf->Cell(30,7,$row['checkOut_date'],1,0,'C',0);
$pdf->Cell(17,7,$night,1,0,'C',0);
$pdf->Cell(25,7,$row['reservation_total_price'],1,0,'C',0);

// Linienfarbe auf Blau einstellen 
$pdf->SetDrawColor(0, 0, 0);

// Linienbreite einstellen, 0.5 mm
$pdf->SetLineWidth(0.5);

// Linie zeichnen
$pdf->Line(10,132,198,132);

$pdf->SetFont('Arial','B',12);

$reservation_total_price = $row['reservation_total_price'];

$pdf->Cell(0,18,'',0,1,'R');
$pdf->Cell(182,3,'Total:  RM'.$reservation_total_price,0,1,'R');
$pdf->Cell(0,3,'',0,1,'R');


$pdf->Output();

?>

No comments

As an intern at the Times Software I assigned to support department around one month. Handle customers’ enquiries and complaints by email and telephone communication. Since the company Times Software Sdn Bhd service in Malaysia, the communication includes multiple languages such as English, Bahasa Malaysia, Mandarin and Cantonese. Conceptualize clients’ requirements to actual system implementation. It used TeamViewer 8.0 to remote control customer computer teach them and help customer foxed problem.

Times Payroll 8.0 System is a Client-Server based payroll and Leave software. By using the famous database engine – Advantage Database Server is a scalable, high performance client-server RDBMS for networked, standalone, Internet and mobile database applications. As a support executive have to know how to calculate EPF contribution and PCB deduction formula. During testing on the Times Payroll 8.0 System I made a crossover cable to do backup from one computer to another computer before colleague format the computer.

One month over I assigned to developer department to study the Times E-Module Web Application that used Internet technologies to support the web-based paperless for your employee. The Times E-Module includes E-Leave, E-Claim, E-HR, E-Payslip and E-Attendance. One of the example E-Leave, It helps to keep staff up-to-date theirs leaves information without disturbing HR department staff and their supervisors. It assists HR professionals to streamline tedious Leave management and monthly leaves reports generation for each departmental heads. It assists to manage the leave float and staff could plan up their leave application that link to the Times Pay/HR 8.0 HR Administrator can easily assess employees’ current leaves status, details and retrieve the leave data required for internal leave costing. All departmental heads could easily monitor their own staff leave and view all leaves in Calendar presentation and leave reports.

The Times Software used Visual C# ASP.NET Web Application to develop the Times E-Module. The company has given the testing module E-Leave source code to me study. I has install Microsoft Visual Studio 2010 that able to open the testing module E-Leave, Microsoft Report Viewer 2010 that able to view report on the website. Setup Internet Information Server (IIS) Web Server provided by Microsoft that is able to hast and run web applications. The E-Leave was using ASP.NET Web Application Framework to designed, Server scripting with C# and using Advantage Database Server as database server. The Times Payroll 8.0 System and Times E-Module Web Application both database tables can view on Advantage Data Architect that import and convert other table types (such as Paradox, dBASE, Access, Btrieve, Pervasive and MS SQL Server) to Advantage compatible tables. Also create and maintain Advantage data dictionaries and define referential integrity rules, record and field level constraints. Using cmd command telnet test connectivity the different ports on the servers that can be access.

While surveying the company network infrastructure that I know that the Domain Controller (DC) is a server that handles all the security requests from other computer and servers within the Windows Server domain. The domain controller originated in Windows NT and managed the access to various resources granted to users and other servers through the use of a username and password. By using cmd command dcpromo install Active Directory into the server Domain Control Server. Open Active Directory Users and Computers to create new user accounts and manage existing user accounts. Other that, testing how to setup a wireless router as an access point that able to share the Internet or increase the range of wireless signal. Learning how the Intranet computer network that uses Internet Protocol technology to share information, operational systems, or computing services within an organization. Since, the four servers are connected to the Ethernet switches that can be access servers file sharing over wireless.

No comments

This form is Patient Information for staff to enter patients details such as patient id, patient name, patient gender, patient ic, patient contact no and patient email. Besides that, we set few button at the bottom for easy way to key in record, delete record or switch to other page. Those buttons such as Main, delete record, add record, save record, search record and proceed to appointment form button. It’s useful because we can proceed to next form or switch back to that form easily. The advantage that we design this form is to reduce data redundancy and save time. It can avoid our database appear repeated data.

This is a complete report that show all patients information such as patient id, patient name, patient gender, patient contact no, patient email. The advantage come out of this report is for staff to view their clinic have how many patient.

This form is Staff Information for staff to enter staff details such as staff id, staff name, staff gender, staff ic, staff contact no and staff email. The advantage that we design this form is to reduce data redundancy and save time. It can avoid our database appear repeated data

This report complete to show staff detail such as staff id, staff name, staff contact no, staff email. The advantage come out of this report is easy for clinic keep track staff. For example, some emergency case needs immediacy calling staff come back clinic

This form is about Patient Appointment. We can enter a unique appointment code, patient id, staff id, appointment date and appointment reason. At the same time, we use combo box in Staff ID, so that when adding new staff the system will automatically update on Appointment form. The advantage come out with this form is measure appointment time with no collision happens

This report clearly list out all the staff and every day of patient appointment such as staff id, patient id, appointment id, appointment date, appointment reason. The advantage come out of this report is for staff to explicitly view their appointment at which date and the patient appointment reason

Sample VB code showing appointment in dialog :

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        PrintDialog1.Document = PrintDocument1
        PrintDialog1.PrinterSettings = PrintDocument1.PrinterSettings
        PrintDialog1.AllowSomePages = True
        If PrintDialog1.ShowDialog = DialogResult.OK Then
            PrintDocument1.PrinterSettings = PrintDialog1.PrinterSettings
            PrintDocument1.Print()
        End If
    End Sub

No comments

About me

Labels

recent posts

Follow Us

Blog Archive