Login   Register  
PHP Classes
elePHPant
Icontem

File: datamanage/customer-view.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mathew  >  Data Manager  >  datamanage/customer-view.php  >  Download  
File: datamanage/customer-view.php
Role: Example script
Content type: text/plain
Description: customer-view
Class: Data Manager
Retrieve and store MySQL records using Web forms
Author: By
Last change:
Date: 8 months ago
Size: 6,980 bytes
 

Contents

Class file image Download
<?php
session_start
();
include(
'config.php');

if(isset(
$_REQUEST['idVal']))
{
    
$id $_REQUEST['idVal'];
    
$Sql "update customer set status=0 where id = '$id'";
    
$db->sql_query($Sql);
}
$tableTitleList = array('SlNo.','Type','Organisation','Contact Person','Designation''Address','Phone','Email','Website','Option');
$widthVal = array(4,10,10,10,10,15,8,10,8,6);
$display = array(0,1,2,3,4,5,6,7,8,9);

// search
$data = array();
$sIn $_REQUEST['sIn'];
$sFor $_REQUEST['sFor'];
$sTo $_REQUEST['sTo'];
$operator $_REQUEST['operator'];
$searchList = array('Organisation','Contact Person','Designation','Address','City','State','Country','Phone','Website');
$fldList = array('org','cname','desig','address','city','state','country','ph','web');
$dateFld = array();
$search = new mySearch($fldList,$dateFld);
$sqlAdd $search -> getSearch($sIn,$sFor,$operator,$sTo);
$wVal 145;
$status = ($_REQUEST['status'] != "") ? $_REQUEST['status'] : "1";
$ctype $_REQUEST['ctype'];
$sqlAdd .= ($ctype != "") ? " and ctype = '$ctype' " "";
$sql "select * from customer where status='$status$sqlAdd order by org";
$Result_Set = (isset($_REQUEST['Result_Set']))? $_REQUEST['Result_Set'] : 0;
$page = new myPager($sql,$Result_Set,$perpage);
$data $page->getData();
$links "";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?=$title?></title>
<link rel="stylesheet" href="css/style.css" type="text/css" />
<style>
.data-outer{ margin-bottom:20px; clear:both; border:1px #CCCCCC solid; width:100%; height:320px;overflow:auto;}
.data-outer-search{ margin-bottom:20px; clear:both; border:1px #CCCCCC solid;  width:100%; height:100%;overflow:auto;}
.title-outer{border-top:1px #ffffff solid;  float:left; width:<?=$wVal?>%;background-color:#F1F1F1; border-bottom:1px #CCCCCC solid;}
.col-outer{ border-bottom:1px #CCCCCC solid; float:left; width:<?=$wVal?>%; overflow:hidden; clear:both;  }
.title-1{ padding:4px; float:left; border-right:1px #CCCCCC solid; font-weight:bold;}
.col-1{ padding:4px; float:left; border-right:1px #CCCCCC solid;margin-bottom:-300px; padding-bottom:300px;}
</style>
<script language="javascript" src="js/jquery.js"></script>
<script language="javascript" src="js/search_js.js"></script>
</head>
<body>
<form name="frmEdit" method="post">
    <input type="hidden" value="" name="idVal" id="idVal"/>
</form>
    <div id="container">
            <div class="content">
                <h1>Contacts</h1>
                <div class="search">
                  <a href="#" class="link-blue" rel="toggle[alerts]">Search</a>| <a href="customer-new.php" class="link-blue">New</a>  | <a href="customer-view.php" class="link-blue">View
                          </a> 
                </div>
              
              <div id="alerts">    
                    <form method="post" name="paging" action="customer-view.php" enctype="multipart/form-data" >
                       <input type="hidden" name="Result_Set" value=""/>
                      <div class="data-outer-search" >
                      <?php include_once('inc/s_filter.php'?>
                      </div>
                      <p style="float:left; padding-left:5px; padding-top:10px;">
                        <div style="float:left; padding-right:5px;"> Status : </div> 
                        <div style="float:left; padding-right:5px;">
                            <select name="status" class="select" style="width:80px;">
                                <option value="1" selected="selected"> Active </option>
                                <option value="0" <? if($status == 0) {echo "selected='selected'"; }?> > Inactive </option>
                            </select> 
                         </div>
                        <div style="float:left; padding-right:5px;"> Type : </div> 
                        <div style="float:left; padding-right:5px;">
                            <select name="ctype" class="select" style="width:100px;">
                            <option value="" selected="selected"> Type </option>
                            <option value="1" <? if($ctype == ) {echo "selected='selected'"; }?>> Customer </option>
                            <option value="2" <? if($ctype == ) {echo "selected='selected'"; }?> >
                             Contact </option>
                            <option value="3" <? if($ctype == ) {echo "selected='selected'"; }?> >
                             Vendor </option>
                            </select>                        
                        </div>
                                                
                         <div style="float:left; padding-right:5px;">
                         <input type="submit" class="button"  value="Submit" name="Submit" />
                         <input type="reset" class="button"  value="Reset" />
                         </div>
                      </p>
                  </form>
              </div>
             <form name="report" id="report" method="post"    action="<?=$_SERVER['PHP_SELF']?>" >        
                    <div class="data-outer">
                    <div class="title-outer">
                    <?php for($i=0;$i<count($display);$i++)
                            { 
                                
$styleLast = ($i == (count($display)-1)) ? "border-right:0px;" "";

                            
?>
                                    <div class="title-1" style="width:<?=$widthVal[$display[$i]]?>%;<?=$styleLast?>">
                                                                <?=$tableTitleList[$display[$i]]?></div>
                    <?php ?>
                    </div>
                    
                    <?php
                        $slNo 
$Result_Set;
                        foreach(
$data as $row)
                        {
                            
$slNo++;
                            
                            
$org $row['org'];
                            
$conPer $row['cname'];
                            
                            
$desig $row['desig'];
                            
$addr $row['address'];
                            if(
$row['city']!="")
                            {
                                
$addr.="\n" .$row['city'];
                                if(
$row['pin']!="")
                                    
$addr.="-" .$row['pin'];
                            }        
                            if(
$row['state']!="")
                                
$addr.="\t\t" .$row['state']; 
                            if(
$row['country']!="")
                                
$addr.=", " .$row['country'];
                                
                            if(
$row['ph']!="")
                                
$phone $row['ph'];
                            if(
$row['mob']!="")
                                
$phone.="\nMob :" .$row['mob'];
                                                        
                            
$email $row['email'];
                            
$webst $row['web'];
                            
$optVal "<a href=\"javascript:editData('customer-new.php','".$row['id']."')\">
                                        Edit</a>  | "
;
                            
$optVal .= "<a href=\"javascript:delData('customer-view.php','".$row['id']."')\">
                                        Del</a> "
;
                            
                            
$ctypeVal "Customer";
                            if(
$row['ctype'] == 2) { $ctypeVal "Conatact";}
                            if(
$row['ctype'] == 3) { $ctypeVal "Vendor";}
    
                            
$dataList = array($slNo,$ctypeVal,$org,$conPer,$desig,$addr,$phone,$email,$webst,$optVal);                                                                        
                    
?> 
                        <div class="col-outer">
                        <?php for($i=0;$i<count($display);$i++){ 
                        
$styleLast = ($i == (count($display)-1)) ? "border-right:0px;" "";
                        
?>            
                                <div class="col-1" style="width:<?=$widthVal[$display[$i]]?>%; <?=$styleLast?>">
                                <?=$dataList[$display[$i]]?>
                                </div>
                         <?php ?>
                    </div>
                <?php ?>
                </div>
                <div class="paging-outer">
                        <?=$page->showLinksForm(10,$links);?>
                </div>
            </form>                
            </div>
        </div>
    <script type="text/javascript" src="js/jquery.min.js"></script>
    <script type="text/javascript" src="js/animatedcollapse.js"></script>
    <script type="text/javascript" src="js/fade.js"></script>
</body>
</html>