|
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 = 'black';
$mage = "
";
}else{
$color = 'black';
$mage = "
";
}
$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("
$mage $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: ID:$CID" .
"
$first_Name $Name
" .
"$Phone
$emailPRODUCT:
$produc | ");
}
}
mysql_select_db('ecosmar_friendly', $dbcnx);
$listem = @mysql_query("SELECT ID,Project_Name,usrn,CID,product,action,note,status,due,dtnum FROM task WHERE usrn='$usrn' AND status='Open' ORDER BY dtnum DESC");
if (!$listem) {
echo("Problem retrieving Open Projects.
Error: ". mysql_error());
}
$num_rows = count($listem);
if($num_rows < 1){
echo("
");
}else{
while($row = mysql_fetch_array($listem)){
$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 = 'black';
$mage = " ";
}else{
$color = 'black';
$mage = " ";
}
$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("
$mage $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("
PRODUCT:
$produc" .
"
CONTACT:
$first_Name $Name
" .
"$Phone
$email
EVENTS:");
}
}
mysql_select_db('ecosmar_friendly', $dbcnx);
$dates = @mysql_query("SELECT ID,PID,CONID,title,time,min,dtnum,usrn FROM dates WHERE CONID='$CID' AND usrn='$usrn' ORDER BY dtnum");
if (!$dates) {
echo("
Problem retrieving Events.
Error: ". mysql_error());
}else{
$drows = mysql_num_rows($dates);
if($drows < 1){
echo("
No Events Set for this Contact");
}else{
while($rowd = mysql_fetch_array($dates)){
$DID = $rowd['ID'];
$PID = $rowd['PID'];
$CONID = $rowd['CONID'];
$title = $rowd['title'];
$tid = $rowd['time'];
if($tid == '1'){
$time = '6';
$oday = 'AM';
}elseif($tid == '2'){
$time = '7';
$oday = 'AM';
}elseif($tid == '3'){
$time = '8';
$oday = 'AM';
}elseif($tid == '4'){
$time = '9';
$oday = 'AM';
}elseif($tid == '5'){
$time = '10';
$oday = 'AM';
}elseif($tid == '6'){
$time = '11';
$oday = 'AM';
}elseif($tid == '7'){
$time = '12';
$oday = 'AM';
}elseif($tid == '8'){
$time = '1';
$oday = 'PM';
}elseif($tid == '9'){
$time = '2';
$oday = 'PM';
}elseif($tid == '10'){
$time = '3';
$oday = 'PM';
}elseif($tid == '11'){
$time = '4';
$oday = 'PM';
}elseif($tid == '12'){
$time = '5';
$oday = 'PM';
}elseif($tid == '13'){
$time = '6';
$oday = 'PM';
}elseif($tid == '14'){
$time = '7';
$oday = 'PM';
}elseif($tid == '15'){
$time = '8';
$oday = 'PM';
}elseif($tid == '16'){
$time = '9';
$oday = 'PM';
}
$min = $rowd['min'];
$dtnum = $rowd['dtnum'];
$chunk_dtnum = chunk_split($dtnum, 2, ':');
$chunk_arr = explode(":", $chunk_dtnum);
$datus = $chunk_arr[2].'/'.$chunk_arr[3].'/'.$chunk_arr[0].$chunk_arr[1];
$datcheck = date(Ymd) + 0;
if($dtnum < $datcheck){
echo("");
}else{
echo("
--$datus $time:$min $oday" .
"
$title");
}
}
}
echo(" | | |
");
}
?>