<cfif parameterexists(url.doneid)>
	<cfquery name="upds" dataSource="cityguide">
		update adopstrackingcampaign
		set laststatus ='Done'
		where id = #url.doneid#
	</cfquery>
</cfif>	


<cfquery name="seocheck" datasource="cityguide">
	select clientname,campaignname,id from adopstrackingclient
	where campseo is null
</cfquery>

<cfoutput query="seocheck">
	
<Cfset moveurl2 = '#clientname#-#campaignname#-#id#'>
<cfset moveurl2 = reReplace(moveurl2, "([^[:alnum:]|[:blank:]]) ", "", "all")>
<cfset moveurl2 = #reReplaceNoCase(moveurl2, "[^a-z0-9]", "-", "all")#>
<Cfset moveurl2 = rereplacenocase(moveurl2," ","-","ALL")>
<cfset moveurl2 = rereplace(moveurl2,"'","-","ALL")>
<cfset xxx = len(moveurl2)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl2,1)# eq '-' and xxx2 gt 0>
<cfset moveurl2 = '#right(moveurl2,xxx2)#'>
</cfif>
<cfset xxx = len(moveurl2)>
<cfset xxx2 = xxx -1>
<Cfif #left(moveurl2,1)# eq '-' and xxx2 gt 0>
<cfset moveurl2 = '#right(moveurl2,xxx2)#-1029'>
</cfif>

	
	<cfquery name="ps" dataSource="cityguide">
		update adopstrackingclient
		set campseo = '#moveurl2#'
		where id = #id#
	</cfquery>
	
</cfoutput>


<Cfinclude template="header.cfm">
		<link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.10/css/select2.min.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.10/js/select2.min.js"></script>



<cfset seven = dateadd('d',-7,now())>
<div id="content"  style="margin-left:250px;">
  <div id="content-header">
    <h2 style="margin-bottom: 0px;">&nbsp;Manage Ad Ops <cfif parameterexists(url.new)> - <font color="red">NEW ORDER</font></cfif></h2>
    &nbsp;
<script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.11.0/umd/popper.min.js" integrity="sha384-b/U6ypiBEHpOf/4+1nzFpr53nxSS+GLCkfwBdFNTxtclqqenISfwAzpKaMNFNmj4" crossorigin="anonymous"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta/js/bootstrap.min.js" integrity="sha384-h0AbiXch4ZDo7tp9hKZ4TsHbi047NrKGLO3SEJAg45jXxnGIfYzk4Si90RDIqNm1" crossorigin="anonymous"></script>

                                                     <!-- Example single danger button -->
                                                    <div class="btn-group">
                                                      <button type="button" class="btn btn-danger dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                        Filter
                                                      </button>
                                                      <div class="dropdown-menu" style="padding:4px;">
                                                        <a class="dropdown-item" href="adslist.cfm">Current IOs</a>
                                                        	<Br>
						<a class="dropdown-item" href="adslist.cfm?viewclosed=on">Past IOs</a>	<Br>
						<a class="dropdown-item" href="adslist.cfm?viewpending=on">Materials Pending</a>	<Br>
						<a class="dropdown-item" href="adslist.cfm?screenshots=on">Needs Screenshots</a>	<Br>
						<a class="dropdown-item" href="adslist.cfm?reportsneeded=on">Needs Reports</a>	<Br>


                                      	<a class="dropdown-item" href="#">             <FORM action="adslist.cfm" method="post"  enctype="multipart/form-data">
<input name="searcherads" placeholder="search" style="width:150px;">

<input type="submit" Value="Go" class="btn btn-success" style="font: bold 18px;color:white" name="buttarticleman" id="cdh_update_article">

</form>   </a>
                                                      </div>
                                                    </div>

 
 <Cfif not parameterexists(url.editclient)> 
                                       <a href="adslist.cfm?addclient=on"> <button type="button" class="btn btn-outline-secondary">Add New IO <i class="fa fa-check"></i></button></a>


                                       <a href="adslist-calendar.cfm"> <button type="button" class="btn btn-outline-secondary">View Calendar <i class="fa fa-calendar"></i></button></a>
                                       
                                              <a href="adslistypes.cfm"> <button type="button" class="btn btn-outline-secondary">Manage Types </button></a>
                                              </Cfif>

  
    <br><br>



  </div>

<cfif parameterexists(url.duplicateclient)>
<cfquery name="del" dataSource="cityguide">
insert into adopstrackingclient( clientname,campaignname,accountrep,startdate,enddate,iodate,iostatus,io,notes,clientemail,billingdollars,billingstatus,billingemail,billingnotes,billingdate,billingnumber,billinguuid,billingduedate,pendingcount,screenshottext,screenshotneeded,lastreportdate,reportembed,clientcontact,ioid,iodollars,ionotes,costin,prepayreq,campseo,adopsemail
 ) select clientname,campaignname,accountrep,startdate,enddate,iodate,iostatus,io,notes,clientemail,billingdollars,billingstatus,billingemail,billingnotes,billingdate,billingnumber,billinguuid,billingduedate,pendingcount,screenshottext,screenshotneeded,lastreportdate,reportembed,clientcontact,ioid,iodollars,ionotes,costin,prepayreq,campseo,adopsemail
 from adopstrackingclient where id=#url.duplicateclient#;
</cfquery>

<cfquery name="getid" datasource="cityguide">
	select id,campseo from adopstrackingclient order by id desc 
	limit 0,1
</cfquery>

<Cfquery name="udps" datasource="cityguide">
	update adopstrackingclient set ioid = ioid + 1, billingnumber = billingnumber + 1,
	campseo = '#getid.campseo#-#getid.id#'
	where id = #getid.id#
</Cfquery>

<Cfquery name="getlineitems" dataSource="cityguide">
	select * from adopstrackingcampaign 
	where clientid = #url.duplicateclient#
</Cfquery>

<cfoutput query="Getlineitems">
	
			<cfquery name=addphoto datasource="cityguide">
INSERT INTO adopstrackingcampaign(
clientid,
typer,
startdate,
enddate,
segmentname,
notes,
gotarticle,
laststatus,
lastupdate,
quantity,
cpm,
linecost

)
		VALUES(
#getid.id#,'#getlineitems.typer#',#getlineitems.startdate#,#getlineitems.enddate#,'#getlineitems.segmentname#','#getlineitems.notes#',#getlineitems.gotarticle#,'',#getlineitems.lastupdate#,#getlineitems.quantity#,#getlineitems.cpm#,#getlineitems.linecost#)
		</cfquery>
</cfoutput>



</cfif>



<cfif parameterexists(url.duplicateorder)>
<cfquery name="del" dataSource="cityguide">
insert into adopstrackingclient( accountrep,io,notes,billingdollars,billingstatus,billingemail,billingnotes,billingdate,billingnumber,billinguuid,billingduedate,pendingcount,screenshottext,screenshotneeded,lastreportdate,reportembed,ioid,iodollars,ionotes,costin,prepayreq,campseo
 ) select accountrep,io,notes,billingdollars,billingstatus,billingemail,billingnotes,billingdate,billingnumber,billinguuid,billingduedate,pendingcount,screenshottext,screenshotneeded,lastreportdate,reportembed,ioid,iodollars,ionotes,costin,prepayreq,campseo
 from adopstrackingclient where id=#url.duplicateorder#;
</cfquery>

<cfquery name="getid" datasource="cityguide">
	select id,campseo from adopstrackingclient order by id desc 
	limit 0,1
</cfquery>

<Cfquery name="udps" datasource="cityguide">
	update adopstrackingclient set ioid = #utime#, billingnumber = #utime#,
	campseo = '#getid.campseo#-#getid.id#',iostatus = 2
	where id = #getid.id#
</Cfquery>

<Cfquery name="getlineitems" dataSource="cityguide">
	select * from adopstrackingcampaign 
	where clientid = #url.duplicateorder#
</Cfquery>

<cfoutput query="Getlineitems">
	
			<cfquery name=addphoto datasource="cityguide">
INSERT INTO adopstrackingcampaign(
clientid,
typer,
startdate,
enddate,
segmentname,
notes,
gotarticle,
laststatus,
lastupdate,
quantity,
cpm,
linecost

)
		VALUES(
#getid.id#,'#getlineitems.typer#',#getlineitems.startdate#,#getlineitems.enddate#,'#getlineitems.segmentname#','#getlineitems.notes#',#getlineitems.gotarticle#,'',#getlineitems.lastupdate#,#getlineitems.quantity#,#getlineitems.cpm#,#getlineitems.linecost#)
		</cfquery>
</cfoutput>

<cflocation addtoken="no" url="https://admin.nymetroparents.com/adslist.cfm?editclient=#getid.id#&new=on">

</cfif>


<cfif parameterexists(url.deleteclient)>
<cfquery name="del" dataSource="cityguide">
	delete from adopstrackingclient where id = #url.deleteclient#
</cfquery>
</cfif>



<cfif parameterexists(url.addclient)>
	
			<cfquery name=addphoto datasource="cityguide">
INSERT INTO adopstrackingclient(
clientname,campaignname,accountrep,startdate,enddate,iodate,lastreportdate,ioid,iostatus)
		VALUES(
'',
'',
'',
#currentdatetime#,
#currentdatetime#,
#currentdatetime#,
#currentdatetime#
,#utime#,2
		)
		</cfquery>


	<cfquery name="getlast" dataSource="cityguide">
		select id from adopstrackingclient
		order by id desc
		limit 0,1
	</cfquery>
	<cflocation addToken="no" url="adslist.cfm?editclient=#getlast.id#">

</cfif>



<cfif parameterexists(url.editsaveclient)>

<cfquery name="upds" dataSource="cityguide">
	update adopstrackingclient
	set
clientname = '#form.clientname#',
clientemail = '#form.clientemail#',
clientcontact = '#trim(form.clientcontact)#',

notes = '#form.notes#',
adopsemail = '#form.adopsemail#', 
campaignname = '#form.campaignname#',
accountrep = '#form.accountrep#',
iostatus = #form.iostatus#,
iodate = '#form.iodate#',
startdate = '#form.startdate#',
enddate = '#form.enddate#',
<!---
reportembed = '#form.reportembed#',--->
lastreportdate = '#form.lastreportdate#'
	where id = #url.editsaveclient#
</cfquery>


<cfif parameterexists(form.report)and #form.report# is not ''>
  <cffile action="upload"
	      nameconflict="makeunique"
			  filefield="report"

			  destination="/home/bway/public_html/bway/admin2013/ios/" mode="644">
	<cfset photo = "#File.ServerFile#">   
	
	<cfquery name="upds" dataSource="cityguide">
	update adopstrackingclient
	set
reportembed = 'https://admin.nymetroparents.com/ios/#photo#',
lastreportdate = #currentdatetime#

	where id = #url.editsaveclient#
</cfquery>
	
	</cfif>


<cfif parameterexists(form.photo)and #form.photo# is not ''>
  <cffile action="upload"
	      nameconflict="makeunique"
			  filefield="photo"

			  destination="/home/bway/public_html/bway/admin2013/ios/" mode="644">
	<cfset photo = "#File.ServerFile#">   
	
	<cfquery name="upds" dataSource="cityguide">
	update adopstrackingclient
	set
io = '#photo#'
	where id = #url.editsaveclient#
</cfquery>
	
	</cfif>
<cfif ParameterExists(form.buttarticleman)>
<cflocation url="/adslist.cfm?editclient=#url.editsaveclient#" addToken="no">
<Cfelse>
	<cflocation url="/adslist.cfm" addtoken="no">
</cfif>
</cfif>



<cfquery name="gettodaya" datasource="cityguide" >
select * from adopstrackingclient
where 1 =1 
and clientname <> ''

<cfif parameterexists(form.searcherads)>
	and (clientname like '%#form.searcherads#%' or campaignname like '%#form.searcherads#%')

<cfelse>

<Cfif parameterexists(url.rep)>
and accountrep = '#url.rep#'
</cfif>

<cfif parameterexists(url.viewunpaid)>
and iostatus = 1
</cfif>

<cfif parameterexists(url.viewunsigned)>
and iostatus = 2
</cfif>

<cfif parameterexists(url.viewpending) or parameterexists(form.searcherads)>
and pendingcount > 0
</cfif>
<cfif parameterexists(url.screenshots)>
and screenshotneeded = 1
</cfif>
<cfif parameterexists(url.reportsneeded)>
	
			<Cfset newdate7 = dateadd('d',-7,currentdatetime)>
	<Cfset newdate7 = #dateformat(newdate7,'yyyy-mm-dd')#>


and lastreportdate < '#newdate7#'
and iostatus = 0 
<cfif parameterexists(url.viewunpaid) or parameterexists(url.viewpending) or parameterexists(includeold)>
<cfelse>
and startdate < '#dateformat(currentdatetime,'yyyy-mm-dd')#'
	</cfif>
	
</cfif>	





<cfif parameterexists(url.viewclosed)>
and (enddate < '#dateformat(currentdatetime,'yyyy-mm-dd')#')
<cfelse>
and (enddate >= '#dateformat(currentdatetime,'yyyy-mm-dd')#')

</cfif>

</cfif>	

<Cfif parameterexists(url.sortby)>
	order by #url.sortby# <cfif url.sortby eq 'lastupdate'>desc</cfif>
	<cfelse>
order by enddate </Cfif>
</cfquery>


<Cfif parameterexists(url.editclient)>

	&nbsp;
	
	<Cfoutput>
	
	
	<a href="adslist.cfm?deleteclient=<cfoutput>#url.editclient#</cfoutput>" onclick="return confirm('Are you sure?')" style="background-color:black;color:white;padding:8px;">Delete Order</a>


	
	<a href="adslist.cfm?duplicateclient=<cfoutput>#url.editclient#</cfoutput>" onclick="return confirm('This will copy the entire IO')" style="background-color:##1b047c;color:white;padding:8px;">Dupe IO </a>
	&nbsp;
		<a href="adslist.cfm?duplicateorder=<cfoutput>#url.editclient#</cfoutput>" onclick="return confirm('This will copy just the order')" style="background-color:##1b047c;color:white;padding:8px;">Dupe Order </a>

<Cfif #getuser.id# eq 216>

		&nbsp;
<a href="adslistinvoice.cfm?id=<cfoutput>#url.editclient#</cfoutput>" style="background-color:green;color:white;padding:8px;">Send Invoice</a>
	
</Cfif>

	<Cfquery name="geter" dataSource="cityguide">
		select * from adopstrackingclient
		where id = #url.editclient#
	</cfquery>

	<Cfquery name="getccount" dataSource="cityguide">
		select * from adopstrackingcampaign
		where clientid = #url.editclient# and laststatus <> 'Done'
	</cfquery>
	
<a href="adslistscreenshots.cfm?id=<cfoutput>#url.editclient#</cfoutput>" style="background-color:white;color:black;padding:8px;border-width:1px;border-style:solid;">Screenshots <i class="fa fa-photo"></i>




	<Cfset newdate7 = dateadd('d',-7,currentdatetime)>
	<Cfset newdate7 = #dateformat(newdate7,'yyyy-mm-dd')#>




<cfif #geter.screenshotneeded# eq 1>


 <i class="fa fa-exclamation-triangle" style="color:##b20223;"></i></cfif>
</a>

&nbsp;<a href="https://admin.nymetroparents.com/materials/?id=<cfoutput>#url.editclient#&link=#geter.campseo#</cfoutput>" style="background-color:white;color:black;padding:8px;border-width:1px;border-style:solid;">Materials Needed <cfif #getccount.recordcount# gt 0>
<i class="fa fa-exclamation-triangle" style="color:##b20223;"></i></cfif></a>

<br><br>
</cfoutput>
<FORM action="adslist.cfm?editsaveclient=<cfoutput>#url.editclient#</cfoutput>" method="post"  enctype="multipart/form-data">



<Table><Tr><Td style="width: 50%;vertical-align: top;">
<div class="form-group">


<label class="col-md-12" style="margin-top: 10px;">Client Name </label>

<div class="col-md-12">

<Cfif #geter.clientname# eq ''>
	
	  <link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
  <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
  
  <cfquery name="gettopshows" datasource="cityguide">
  	select clientname from adopstrackingclient
  	where clientname <> ''
  	group by clientname
  	order by clientname
  </cfquery>
  
  <script>
  $( function() {
    var availableTags = [
     <cfoutput query='gettopshows'>"#clientname#"<cfif #currentrow# is not recordcount>,</cfif></cfoutput>

    ];
    $( ".tags" ).autocomplete({
      source: availableTags
 
 
    });
  } );
  </script>
  <input name="clientname" required type="text" class="tags" style="
    height: calc(2.25rem + 2px);
    padding: .375rem .75rem;
    font-size: 1rem;
    font-weight: 400;
    line-height: 1.5;
    color: #495057;
    width:600px;
    background-color: #fff;
    background-clip: padding-box;
    border: 1px solid #ced4da;
    border-radius: .25rem;
    transition: border-color .15s ease-in-out,box-shadow .15s ease-in-out;
">

	
	<cfelse>
	

<input name="clientname" required type="text" class="form-control" style="  width:600px;" value="<Cfoutput>#geter.clientname#</Cfoutput>">
</Cfif>

</div>


<label class="col-md-12" style="margin-top: 10px;">Campaign Name</label>
<div class="col-md-12">
	<cfset campname = rereplace(geter.campaignname,'"','','all')>
<input  name="campaignname" required type="text"  style="  width:600px;"  class="form-control" value="<Cfoutput>#campname#</Cfoutput>">
</div>


<label class="col-md-12" style="margin-top: 10px;">Client Email(s) <small>(comma delimited if multiple)</small></label>
<div class="col-md-12">
<input  name="clientemail" type="text"  style="  width:600px;" class="form-control" value="<Cfoutput>#geter.clientemail#</Cfoutput>">
</div>

<label class="col-md-12" style="margin-top: 10px;">Client Address</label>
<div class="col-md-12">
<textarea name="clientcontact" style="width:90%;height:70px;font-size:10pt;"><cfoutput>#geter.clientcontact#</cfoutput></textarea>
</div>


<table><tr>
	<Td>
		<label class="col-md-12" style="margin-top: 10px;">Rep</label>
<div class="col-md-12">
	<Select name="accountrep"  class="js-example-basic-single" style="width:100px">
		<cfif #geter.accountrep# eq ''>
			<option value="[email protected]">[email protected]</option>
		</cfif>
		<option value="<Cfoutput>#geter.accountrep#</cfoutput>"><cfoutput>#rereplace(geter.accountrep,'@broadwayworld.com','')#</cfoutput></option>
		<cfquery name="getsales" dataSource="cityguide">
			select email,first,last from davlersales 
			order by last, first
		</cfquery>
		
		<Cfoutput query="getsales">
		<option value="#email#">#first# #last#</option>
</Cfoutput>
	</Select>
</div>

	</Td>
	<td>
<label class="col-md-12" style="margin-top: 10px;">IO Status</label>
<div class="col-md-12">

	<Select name="iostatus">
<cfif #geter.iostatus# eq 1><option value="1">Awaiting Payment</option><option value="2">Needs Signature</option><Cfif #getuser.id# gte 26><option value="0">Approved</option></Cfif>

<cfelseif #geter.iostatus# eq 2><option value="2">Needs Signature</option><option value="1">Awaiting Payment</option><Cfif #getuser.id# gte 26><option value="0">Approved</option></Cfif>

<cfelseif #geter.iostatus# eq 0><option value="0">Approved</option><option value="2">Needs Signature</option><option value="1">Awaiting Payment</option>

<cfelse>
<option value="2">Needs Signature</option>
<Cfif #getuser.id# eq gte><option value="0">Approved</option></Cfif>
<option value="1">Awaiting Payment</option>
</cfif>
	</Select>
</div>

</td>

<td>
	
	<label class="col-md-12" style="margin-top: 10px;">Ad Ops Email</label>

	<input  name="adopsemail" type="text"  style="width:220px;" class="form-control" value="<Cfoutput>#geter.adopsemail#</Cfoutput>">

	

	
	
</td>

	<script language="javascript" type="text/javascript">

function popitup(url) {
newwindow=window.open(url,'name','height=500,width=600');
if (window.focus) {newwindow.focus()}
return false;
}


</script>

</tr></table>

<table>
<tr>



<link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.0/themes/smoothness/jquery-ui.css">
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.0/jquery-ui.min.js"></script>

 <script>
  $(function() {
    $( "#datepicker" ).datepicker({ dateFormat: 'yy-mm-dd' });
  });

  $(function() {
    $( "#datepicker2" ).datepicker({ dateFormat: 'yy-mm-dd' });
  });


  $(function() {
    $( "#datepicker3" ).datepicker({ dateFormat: 'yy-mm-dd' });
  });

  $(function() {
    $( "#datepicker4" ).datepicker({ dateFormat: 'yy-mm-dd' });
  });

  </script>

<td style="width: 125px;padding:4px;">

<label class="col-md-12" style="margin-top: 10px;">IO Date</label>


<input id="datepicker" name="iodate" value="<cfoutput>#dateformat(geter.iodate,'yyyy-mm-dd')#</cfoutput>" type="text" class="form-control mydatepicker" data-date-format="yyyy-mm-dd" placeholder="Due On">

</td>

<td style="width: 125px;padding:4px;">
<label class="col-md-12" style="margin-top: 10px;">Start Date</label>


<input id="datepicker2" name="startdate" value="<cfoutput>#dateformat(geter.startdate,'yyyy-mm-dd')#</cfoutput>" type="text" class="form-control mydatepicker" data-date-format="yyyy-mm-dd" placeholder="Due On">

</td>


<td style="width: 125px;padding:4px;">
<label class="col-md-12" style="margin-top: 10px;">End Date</label>
<input id="datepicker3" name="enddate" value="<cfoutput>#dateformat(geter.enddate,'yyyy-mm-dd')#</cfoutput>" type="text" class="form-control mydatepicker" data-date-format="yyyy-mm-dd" placeholder="Due On">


</td>

<td style="width: 125px;padding:4px;">
<label class="col-md-12" style="margin-top: 10px;">Report 

<Cfif 	(#geter.lastreportdate# lt #newdate7#
	
	and geter.iostatus eq 0 
and geter.startdate lt '#dateformat(currentdatetime,'yyyy-mm-dd')#'

	
	)> <i class="fa fa-exclamation-triangle" style="color:#b20223;"></i></cfif>
</label>
<input id="datepicker4" name="lastreportdate" value="<cfoutput>#dateformat(geter.lastreportdate,'yyyy-mm-dd')#</cfoutput>" type="text" class="form-control mydatepicker" data-date-format="yyyy-mm-dd" placeholder="Due On">


</td>

</tr>
</table>

<label class="col-md-12" style="margin-top: 10px;">Notes</label>


<textarea name="notes" style="width:90%;height:100px;"><cfoutput>#geter.notes#</cfoutput></textarea>




<label class="col-md-12" style="margin-top: 10px;"><Cfif #geter.reportembed# is not ''><c href="<cfoutput>#geter.reportembed#</cfoutput>" target="mew"></Cfif>Banner Report Upload</a></label>
<!---

<textarea name="reportembed" style="width:80%;height:30px;font-size:7pt;"><cfoutput>#geter.reportembed#</cfoutput></textarea> --->	<input type=file name=report>




</div>

 <center>
  <br><!---<button type="submit" class="btn btn-success"> <i class="fa fa-check"></i> Save Entry</button>--->
 
 <input type="submit" Value="Save - Back to Admin" name="buttadminman" id="cdh_buttadminman" class="btn btn-danger btn-large"  style="font:bold 18px;color:white">
<input type="submit" Value="Save - Stay on Page" class="btn btn-success" style="font: bold 18px;color:white" name="buttarticleman" id="cdh_update_article">


 </center>
<br>
</form>


 </Td>
 <td style="vertical-align: top;">
 	
 			<cfoutput> <iframe src="adslistframe.cfm?clientid=#geter.id#&rand=#utime#<cfif parameterexists(url.campaignid)>&campaignid=#url.campaignid#</cfif>" style="width: 100%;height:700px;" frameborder="0" scrolling="yes"></iframe></cfoutput>

<!--- right column --->
 </td>

 </Tr></Table>

<Cfif #geter.reportembed# is not ''>
				<iframe src="<cfoutput>#geter.reportembed#</cfoutput>" style="width:100%;height:500px;"></iframe>

</Cfif>




</Cfif>

<Cfif not parameterexists(url.editclient) and not parameterexists(url.editcampaign)> 
<TAble id="example23" class="table color-table primary-table table-bordered table-striped table-hover">
<Cfoutput query="Gettodaya">
	
	




	<Cfif currentrow eq 1 or currentrow eq 10
		 or currentrow eq 20 or currentrow eq 30 or currentrow eq 40
			 or currentrow eq 60 or currentrow eq 50 or currentrow eq 70
				  or currentrow eq 100
					  or currentrow eq 80  or currentrow eq 90  
					  
					   or currentrow eq 110
		 or currentrow eq 120 or currentrow eq 130 or currentrow eq 140
			 or currentrow eq 160 or currentrow eq 150 or currentrow eq 170
				 					  or currentrow eq 180  or currentrow eq 190  

				  or currentrow eq 200
				>
		<thead>
<th><a href="adslist.cfm?sortby=clientname" style="color: white;">Client</a></th>
<th><a href="adslist.cfm?sortby=campaignname" style="color: white;">Campaign</a></th>
<th><a href="adslist.cfm?sortby=accountrep" style="color: white;">Rep</a></th>
<th><a href="adslist.cfm?sortby=startdate" style="color: white;">Start</a></th>
<th><a href="adslist.cfm?sortby=enddate" style="color: white;">End</a></th>

<th><a href="adslist.cfm?sortby=lastupdate" style="color: white;">Pending</a></th>
</thead>

	</Cfif>
<tr <cfif iostatus eq 1 or iostatus eq 2>style="background-color:pink"</cfif>>
<td>
	<cfif iostatus eq 1><b>UNPAID! </b><br></cfif>
	
		<cfif iostatus eq 2><b>SIGNATURE NEEDED!</b><br></cfif>

	<a href="adslist.cfm?editclient=#id#" 	<cfif (parameterexists(url.viewunpaid) or parameterexists(url.viewunsigned)) and getuser.id eq 26>title="$#iodollars#"</cfif>>#clientname#</a>


	
	<Cfif #clientemail# is not ''><a href="adslistemail.cfm?id=#id#"><img src="https://cloudimages.broadwayworld.com/babyblueemail.png" height='15'></a></Cfif>
	
		<Cfset newdate7 = dateadd('d',-7,currentdatetime)>
	<Cfset newdate7 = #dateformat(newdate7,'yyyy-mm-dd')#>


	<cfif #screenshotneeded# eq 1 or  
	
	(#lastreportdate# lt #newdate7#
	
	and iostatus eq 0 
and startdate lt '#dateformat(currentdatetime,'yyyy-mm-dd')#'

	
	)
	> <i class="fa fa-exclamation-triangle" style="color:##b20223;"></i></cfif>





	</td>


<td>#campaignname#</td>
<td>


<a href="adslist.cfm?rep=#accountrep#<cfif parameterexists(url.viewclosed)>&viewclosed=on</cfif><cfif parameterexists(url.viewunpaid)>&viewunpaid=on</cfif><cfif parameterexists(url.viewpending)>&viewpending=on</cfif>">#rereplace(accountrep,'@broadwayworld.com','')#</a></td>

<td>
<Cfif #dateformat(startdate,'yy')# eq '20'>
#dateformat(startdate,'m/d')#
<cfelse>
#dateformat(startdate,'m/d/yy')#
</Cfif>
</td>


<td>
<Cfif #dateformat(enddate,'yy')# eq '20'>
#dateformat(enddate,'m/d')#
<cfelse>
#dateformat(enddate,'m/d/yy')#
</Cfif>
</td>


<td style="padding:0px;padding-top:0px;padding-bottom:0px;">


<cfquery name="getcol" datasource="cityguide">
SELECT * from adopstrackingcampaign
where clientid = #id#
and typer <> ''
and laststatus <> 'Done'
and laststatus <> 'Entered'

order by startdate
</cfquery>

	<cfquery name="ipda" datasource="cityguide">
		update cgny_cgnew.adopstrackingclient
		set pendingcount = #getcol.recordcount#
		where id = #id#
	</cfquery>


<cfif #getcol.recordcount# gt 0>
	
	
<table cellpadding="4" style="width:100%">
<tr style="background-color:black;">
    <Td style="color:white;font-size:10pt;width:20px;">Type</Td>    
    <Td style="color:white;font-size:10pt;width:90px;">Dates</Td>    

    <Td style="color:white;font-size:10pt;">Name</Td>    
 <Td style="color:white;font-size:10pt;width:10px;">Notes</Td>  

</tr>    
<cfloop from="1" to="#getcol.recordcount#" index="i">
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
<td style="font-size:10pt;width:100px;"><a href="https://admin.nymetroparents.com/adslist.cfm?editclient=#id#&campaignid=#getcol.id[i]#">#getcol.typer[i]#</a></td>
<td style="font-size:10pt;width:50px;">#dateformat(getcol.startdate[i],'m/d')#<Cfif #getcol.enddate[i]# is not #getcol.startdate[i]#>-#dateformat(getcol.enddate[i],'m/d')#</cfif></td>


<td style="font-size:10pt;">#getcol.segmentname[i]#

<cfif #getcol.typer[i]# eq 'eblast'>
	<cfif #getcol.quantity[i]# eq 0>Full<cfelse>#getcol.quantity[i]#</cfif><cfif #getcol.notes[i]# is not ''> - #getcol.notes[i]#</cfif>
</cfif>
</td>

<td style="font-size:10pt;">#getcol.updatetext[i]#</td>

</tr>
</cfloop>
</table>
	
</cfif>

</td>


</tr>
</Cfoutput>
</Table>
</cfif>
<Br>
	
<Script type="text/javascript">
	$(document).ready(function() {
    $('.js-example-basic-single').select2();
});</script>
<cfinclude template="footer.cfm">

  </body>
</html>