'); $displayname = $_SESSION['displayname']; include"template/top.php" ; $query="SELECT * FROM `content` WHERE `title` = 'gphome'"; $result=mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $content = stripslashes(mysql_result($result,$i,"content")); $author = htmlentities(mysql_result($result,$i,"author")); echo($content); $i++; } include"template/bottum.php" ; } function logout(){ session_start(); $_SESSION = array(); if (isset($_COOKIE[session_name()])) { setcookie(session_name(), '', time()-42000, '/'); } session_destroy(); echo(''); } function login(){ $ip = $_SERVER['REMOTE_ADDR']; $hostaddress = gethostbyaddr($ip); echo ('
Welcome user from
Please login to begin.
Username
Password

 

©2008 Genesis I-Tech Solutions.com.
v1.0.0
'); } function service_reports(){ if (!isset($_SESSION['loggedin'])) die(''); $displayname = $_SESSION['displayname']; $username = $_SESSION['username']; include"template/top.php" ; echo ('
Last 30 Service Reports
') ; $query="SELECT * FROM `service_reports` WHERE `username` = '$username' ORDER BY sr_date DESC LIMIT 30"; $result=mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $crow++; $row_color = (((1&$crow)) ? "#666666" : "#999999"); $id = stripslashes(mysql_result($result,$i,"id")); $sr_date = stripslashes(mysql_result($result,$i,"sr_date")); $contact = htmlentities(mysql_result($result,$i,"contact")); $time_total = htmlentities(mysql_result($result,$i,"time_total")); $sr_desc = htmlentities(mysql_result($result,$i,"sr_desc")); echo(''); $i++; } echo ('
Date: '.$sr_date.' | Billable Time : '.$time_total.' Contact: '.$contact.'
SR Title: '.$sr_desc.'
') ; include"template/bottum.php" ; } function account_information(){ if (!isset($_SESSION['loggedin'])) die(''); $displayname = $_SESSION['displayname']; $username = $_SESSION['username']; include"template/top.php" ; echo ('
Account Information
') ; $query="SELECT * FROM `client_company` WHERE `username` = '$username'"; $result=mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $id = stripslashes(mysql_result($result,$i,"id")); $username = stripslashes(mysql_result($result,$i,"username")); $company = htmlentities(mysql_result($result,$i,"company")); $contact = htmlentities(mysql_result($result,$i,"name1")); $email = htmlentities(mysql_result($result,$i,"email")); $website = htmlentities(mysql_result($result,$i,"website")); $address1 = htmlentities(mysql_result($result,$i,"address1")); $address2 = htmlentities(mysql_result($result,$i,"address2")); $city = htmlentities(mysql_result($result,$i,"city")); $state = htmlentities(mysql_result($result,$i,"state")); $zip = htmlentities(mysql_result($result,$i,"zip")); $country = htmlentities(mysql_result($result,$i,"country")); $accttype = htmlentities(mysql_result($result,$i,"accttype")); $reg_date = htmlentities(mysql_result($result,$i,"reg_date")); $tel = htmlentities(mysql_result($result,$i,"tel")); $status = htmlentities(mysql_result($result,$i,"status")); echo ('
Status
 '.$status.'
Member Since
'.$reg_date.'
Primary Contact
'.$contact.'
Email
 '.$email.'
Company
 '.$company.'
Tel
'.$tel.'
Address 1
 '.$address1.'
 
Address 2
'.$address2.'
Sales Rep
 
City
 '.$city.'
Primary Engineer
 
State
 '.$state.'
Account Type
'.$accttype.'
Zip / Postal Code
'.$zip.'
 
Country
 '.$country.'
 
       
 
    
  
') ; $i++; } include"template/bottum.php" ; } function account_information_update(){ if (!isset($_SESSION['loggedin'])) die(''); $displayname = $_SESSION['displayname']; $username = $_SESSION['username']; include"template/top.php" ; echo ('
Account Information
') ; $query="SELECT * FROM `client_company` WHERE `username` = '$username'"; $result=mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $id = stripslashes(mysql_result($result,$i,"id")); $username = stripslashes(mysql_result($result,$i,"username")); $company = htmlentities(mysql_result($result,$i,"company")); $contact = htmlentities(mysql_result($result,$i,"name1")); $email = htmlentities(mysql_result($result,$i,"email")); $website = htmlentities(mysql_result($result,$i,"website")); $address1 = htmlentities(mysql_result($result,$i,"address1")); $address2 = htmlentities(mysql_result($result,$i,"address2")); $city = htmlentities(mysql_result($result,$i,"city")); $state = htmlentities(mysql_result($result,$i,"state")); $zip = htmlentities(mysql_result($result,$i,"zip")); $country = htmlentities(mysql_result($result,$i,"country")); $accttype = htmlentities(mysql_result($result,$i,"accttype")); $reg_date = htmlentities(mysql_result($result,$i,"reg_date")); $tel = htmlentities(mysql_result($result,$i,"tel")); $status = htmlentities(mysql_result($result,$i,"status")); echo ('
Status
 '.$status.'
Member Since
'.$reg_date.'
Primary Contact
'.$contact.'
Email
Company
Tel
Address 1
 
Address 2
Sales Rep
 
City
Primary Engineer
 
State
Account Type
'.$accttype.'
Zip / Postal Code
 
Country
 '.$country.'
 
       
   
') ; $i++; } include"template/bottum.php" ; } function client_staff(){ if (!isset($_SESSION['loggedin'])) die(''); $displayname = $_SESSION['displayname']; $username = $_SESSION['username']; include"template/top.php" ; echo ('
Client Staff
') ; $query="SELECT * FROM `client_staff` WHERE `username` = '$username' ORDER BY name1"; $result=mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $id = stripslashes(mysql_result($result,$i,"id")); $username = stripslashes(mysql_result($result,$i,"username")); $contact = htmlentities(mysql_result($result,$i,"name1")); $email = htmlentities(mysql_result($result,$i,"email")); $dept = htmlentities(mysql_result($result,$i,"dept")); $branch = htmlentities(mysql_result($result,$i,"branch")); $tel = htmlentities(mysql_result($result,$i,"tel")); echo ('
Name
 '.$contact.'
Tel
 '.$tel.'
Department
 '.$dept.'
Email
 '.$email.'
Branch
 '.$branch.'    
') ; $i++; } include"template/bottum.php" ; } function do_account_information_update(){ if (!isset($_SESSION['loggedin'])) die(''); $displayname = $_SESSION['displayname']; $username = $_SESSION['username']; mysql_query("UPDATE client_company SET company = '".$_POST['company']."' WHERE username = '$username'"); mysql_query("UPDATE client_company SET address1 = '".$_POST['address1']."' WHERE username = '$username'"); mysql_query("UPDATE client_company SET address2 = '".$_POST['address2']."' WHERE username = '$username'"); mysql_query("UPDATE client_company SET city = '".$_POST['city']."' WHERE username = '$username'"); mysql_query("UPDATE client_company SET state = '".$_POST['state']."' WHERE username = '$username'"); mysql_query("UPDATE client_company SET zip = '".$_POST['zip']."' WHERE username = '$username'"); mysql_query("UPDATE client_company SET email = '".$_POST['email']."' WHERE username = '$username'"); mysql_query("UPDATE client_company SET tel = '".$_POST['tel']."' WHERE username = '$username'"); echo (''); } function invoice_manager(){ if (!isset($_SESSION['loggedin'])) die(''); $displayname = $_SESSION['displayname']; $username = $_SESSION['username']; include"template/top.php" ; echo ('
Last 30 Service Reports
') ; $query="SELECT * FROM `service_reports` WHERE `username` = '$username' ORDER BY sr_date DESC LIMIT 30"; $result=mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $crow++; $row_color = (((1&$crow)) ? "#666666" : "#999999"); $id = stripslashes(mysql_result($result,$i,"id")); $sr_date = stripslashes(mysql_result($result,$i,"sr_date")); $contact = htmlentities(mysql_result($result,$i,"contact")); $time_total = htmlentities(mysql_result($result,$i,"time_total")); $sr_desc = htmlentities(mysql_result($result,$i,"sr_desc")); echo(''); $i++; } echo ('
Date: '.$sr_date.' | Billable Time : '.$time_total.' Contact: '.$contact.'
SR Title: '.$sr_desc.'
') ; include"template/bottum.php" ; } ?>