';
#print_r($_SERVER);
#print_r($_POST);
#echo '';
#@_OUTLINE_PART_1_
#constants
$key1="bidp";
#$key2='ya1';
#$data_base="$key1";
#$table1='ya.a2proj';
#$table2='ya.a1file';
#$table3='ya.a1adds';
$include="all.php"; #change to test.php for easyphp
$connect="pear_connect"; #change to bidp_connect for easyphp
$filesubdir="/php/$key1/";
$thisfile=$_SERVER[PHP_SELF];
if ($_SERVER[SERVER_ADDR]!=$_SERVER[SERVER_NAME])
{$findserver=$_SERVER[SERVER_NAME]. ':' .$_SERVER[SERVER_PORT];}
else
{$findserver=$_SERVER[SERVER_ADDR]. ':' .$_SERVER[SERVER_PORT];}
if ($_SERVER[HTTPS]=='on')
{$thisserver = 'https://' .$findserver;}
else
{$thisserver = 'http://' .$findserver;}
#echo '
here ' .$thisserver; #ok
#$homefile="http://192.168.20.12/";
$homefile='';
#$thisfile='siteboard.php';
$headwords=strtoupper($key1)." site notice board text: ";
#import from userin or posted data
if ($_POST['start']=='')
{$start=1;}
else
{$start=$_POST['start'];}
#echo '
start==' .$start; #ok 8ja15
$boardsize=$_POST['boardsize'];
#$today=date("Y-m-d");
#$update='Updated '. date('jS F Y', filemtime($thisfile));
#constants
include $include;
require 'DB.php';
include 'fpdf.php';
include 'allhere.php';
#define start tag
#if start=1 this is first cycle (enter basic references); if start=2 second (work in main form), if 3 third (save new project data), if 4 fourth (view/print pdf)
if ($_POST["start"]==2) #in second pass, check data entered in first pass
{
if ($_POST["jobref"]>'') #existing reference
{
$jobref=$_POST["jobref"];
echo '
jobref=' .$jobref;
$start=2;
$year=$_POST['year'];
$mon=$_POST['month'];
if (strlen($mon)<2)
{$month= '0'. $mon;}
else
{$month=$mon;}
$dy=$_POST['day'];
if (strlen($dy)<2)
{$day= '0'. $dy;}
else
{$day=$dy;}
}
}
if ($_POST["start"]==5)
{$start=5;}
if ($_POST["start"]==7 || $_GET['start']==7) #set up data for fourth pass (pdf)
{
#if ($_POST['output']=='ispdf')
#{
$start=7; #display & print pdf
}
#import from userin or posted data
#$link=$connect ()
# or die ("Cannot link to server");
#$link->setFetchMode(DB_FETCHMODE_ASSOC);
#------------------------------------------
#solicit reference, certificate date and certificate number
if ($start==1)
{
$title = "$headwords create wording";
}
elseif ($start==2)
{
$title = "$headwords enter details";
}
#set up headings
#------------------------------------------
#==========================================
#enter project reference #8ja15
if ($start==1)
{
?>
$title";
echo $thisdate;
#selector list of files
#$query = "SELECT job_nmbr, coden FROM $table1 WHERE coden>'' AND left(job_nmbr,2)!='(A' ORDER BY job_nmbr";
#$result = mysql_query($query)
# or die("query failed - " . mysql_errno() . ": " . mysql_error());
#first pass form to indicate project reference
#$defaults=array('copytype'=>'isprj'); #default is unconditional
print "";
echo '
';
print("Home");
#print("
YA web page");
print $madehere;
}
#end of first pass to select project
#===============================================
#===============================================
#second pass main data entry for this form
if ($start==2)
{
?>
start=' .$start; #ok
echo '' .$title. '
';
#print "$title for $jobref
";
echo '' .$thisday;
# print $jobref.' check'; prints ok
#echo $tname .'here'; #ok when entry is in a2proj
$thisproject=$_POST['thisproject'];
#echo '
ref ' .$thisproject; #ok
#$these=$link->getRow("SELECT * FROM $table1 WHERE job_nmbr='$reference'");
#$thisproj=$link->getRow("SELECT descript, situated from $table2 WHERE jobnumber='$reference'");
echo '
';
print "";
# print $reference.' check'; #prints ok
#print "\n";
print("Home
");
#echo '
Call pdf function without writing new certificate: accept or edit certificate number and submit:
';
#echo '';
echo '
';
print $madehere;
print 'Created 18ap07';
}
#end part 2 main data entry for this form
#===============================================
#===============================================
#function write data to table for new certificate
#end write new project to table
#=============================================
#=============================================
#produce pdml pdf
if ($start==7)
{
#print_r($_POST); #ok
# print $jobref.'
#nb pdml=no png graphics
if ($_POST['reference']>'')
{$reference=$_POST['reference'];}
elseif ($_GET['reference']>'')
{$reference=$_GET['reference'];}
$boardname=$_POST['boardname'];
$boardsize=$_POST['boardsize'];
$arcname=$_POST['arcname'];
$arcadd=$_POST['arcadd'];
$arcdes='Architect';
$qsname=$_POST['qsname'];
$qsadd=$_POST['qsadd'];
$qsdes='Quantity surveyor';
$sename=$_POST['sename'];
$seadd=$_POST['seadd'];
$sedes='Structural engineer';
$eename=$_POST['eename'];
$eeadd=$_POST['eeadd'];
$eedes='Electrical engineer';
$mename=$_POST['mename'];
$meadd=$_POST['meadd'];
$medes='Mechanical engineer';
$cename=$_POST['cename'];
$ceadd=$_POST['ceadd'];
$cedes='Civil engineer';
$cowname=$_POST['cowname'];
$cowadd=$_POST['cowadd'];
$cowdes='Clerk of Works';
$conname=$_POST['conname'];
$conadd=$_POST['conadd'];
$condes='Contractor';
#echo $cert_no; #ok
#$condata=$link->getRow("SELECT * FROM $table3 WHERE lower(coden)='". strtolower($concode) ."'");
include 'pdml.php';
?>
';
#site board name
echo '';
echo '';
echo '';
echo $boardname;
echo '
';
#end site board name
#arc name
echo '';
echo '';
#echo '';
echo $arcname;
echo '
';
#end arc name
#qs board
echo '';
?>
|
'')
{$reference=$_POST['reference'];}
$boardname=$_POST['boardname'];
$boardsize=$_POST['boardsize'];
$empname=$_POST['empname'];
$arcname=$_POST['arcname'];
$arcadd=$_POST['arcadd'];
$arcdes='Architect';
$qsname=$_POST['qsname'];
$qsadd=$_POST['qsadd'];
$qsdes='Quantity surveyor';
$sename=$_POST['sename'];
$seadd=$_POST['seadd'];
$sedes='Structural engineer';
$eename=$_POST['eename'];
$eeadd=$_POST['eeadd'];
$eedes='Electrical engineer';
$mename=$_POST['mename'];
$meadd=$_POST['meadd'];
$medes='Mechanical engineer';
$cename=$_POST['cename'];
$ceadd=$_POST['ceadd'];
$cedes='Civil engineer';
$cowname=$_POST['cowname'];
$cowadd=$_POST['cowadd'];
$cowdes='Clerk of Works';
$conname=$_POST['conname'];
$conadd=$_POST['conadd'];
$condes='Contractor';
#$link=$connect ()
#or die ("Cannot link to server");
#$link->setFetchMode(DB_FETCHMODE_ASSOC);
if ($boardsize=='standard')
{
$xx=20;
$yy=47.5;
$yspace=32.5;
$yhigh=30;
$end=30;
$middle=120;
$topcelly=22;
$topcellx=33;
$topwide=112;
$texta=18; #description
$firmcellplus=7;
$fcellxplus=33;
$fcellwide=110;
$textb=16; #firm
$acellwide=154;
$dcellyplus=10;
$dcellxplus=154;
$dcellwide=22;
$dcellhigh=6;
$textc=11; #desgnation
}
elseif ($boardsize=='compact')
{
$xx=20;
$yy=42.5;
$yspace=27.5;
$yhigh=25;
$end=21;
$middle=78;
$topwide=70;
$topcelly=20;
$topcellx=25;
$texta=13;
$firmcellplus=4;
$fcellxplus=25;
$fcellwide=70;
$textb=13;
$acellwide=105;
$dcellyplus=7;
$dcellxplus=100;
$dcellwide=18;
$dcellhigh=5;
$textc=8;
}
$this->SetTopMargin(0);
$this->SetY(0);
$this->Rect($xx, 15, $end, $yhigh); #top board
$this->Rect($xx+$end, 15, $middle, $yhigh);
$this->Rect($xx+$end+$middle, 15, $end, $yhigh);
$this->SetXY($xx+$topcellx,$topcelly);
$this->SetFont('Arial','',$texta);
$this->Multicell($topwide,8,$boardname,0,'R'); #$boardname
if ($empname>'')
{
$this->SetXY($xx+$topcellx,$topcelly+8); #
$this->SetFont('Arial','',$textb);
$this->Multicell($topwide,8,$empname,0,'R');
}
if ($arcname>'')
{
$this->Rect($xx, $yy, $end, $yhigh); #arc board
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$arcname,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$arcadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,10,$arcdes,0,'C');
$yy=$yy+$yspace;
}
if ($qsname>'')
{
$this->Rect($xx, $yy, $end, $yhigh);
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$qsname,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$qsadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,$dcellhigh,$qsdes,0,'C');
$yy=$yy+$yspace;
}
if ($sename>'')
{
$this->Rect($xx, $yy, $end, $yhigh);
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$sename,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$seadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,$dcellhigh,$sedes,0,'C');
$yy=$yy+$yspace;
}
if ($eename>'')
{
$this->Rect($xx, $yy, $end, $yhigh);
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$eename,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$eeadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,$dcellhigh,$eedes,0,'C');
$yy=$yy+$yspace;
}
if ($mename>'') #mechanical engineer
{
$this->Rect($xx, $yy, $end, $yhigh);
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$mename,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$meadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,$dcellhigh,$medes,0,'C');
$yy=$yy+$yspace;
}
if ($cename>'') #civil engineer
{
$this->Rect($xx, $yy, $end, $yhigh);
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$cename,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$ceadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,$dcellhigh,$cedes,0,'C');
$yy=$yy+$yspace;
}
if ($cowname>'') #clerk of works
{
$this->Rect($xx, $yy, $end, $yhigh);
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$cowname,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$cowadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,$dcellhigh,$cowdes,0,'C');
$yy=$yy+$yspace;
}
if ($conname>'')
{
$this->Rect($xx, $yy, $end, $yhigh); #contractor
$this->Rect($xx+$end, $yy, $middle, $yhigh);
$this->Rect($xx+$end+$middle, $yy, $end, $yhigh);
$this->SetXY($xx+$fcellxplus,$yy+$firmcellplus);
$this->SetFont('Arial','',$textb);
$this->Multicell($fcellwide,10,$conname,0,'R');
$this->SetFont('Arial','',$textc);
$this->Ln(0);
$this->Multicell($acellwide,5,$conadd,0,'R');
$this->SetXY($xx+$dcellxplus,$yy+$dcellyplus);
$this->Multicell($dcellwide,10,$condes,0,'C');
}
$this->Ln(10);
$this->SetFont('Arial','',10);
$this->Cell(10,15,"",0,0);
$this->Cell(100,15,"BIDP site notice board, Scale 1:10; Board size $boardsize",0,1);
}
} #end of fpdf extends
$pdf=new PDF('P','mm','A4'); #items starting with $pdf represent use of the class
$pdf->AliasNbPages();
$pdf->AddPage(); #creates the page dy
$pdf->SetFont('Arial','',11);
$pdf->display_list();
#$pdf->Cell(40,10,'Hello World!');
$pdf->Output();
}
#end start=5
#==============================================
#end
?>