New Notes:
Notes are dated automatically.
List for Email Marketing Program
Activity Report
$listemb = @mysql_query("SELECT ID,act_year,act_month,act_day,contact_type,act_respond,dtnum FROM con_activity WHERE CID='$ID'");
if (!$listemb) {
die('Error retrieving data from data base. ' . 'Error: '. mysql_error(). '
');
}
while($rowb = mysql_fetch_array($listemb)){
$act_ID = $rowb[0];
$act_y = $rowb[1];
$act_m = $rowb[2];
$act_d = $rowb[3];
$act_type = $rowb[4];
$act_resp = $rowb[5];
$dateup = $dtnum[6];
echo("~ $act_m-$act_d-$act_y : $act_type : $act_resp
");
}
$listemc = @mysql_query("SELECT ID,CID,react_year,react_month,react_day FROM con_reactivity WHERE CID='$ID'");
if (!$listemc) {
echo('Error retrieving data from data base. ' . 'Error: '. mysql_error(). '
');
}
$num_rows = mysql_num_rows($listemc);
if($num_rows < 1){
$act_flag = " ";
}else{
$act_flag = " ";
$rowc = mysql_fetch_row($listemc);
$RID = $rowc[0];
$CID = $rowc[1];
$ract_y = $rowc[2];
$ract_m = $rowc[3];
$ract_d = $rowc[4];
if($ract_y == 0){
$ract = 'ASAP';
}else{
$ract = $ract_m.'-'.$ract_d.'-'.$ract_y;
}
echo("$act_flag~ $ract " .
" " .
"
");
}
?>
Follow-up Report
Date:
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Type: Visit
Phone
Email
Response: +Pos
~NC
-Neg
Set RE-Contact Date
(OPT)
Date:
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Notes:
$listemc = @mysql_query("SELECT CID,Notes,dtnum FROM con_notes WHERE CID='$ID' ORDER BY dtnum");
if (!$listemc) {
die('Error retrieving Notes from data base. ' . 'Error: '. mysql_error(). '
');
}
while($rowc = mysql_fetch_array($listemc)){
$CID = $rowc[0];
$Notes = stripslashes($rowc[1]);
$dtnum = $rowc[2];
$chunk_dtnum = chunk_split($dtnum, 2, ":");
$chunk_arr = explode(":", $chunk_dtnum);
echo("$chunk_arr[2]-$chunk_arr[3]-$chunk_arr[0]$chunk_arr[1] - $Notes
");
}
?>
mysql_select_db('ecosmar_products', $dbcnx);
$ok4 = @mysql_query("SELECT ID,CID,MID FROM mfg_con WHERE CID='$ID'");
if(!$ok4){
echo "Problem getting Mfg. Register ". mysql_error();
}else{
$num_rows = mysql_num_rows($ok4);
if($num_rows < 1){
echo ("This Contact has not been registered with any Manufacturers.");
}else{
echo ("This Contact has been registered with Manufacturers: ");
}
while($row4 = mysql_fetch_array($ok4)){
$thisID = $row4['ID'];
$thisCID = $row4['CID'];
$regarray[] = $row4['MID'];
}
$i = 0;
$mfgcount = count($regarray);
while($i < $mfgcount){
$ok5 = @mysql_query("SELECT ID,prod_name FROM mfg WHERE ID='$regarray[$i]'");
if(!$ok5){
echo "Problem getting Mfg. Register ". mysql_error();
}else{
$row5 = mysql_fetch_array($ok5);
$nameo = $row5[1];
echo (" $nameo ");
}
$i = $i+1;
}
}
?>
Contact Options
Register Contact with Manufacturer
Register Contact as an Eco-$mart Dealer
Request Referral Payments TO THIS CONTACT