|
Eco-$mart Project Report
|
|
|
Error: ". mysql_error());
}
$num_rows = count($new);
if($num_rows < 1){
echo("
");
}else{
while($row = mysql_fetch_array($new)){
$ID = $row['ID'];
$Project_Name = $row['Project_Name'];
$usrn = $row['usrn'];
$CID = $row['CID'];
$product = $row['product'];
$produc = nl2br($product);
$action = $row['action'];
if($action == ""){
$action = "No immediate action";
}
$act = stripslashes($action);
$note = $row['note'];
if($note == ""){
$note = "No original note.";
}
$status = $row['status'];
$due = $row['due'];
$chunk_due = chunk_split($due, 2, ':');
$chunk_arrd = explode(":", $chunk_due);
$duem = $chunk_arrd[2].'/'.$chunk_arrd[3].'/'.$chunk_arrd[0].$chunk_arrd[1];
$dtnum = $row['dtnum'];
$chunk_dt = chunk_split($dtnum, 2, ':');
$chunk_arrt = explode(":", $chunk_dt);
$dtem = $chunk_arrt[2].'/'.$chunk_arrt[3].'/'.$chunk_arrt[0].$chunk_arrt[1];
echo("
" .
"PROJECT NAME: $Project_Name
NEW: $dtem--DUE: $duem--STATUS: $status");
mysql_select_db('ecosmar_friendly', $dbcnx);
$getacts = @mysql_query("SELECT action,status,usrn,dtnum FROM task_action WHERE Project_Name='$Project_Name' AND PID='$ID' ORDER BY dtnum DESC");
if (!$getacts) {
echo("
Problem retrieving Full Action List.
Error: ". mysql_error()." | ");
}else{
$num_rows = mysql_num_rows($getacts);
if($num_rows < 1){
echo ("
ACTION LIST:
$dtem - $act");
}else{
echo("
ACTION LIST:");
while($rowa = mysql_fetch_array($getacts)){
$gotaction = stripslashes($rowa['action']);
$status = $rowa['status'];
if($status == 'Done'){
$color = 'gray';
}else{
$color = 'black';
}
$act_usrn = $rowa['act_usrn'];
$act_dtnum = $rowa['dtnum'];
$chunk_act = chunk_split($act_dtnum, 2, ':');
$chunk_arra = explode(":", $chunk_act);
$daem = $chunk_arra[2].'/'.$chunk_arra[3].'/'.$chunk_arra[0].$chunk_arra[1];
echo("
$daem - $act_usrn $gotaction");
}
echo("
$dtem - $act");
}
}
echo("
NOTES:");
$getnotes = @mysql_query("SELECT note,usrn,dtnum FROM task_notes WHERE Project_Name='$Project_Name' AND PID='$ID' ORDER BY dtnum ASC");
if (!$getnotes) {
echo("
Problem retrieving All Notes.
Error: ". mysql_error());
}else{
$num_rows = mysql_num_rows($getnotes);
if($num_rows < 1){
echo("
$dtem - $usrn $note");
}else{
while($rowg = mysql_fetch_array($getnotes)){
$tnote = $rowg['note'];
$notusrn = $rowg['usrn'];
$dtnum = $rowg['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arrd = explode(":", $chunk_dtnum);
$dadm = $chunk_arrd[2].'/'.$chunk_arrd[3].'/'.$chunk_arrd[0].$chunk_arrd[1];
echo("
$dadm - $notusrn $tnote");
}
echo("
$dtem - $usrn $note");
}
}
mysql_select_db('ecosmar_contacts', $dbcnx);
$contactnfo = @mysql_query("SELECT first_Name,Name,Phone,email FROM con_main WHERE usrn='$usrn' AND ID='$CID'");
if (!$contactnfo) {
echo("Problem retrieving Contact Info.
Error: ". mysql_error()." |
");
}
$contact = mysql_fetch_array($contactnfo);
$first_Name = $contact['first_Name'];
$Name = $contact['Name'];
$Phone = $contact['Phone'];
$email = $contact['email'];
echo("
CONTACT:
$first_Name $Name
" .
"$Phone
$email
PRODUCT:
$produc | ");
}
}
?>
| |
Printed at Ecosmartinc.com - |