<link rel="https://fonts.googleapis.com/css?family=Poppins:400,500,300,600,700" href="https://fonts.googleapis.com/css?family=Poppins:400,500,300,600,700" type="text/css">

    <link href="/theme/horizontal/css/style.css" rel="stylesheet">

    <!-- color CSS you can use different color css from css/colors folder -->
    <!-- We have chosen the skin-blue (blue.css) for this starter
          page. However, you can choose any other skin from folder css / colors .
-->

<Cfif parameterexists(url.done)>
	
	<cfquery name="da" datasource="cityguide">
		update adopstrackingcampaign set laststatus = 'Done' 
		where id = #url.campaignid#
		
	</cfquery>
	
	<cflocation url="adslistframe.cfm?clientid=#url.clientid#">
	
</cfif>

<Cfif parameterexists(url.notdone)>
	
	<cfquery name="da" datasource="cityguide">
		update adopstrackingcampaign set laststatus = 'Needed' 
		where id = #url.campaignid#
		
	</cfquery>
	
	<cflocation url="adslistframe.cfm?clientid=#url.clientid#">
	
</cfif>



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


<cfif parameterexists(url.addcampaign)>
		<cfquery name="getlastentry" dataSource="cityguide">
		select * from adopstrackingcampaign
		where clientid = #url.clientid#
		and typer <> '' and typer is not null
		order by id desc
		limit 0,1
	</cfquery>
	
	<cfif #getlastentry.recordcount# eq 1>
		
				<cfquery name=addphoto datasource="cityguide">
INSERT INTO adopstrackingcampaign(
clientid,typer,startdate,enddate,segmentname,notes,gotarticle,laststatus,lastupdate)
		VALUES(
#url.clientid#,'',#getlastentry.startdate#,#getlastentry.enddate#,'','',0,'',#currentdatetime#)
		</cfquery>
		<Cfelse>
			<cfquery name=addphoto datasource="cityguide">
INSERT INTO adopstrackingcampaign(
clientid,typer,startdate,enddate,segmentname,notes,gotarticle,laststatus,lastupdate)
		VALUES(
#url.clientid#,'',#currentdatetime#,#currentdatetime#,'','',0,'',#currentdatetime#)
		</cfquery>

	</cfif>
	

	<cfquery name="getlast" dataSource="cityguide">
		select id from adopstrackingcampaign
		order by id desc
		limit 0,1
	</cfquery>
	<cflocation addToken="no" url="adslistframe.cfm?clientid=#url.clientid#&campaignid=#getlast.id#">
</cfif>


<cfif parameterexists(url.editsavecampaign)>
	
	<cfif #form.typer# eq 'Pick a Type'>
		<font color="red"><B>Error, you must pick a type.</B></font>
		<a href="javascript:history.back()">Go Back</a>

<cfabort>
	</cfif>
<cfparam name="form.gotarticle" default="0">
<cfparam name="form.quantity" default="0">
<cfparam name="form.siteson" default="">

<cfquery name="upds" dataSource="cityguide">
	update adopstrackingcampaign
	set
typer = '#form.typer#',
startdate = '#form.startdate#',
enddate = '#form.enddate#',
segmentname = '#form.segmentname#',
updatetext = '#form.updatetext#',
notes = '#form.notes#',
<Cfif parameterexists(form.siteson)>
siteson = '#form.siteson#',
</cfif>	
gotarticle = #form.gotarticle#,
quantity = #form.quantity#,

laststatus = '#form.laststatus#',
lastupdate = #currentdatetime#

	where id = #url.editsavecampaign#
</cfquery>

<cfquery name="checkdate" dataSource="cityguide">
	select enddate from adopstrackingclient where id = #url.clientid#
</cfquery>

<cfif #form.enddate# gt #checkdate.enddate#>
	<cfquery name="upds" dataSource="cityguide">
		update adopstrackingclient
		set enddate = '#form.enddate#'
		where id = #url.clientid#
	</cfquery>

</cfif>	


<cflocation url="/adslistframe.cfm?clientid=#url.clientid#" addToken="no">
</cfif>


<Cfif parameterexists(url.campaignid)>
    <Cfoutput>
    <a href="adslistframe.cfm?delete=#url.campaignid#&clientid=#url.clientid#" onclick="return confirm('Are you sure?');">Delete Item</a> | 	<a href="javascript:history.back()">Go Back</a></Cfoutput>
    
  	<Cfquery name="geter" dataSource="cityguide">
		select * from adopstrackingcampaign
		where id = #url.campaignid#
	</cfquery>
	


    <FORM action="adslistframe.cfm?editsavecampaign=<cfoutput>#url.campaignid#&clientid=#url.clientid#</cfoutput>" method="post"  enctype="multipart/form-data">


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



<label class="col-md-12" style="margin-top: 10px;">Item Name</label>
<div class="col-md-12">
<input  name="segmentname" style="width:100%;" type="text" class="form-control" value="<Cfoutput>#geter.segmentname#</Cfoutput>">
</div>

<Table><tr><Td style="font-size:10pt;">
<script src="/plugins/bower_components/jquery/dist/jquery224.min.js"></script>

<label class="col-md-12" style="margin-top: 10px;">Type</label>
<div class="col-md-12">
			<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>

	<Select name="typer"  class="js-example-basic-single">
<cfif #geter.typer# eq ''>
			<option value="Pick a Type">Pick a Type</option>
</cfif>	
	
	<option value="<Cfoutput>#geter.typer#</cfoutput>"><cfoutput>#geter.typer#</cfoutput></option>
	<Cfquery name="gettypes" datasource="cityguide">
		select * from adopstrackingtypes
		order by typer
	</Cfquery>
	<Cfoutput query="Gettypes">
		<option value="#typer#">#typer#</option>
		</Cfoutput>

	</Select>
</div>


<Script type="text/javascript">
	$(document).ready(function() {
    $('.js-example-basic-single').select2();
});</script>

</td><Td style="font-size:10pt;">
<label class="col-md-12" style="margin-top: 10px;">Status</label>
<div class="col-md-12">
	<Select name="laststatus"  class="js-example-basic-single">
		<cfif #geter.laststatus# is not ''><option value="<Cfoutput>#geter.laststatus#</cfoutput>"><cfoutput>#geter.laststatus#</cfoutput></option></cfif>
		<option value="Needed">Needed</option>

		<option value="Requested">Requested</option>
		<option value="Done">Done</option>

	</Select>
</div>

</Td>


<Td style="font-size:10pt;">
<label class="col-md-12" style="margin-top: 10px;">Quantity/Impressions</label>
<div class="col-md-12">
<input  name="quantity" style="width:100%;" type="number" class="form-control" value="<Cfoutput>#geter.quantity#</Cfoutput>">
</div>

</Td>


<Cfif #geter.siteson# is not 'BWW' and #geter.siteson# is not ''>
<Td style="font-size:10pt;">
<label class="col-md-12" style="margin-top: 10px;">Sites</label>
<div class="col-md-12">
<input style="opacity:100;position:relative;left:0px;" name="siteson" type="checkbox" value="NYMP" <Cfif #geter.siteson# contains 'NYMP'>checked</cfif>>NYMP<br> 	
<input style="opacity:100;position:relative;left:0px;" name="siteson" type="checkbox" value="SIP" <Cfif #geter.siteson# contains 'SIP'>checked</cfif>>SIP<br> 	
<input style="opacity:100;position:relative;left:0px;" name="siteson" type="checkbox" value="MB" <Cfif #geter.siteson# contains 'MB'>checked</cfif>>MB<br> 	

</div>

</Td></Cfif>

</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' });
  });


  </script>


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


<input id="datepicker" 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">

<input type="checkbox" style="opacity:100;position:relative;left:0px;"  name="billingtoo" onclick="FillBilling(this.form)"> <small>Copy -></small>

</td>


<td style="width:50%;padding:4px;vertical-align:top;">
<label class="col-md-12" style="margin-top: 10px;">End Date</label><Br>
<input id="datepicker2" 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">

<script type="text/javascript">
	function FillBilling(f) {
  if(f.billingtoo.checked == true) {
    f.enddate.value = f.startdate.value;
  }
}
</script>

</td>


</tr>
</table>


<label class="col-md-12" style="margin-top: 10px;">Line Item Notes</label>
<div class="col-md-12">
    <textarea name="notes" class="form-control" style="width:100%;height:100px;"><Cfoutput>#geter.Notes#</Cfoutput></textarea>
</div>


<label class="col-md-12" style="margin-top: 10px;">AdOps Update</label>
<div class="col-md-12">
    <textarea name="updatetext" class="form-control" style="width:100%;height:100px;"><Cfoutput>#geter.updatetext#</Cfoutput></textarea>
</div>




</div>

 <center>
  <br><!---<button type="submit" class="btn btn-success"> <i class="fa fa-check"></i> Save Entry</button>--->
 
 <input type="submit" Value="Save" id="cdh_buttadminman" class="btn btn-danger btn-large"  style="font:bold 18px;color:white">


 </center>
<br>
</form>


    

<Cfelse>
<cfquery name="getcol" datasource="cityguide">
SELECT * from adopstrackingcampaign
where clientid = #url.clientid#
and typer <> ''
and laststatus <> 'Done'
order by startdate
</cfquery>
<table cellpadding="4" style="width:100%">
<tr style="background-color:black;">
<Td style="color:white"></Td>    
    <Td style="color:white">Type</Td>    
    <Td style="color:white">Name</Td>    
    <Td style="color:white">Dates</Td>    
    <Td style="color:white">Notes</Td>    
    <Td style="color:white">Status</Td>    

</tr>    
<Cfoutput query="getcol">
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
<Td style="font-size:10pt;"><a href="adslistframe.cfm?clientid=#url.clientid#&campaignid=#id#"><span class="btn tip-top" data-original-title="Edit"><i class="ti ti-pencil-alt"></i></span></a></Td>
<Td style="font-size:10pt;">#typer#</td>
<Td style="font-size:10pt;"><Cfif #siteson# is not 'BWW'>#siteson#</Cfif> #segmentname#</td>

<Td style="font-size:10pt;">#dateformat(startdate,'m/d')#<Cfif #startdate# is not #enddate#>-#dateformat(enddate,'m/d/yy')#</cfif></td>
<Td style="font-size:10pt;">#notes#</td>
<Td style="font-size:10pt;">#laststatus#<br> <center><a href="adslistframe.cfm?clientid=#url.clientid#&done=on&campaignid=#id#"><i class="fa fa-check"></i></a></center></td>

</tr>
</Cfoutput>
</table><br>





<Cfoutput><a href="adslistframe.cfm?clientid=#url.clientid#&addcampaign=on" class="btn btn-success" style="background-color:black;color:white;">+ add item</a></Cfoutput>

<br><br>
<b>Done</b>
<br>
<cfquery name="getcol" datasource="cityguide">
SELECT * from adopstrackingcampaign
where clientid = #url.clientid#
and typer <> ''
and laststatus = 'Done'

order by startdate
</cfquery>
<table cellpadding="4" style="width:100%">
<tr style="background-color:black;">
<Td style="color:white"></Td>    
    <Td style="color:white">Type</Td>    
    <Td style="color:white">Name</Td>    
    <Td style="color:white">Dates</Td>    
    <Td style="color:white">Notes</Td>    
    <Td style="color:white">Status</Td>    

</tr>    
<Cfoutput query="getcol">
<TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
<Td style="font-size:10pt;"><a href="adslistframe.cfm?clientid=#url.clientid#&campaignid=#id#"><span class="btn tip-top" data-original-title="Edit"><i class="ti ti-pencil-alt"></i></span></a></Td>
<Td style="font-size:10pt;">#typer#</td>
<Td style="font-size:10pt;">#segmentname#</td>

<Td style="font-size:10pt;">#dateformat(startdate,'m/d')#<Cfif #startdate# is not #enddate#>-#dateformat(enddate,'m/d/yy')#</cfif></td>
<Td style="font-size:10pt;">#notes#</td>
<Td style="font-size:10pt;">#laststatus#<br><Cfif parameterexists(cookie.email)><a href="adslistframe.cfm?clientid=#url.clientid#&notdone=on&campaignid=#id#"></Cfif>#dateformat(lastupdate,'m/d/yy')#</td>

</tr>
</Cfoutput>
</table>


</cfif>