[!][/!] [formvariables] [name] [hideif [name]^"thefile"][hideif [name]^"logoV"][value][/hideif][/hideif]
[/formvariables] [!][/!] [math show=F]fnameIndex=1[/math] [math show=F]lnameIndex=1[/math] [math show=F]adminCompleteIndex=1[/math] [math show=F]skuIndex=1[/math] [math show=F]myDescIndex=1[/math] [math show=F]jobtitleIndex=1[/math] [math show=F]activestatusIndex=1[/math] [formvariables] [showif [name]^"adminComplete"] [hideif [adminCompleteIndex]>1] Value of adminComplete: [text show=t]adminCompleteV=[value][/text]
[/hideif] [math show=F]adminCompleteIndex=[adminCompleteIndex]+1[/math] [/showif] [showif [name]^"fname"] [hideif [fnameIndex]>1] Value of fname: [text show=t]fnameV=[value][/text]
[/hideif] [math show=F]fnameIndex=[fnameIndex]+1[/math] [/showif] [showif [name]^"lname"] [hideif [lnameIndex]>1] Value of lname: [text show=t]lnameV=[value][/text]
[/hideif] [math show=F]lnameIndex=[lnameIndex]+1[/math] [/showif] [showif [name]^"sku"] [hideif [skuIndex]>1] Value of sku: [text show=t]skuV=[value][/text]
[/hideif] [math show=F]skuIndex=[skuIndex]+1[/math] [/showif] [showif [name]^"myDesc"] [hideif [myDescIndex]>1] Value of Desc: [text show=t]myDescV=[value][/text]
[/hideif] [math show=F]myDescIndex=[myDescIndex]+1[/math] [/showif] [showif [name]^"jobtitle"] [hideif [jobtitleIndex]>1] Value of jobtitle: [text show=t]jobtitleV=[value][/text]
[/hideif] [math show=F]jobtitleIndex=[jobtitleIndex]+1[/math] [/showif] [showif [name]^"activestatus"] [hideif [activestatusIndex]>1] Value of activestatus: [text show=t]activestatueV=[value][/text]
[/hideif] [math show=F]activestatusIndex=[activestatusIndex]+1[/math] [/showif] [/formvariables] [!][/!] -->[/!] [showif [browsername]^mac][text]thename=[formvariables][showif [name]^thefile][middle startafter=filename="&endbefore="][name][/middle][/showif][/formvariables][/text][/showif] [math show=F]thename0index=1[/math] [hideif [browsername]^mac] [text]thename0=[formvariables][showif [name]^thefile][hideif [thename0Index]>1][middle startafter=filename="&endbefore="][name][/middle][/hideif][math show=F]thename0Index=[thename0Index]+1[/math][/showif][/formvariables][/text] [text]wordcount=[countwords delimiters=\][thename0][/countwords][/text] [text]thename=[listwords words=[thename0]&delimiters=\][showif [index]=[wordcount]][word][/showif][/listwords][/text] [/hideif] [hideif [thename]=] [hideif [FileInfo file=../img/uploads/[thename]][exists][/FileInfo]=T] [formvariables] [showif [url][name][/url]^[url]"theFile"[/url]] [writefile file=../img/uploads/[thename]&secure=F][value][/writefile] [/showif] [/formvariables] [/hideif] [/hideif]
E M P L O Y E E    A D M I N [!][/!] [SETMIMEHEADER name=Pragma&value=no-cache] [SETMIMEHEADER name=Expires&value=0] [SETMIMEHEADER name=Cache-Control&value=max-age=0] [!][/!] [!][/!] [text]myadminname=employee admin[/text] [text]mydbpath=../dbs/[/text] [text]mydbname=employees.db[/text] [!][/!] [text]tblWidth=500[/text] [!][/!] [text]sText=[/text] [text]ENDsText=[/text] [!][/!] [hideif [adminDo]=Add] [hideif [adminDo]=Edit] [hideif [adminDo]=Delete] [hideif [adminDo]=DeleteImage] [search db=[mydbpath][mydbname]&geskudatarq=0&skusumm=T&lnamesort=1&fnamesort=2]

Records [founditems] [lname], [fname] [showif [activestatus]=Y]*[/showif] [/founditems] [hideif [numfound]=0] [/hideif] A* indicates record live

Image Names [math show=f]myImageIndex=1[/math] [ListFiles path=../img/uploads/] [hideif [IsFolder]=T] [filename] [math show=f]myImageIndex=[myImageIndex]+1[/math] [/hideif] [/ListFiles] Images in employees folder

[showif [numfound]=0] No records are in the [myadminname] database. [/showif] [showif [adminComplete]=iiiAdd] [showif [pt]=2] [sText]You just added [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=lname], [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=fname] to the database.[ENDsText] [/showif] [hideif [pt]=2] [hideif [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=sku]=[sku]] [append db=[mydbpath][mydbname]][formvariables][if ("[name]"="mydesc")][then][name]=[url][url][value][/url][/url][/then][else][name]=[value][/else][/if]&[/formvariables][/append] [commitdatabase path=[mydbpath][mydbname]] [redirect [thisurl]?adminComplete=iiiAdd&pt=2&sku=[sku]] [/hideif] [/hideif] [/showif] [!][/!] [showif [adminComplete]=iiiEdt] [showif [pt]=2] [sText]You just edited [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=lname], [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=fname].[ENDsText][/showif] [hideif [pt]=2] [replace db=[mydbpath][mydbname]&eqskudatarq=[sku]][formvariables][if ("[name]"="mydesc")][then][name]=[url][url][value][/url][/url][/then][else][name]=[value][/else][/if]&[/formvariables][/replace][commitdatabase path=[mydbpath][mydbname]] [redirect [thisurl]?adminComplete=iiiEdt&pt=2&sku=[sku]] [/hideif] [/showif] [showif [adminComplete]=iiiDlt] [showif [pt]=2] [sText]You just deleted [nameVar][ENDsText][/showif] [hideif [pt]=2] [text]nameVar=[Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=lname], [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=fname][/text] [delete db=[mydbpath][mydbname]&eqskudatarq=[sku]][commitdatabase path=[mydbpath][mydbname]] [redirect [thisurl]?adminComplete=iiiDlt&pt=2&nameVar=[url][nameVar][/url]] [/hideif] [/showif] [showif [adminComplete]=iiiDltImage] [showif [pt]=2] [sText]You just deleted [mypicImage][ENDsText][/showif] [hideif [pt]=2] [DELETEFILE file=../img/uploads/[mypicImage]] [redirect [thisurl]?adminComplete=iiiDltImage&pt=2&mypicImage=[url][mypicImage][/url]] [/hideif] [/showif]

[/search] [hideif [thename]=] [showif [FileInfo file=../img/uploads/[thename]][exists][/FileInfo]=T]

[sText]The image file [thename], is uploaded.[ENDsText]

[/showif] [hideif [FileInfo file=../img/uploads/[thename]][exists][/FileInfo]=T]

[sText]The image file [thename], is uploaded.[ENDsText]

[/hideif] [/hideif]

[sText]Image: [ENDsText]

[/hideif] [/hideif] [/hideif] [/hideif] [!][/!] [!][/!] [showif [adminDo]=Add]

[sText] First Name: [ENDsText]
[sText] Last Name: [ENDsText]
[sText]Job Title: [ENDsText]
[sText]Status: [ENDsText]	Active Not active
[sText]Picture Name: [ENDsText]	Select [ListFiles path=../img/uploads] [hideif [IsFolder]=T] [filename] [/hideif] [/ListFiles]
[sText]Description: [ENDsText]

[/showif] [!][/!] [showif [adminDo]=Edit] [search db=[mydbpath][mydbname]&eqskudatarq=[sku]&skusumm=T] [founditems] [text]currentSku=[sku][/text]

[sText]First Name: [ENDsText]
[sText]Last Name: [ENDsText]
[sText]Job Title: [ENDsText]
[sText]Status: [ENDsText]	Active Not active
[sText]Picture Name: [ENDsText]	[showif [mypic]=] No image [ListFiles path=../img/uploads] [hideif [IsFolder]=T] [filename] [/hideif] [/ListFiles] [/showif] [hideif [mypic]=] No image [ListFiles path=../img/uploads] [hideif [IsFolder]=T] [filename] [/hideif] [/ListFiles] [/hideif]
[sText]Description: [ENDsText]	[unurl][mydesc][/unurl]

[/founditems] [/search] [/showif] [!][/!] [showif [adminDo]=Delete]

[sText]Are you sure you want to delete [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=lname], [Lookup db=[mydbpath][mydbname]&value=[sku]&lookInField=sku&returnField=fname]?[ENDsText]

[/showif] [showif [adminDo]=DeleteImage]

[sText]Are you sure you want to delete [mypicImage]?[ENDsText]

[/showif] [!][/!] [include ^pagecounter.tpl]