".$lang['admin']['customers_delete_success']."
"; } else { $msg = "".$lang['admin']['customers_delete_success']."
"; } } elseif(isset($_POST['customer_id'])) { $record["title"] = $db->mySQLSafe($_POST['title']); $record["type"] = $db->mySQLSafe($_POST['type']); $record["firstName"] = $db->mySQLSafe($_POST['firstName']); $record["lastName"] = $db->mySQLSafe($_POST['lastName']); $record["email"] = $db->mySQLSafe($_POST['email']); $record["companyName"] = $db->mySQLSafe($_POST['companyName']); $record["add_1"] = $db->mySQLSafe($_POST['add_1']); $record["add_2"] = $db->mySQLSafe($_POST['add_2']); $record["town"] = $db->mySQLSafe($_POST['town']); $record["county"] = $db->mySQLSafe($_POST['county']); $record["country"] = $db->mySQLSafe($_POST['country']); $record["phone"] = $db->mySQLSafe($_POST['phone']); $record["mobile"] = $db->mySQLSafe($_POST['mobile']); $record["postcode"] = $db->mySQLSafe($_POST['postcode']); $record["optIn1st"] = $db->mySQLSafe($_POST['optIn1st']); if( (!empty($_POST['password']) && !empty($_POST['password_conf']) && $_POST['password']==$_POST['password_conf']) ){ $record["password"] = $db->mySQLSafe(md5($_POST['password'])); } if($_POST['customer_id']>0){ $where = "customer_id=".$db->mySQLSafe($_POST['customer_id']); $update = $db->update($glob['dbprefix']."CubeCart_customer", $record, $where); if($update == TRUE){ $msg = "".$lang['admin']['customers_update_success']."
"; } else { $msg = "".$lang['admin']['customers_update_fail']."
"; } } else { $record["regTime"] = $db->mySQLSafe(time()); $insert = $db->insert($glob['dbprefix']."CubeCart_customer", $record); if($insert == TRUE) { $msg = "".$lang['admin']['customers_insert_success']."
"; } else { $msg = "".$lang['admin']['customers_insert_fail']."
"; } } } if (isset($_GET['edit']) && $_GET['edit']>0) { $query = sprintf("SELECT * FROM ".$glob['dbprefix']."CubeCart_customer WHERE customer_id = %s", $db->mySQLSafe($_GET['edit'])); } else if (isset($_GET['searchStr'])) { if (is_numeric($_GET['searchStr'])) { $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_customer WHERE customer_id = ".$db->mySQLSafe($_GET['searchStr']); } else { $searchwords = split ( "[ ,]", $_GET['searchStr']); foreach($searchwords as $word) { $searchArray[]=$word; } $noKeys = count($searchArray); $like = ""; for ($i=0; $i<$noKeys;$i++) { $ucSearchTerm = strtoupper($searchArray[$i]); if(($ucSearchTerm!=="AND")AND($ucSearchTerm!=="OR")) { $like .= "(email LIKE '%".$searchArray[$i]."%' OR title LIKE '%".$searchArray[$i]."%' OR firstName LIKE '%".$searchArray[$i]."%' OR lastName LIKE '%".$searchArray[$i]."%' OR add_1 LIKE '%".$searchArray[$i]."%' OR add_2 LIKE '%".$searchArray[$i]."%' OR town LIKE '%".$searchArray[$i]."%' OR county LIKE '%".$searchArray[$i]."%' OR postcode LIKE '%".$searchArray[$i]."%' OR country LIKE '%".$searchArray[$i]."%' OR phone LIKE '%".$searchArray[$i]."%' OR ipAddress LIKE '%".$searchArray[$i]."%') OR "; } else { $like = substr($like,0,strlen($like)-3); $like .= $ucSearchTerm; } } $like = substr($like,0,strlen($like)-3); $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_customer WHERE ".$like; } } else if ($_GET['mode']!=="new") { $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_customer ORDER BY regTime DESC"; } // query database if (isset($query)) { $page = (is_numeric($_GET['page'])) ? $_GET['page'] : 0; $customerData = $db->select($query, $rowsPerPage, $page); $numrows = $db->numrows($query); $pagination = paginate($numrows, $rowsPerPage, $page, "page"); } ?>| href="?_g=customers/index&mode=new" class="txtLink" > |
![<?php echo $lang['admin']['customers_type'.$customerData[$i]['type']]; ?>](<?php echo $glob['adminFolder']; ?>/images/type<?php echo $customerData[$i]['type']; ?>.gif "<?php echo $lang['admin']['customers_type'.$customerData[$i]['type']]; ?>")
|
|
0) { ?> | href="?_g=customers/index&edit=" class="txtLink"> | href="javascript:decision('','?_g=customers/index&delete=');" class="txtLink"> | ||||