<cfinclude template="../../topmenu2.cfm" />
<cfprocessingdirective pageEncoding="UTF-8"/>

<cfquery name="BuscaPerguntasFraude" datasource="#AMSSV304#">
	select * from PARAMETROS_PERGUNTA_INTEGRITY_CHECK_PP with(nolock)
	WHERE TIPO_QUESTAO NOT IN ('Col, Não Col, Ev. Natural SEGUR', 'Colisão terc', 'Roubo Furto Segurado','pp?')
</cfquery>

<cfset ResultF = ''>
<cfset classificacaoF = ''>

<cfquery name="buscaClassificacaoFraude" datasource="#AMSSV304#">
	SELECT SUM (Pontuacao_atribuida) AS PONTUACAO_FRAUDE
	FROM PARAMETROS_PERGUNTA_INTEGRITY_CHECK_PP with(nolock)
	WHERE TIPO_QUESTAO NOT IN ('Col, Não Col, Ev. Natural SEGUR', 'Colisão terc', 'Roubo Furto Segurado','pp?')
</cfquery>

<cfquery name="buscaPontuacaoFraude" datasource="#AMSSV304#">
	SELECT * FROM PARAMETROS_RULES_CHECK_FRAUDE with(nolock)
</cfquery>

<cfquery name="buscaPontuacaoFraudeOneAndDone" dbtype="query">
	SELECT PONTUACAO_NECESSARIA FROM buscaPontuacaoFraude
	where ID_PARAMETRO = 1
</cfquery>

<cfquery name="buscaPontuacaoFraudeOthers" dbtype="query">
	SELECT PONTUACAO_NECESSARIA FROM buscaPontuacaoFraude
	where ID_PARAMETRO = 3
</cfquery>

<cfquery name="buscaPontuacaoFraudeExpress" dbtype="query">
	SELECT PONTUACAO_NECESSARIA FROM buscaPontuacaoFraude
	where ID_PARAMETRO = 5
</cfquery>

<cfquery name="buscaPontuacaoFraudeBarrado" dbtype="query">
	SELECT PONTUACAO_NECESSARIA FROM buscaPontuacaoFraude
	where ID_PARAMETRO = 2
</cfquery>

<cfquery name="buscaPontuacaoFraudeLiberado" dbtype="query">
	SELECT PONTUACAO_NECESSARIA FROM buscaPontuacaoFraude
	where ID_PARAMETRO = 4
</cfquery>

<!---Início regras Array--->
<cfset arrayResp = arrayNew(1)>
<cfoutput query="BuscaPerguntasFraude">
	<cfset arrayResp[#id#] = ''>
</cfoutput>

<cfquery name="BuscaDadosDeclarante" datasource="#amssv304#">
	select
	id_declarante
	,dt_abertura
	,dt_aviso
	,TIPO_ABERTURA
	,cpf_declarante
	,NUMERO_AVISO
	,reabertura
	from tb_011_gisinitro with(nolock) where nu_rs = #url.nu_rs# and nu_macro_processo = #url.nu_macro_processo#
</cfquery>
<cfset dec = #BuscaDadosDeclarante#>

<cfquery name="BuscaDadosCondutor" datasource="#amssv304#">
	select DATA_NASCIMENTO from TB_DADOS_CONDUTOR_OCORRENCIA with(nolock)
	where nu_rs = #url.nu_rs#
	and nu_macro_processo = #url.nu_macro_processo# order by condutor asc
</cfquery>
<cfset COND = #BuscaDadosCondutor#>

<cfquery name="BuscaSegRepetido" datasource="#amssv304#">
	Select CPF_CNPJ_SEG from TB_CLIENTE_ZURICH_GI
	inner join tb_011_gisinitro with(nolock)
	on tb_011_gisinitro.nu_rs = TB_CLIENTE_ZURICH_GI.nu_rs
	and tb_011_gisinitro.nu_macro_processo = TB_CLIENTE_ZURICH_GI.nu_macro_processo
	where CPF_CNPJ_SEG = '#cli_z.CPF_CNPJ_SEG#'
	and dt_abertura < '#BuscaDadosDeclarante.dt_abertura#'
	and numero_aviso is not null
</cfquery>

<cfset data_atual = Lsdateformat(now(),'yyyy-mm-dd')>
<cfset data_nascimento = Lsdateformat(COND.DATA_NASCIMENTO,'yyyy-mm-dd')>

<!---Regra temporária--->
<cfif dec.TIPO_ABERTURA eq 2>
	<cfif data_nascimento neq ''>
		<cfif dateDiff('yyyy',data_nascimento, data_atual) lt 25>
			<cfset arrayResp[50] = 'SIM'>
		<cfelse>
			<cfset arrayResp[50] = 'NÃO'>
		</cfif>
	<cfelse>
		<cfset arrayResp[50] = 'NÃO'>
	</cfif>
<cfelse>
	<cfif data_nascimento neq ''>
		<cfif dateDiff('yyyy',data_nascimento, data_atual) lt 25>
			<cfset arrayResp[50] = 'SIM'>
		<cfelse>
			<cfset arrayResp[50] = 'NÃO'>
		</cfif>
	<cfelse>
		<cfset arrayResp[50] = 'NÃO'>
	</cfif>
</cfif>

<cftry>
	<cfif oco.HORA_OCORRENCIA neq '' and oco.HORA_OCORRENCIA neq ''>
		<cfset hora = #LSTimeFormat(oco.HORA_OCORRENCIA,'HH:mm:ss')#>

		<cfquery name="pegaHora" datasource="#amssv304#">
			SELECT DATEDIFF(hh, '00:00:00', '<cfoutput>#hora#</cfoutput>') AS Hora1,
			DATEDIFF(hh, '<cfoutput>#hora#</cfoutput>', '05:00:00') AS Hora2
		</cfquery>

		<cfif (isdefined('pegaHora') and #pegaHora.hora1# gte 22) or ((isdefined('pegaHora') and #pegaHora.Hora2# gte 0) and (isdefined('pegaHora') and #pegaHora.Hora2# lte 5))>
			<cfset arrayResp[52] = 'SIM'>
		<cfelse>
			<cfset arrayResp[52] = 'NÃO'>
		</cfif>
	<cfelse>
		<cfset arrayResp[52] = 'NÃO'>
	</cfif>
<cfcatch>
	<cfset arrayResp[52] = 'NÃO'>
</cfcatch>
</cftry>

<cfif isDefined('BuscaSegRepetido') and #BuscaSegRepetido.RecordCount# gt 1>
	<cfset arrayResp[51] = 'SIM'>
<cfelse>
	<cfset arrayResp[51] = 'NÃO'>
</cfif>

<!---Fim regras Array--->
<head>

	<script type='text/javascript' src="http://knockoutjs.com/downloads/knockout-2.3.0.js"></script>
	<script type='text/javascript' src="progressbar/bootstrap-progressbar.js"></script>

	<style>
		h2 {
			font-weight: bold;
			text-align: center;
		}
		.color {
			background-color: #000;
			color: #fff;
			font-weight: bold;
		}

		.panel {
			border: 0;
		}
		.painel {
			background-color: #f0db3c;
			border-radius: 40px
		}
		.classifica {
			color: #e46c0a;
		}
	</style>
</head>

<body>
<div class="container">
	<h2>Integrity Check Fraude</h2>
	<br>
	<table class="table table-striped" name="tblCheckFraude" id="tblCheckFraude">
		<thead class="color">
			<tr style="align:center">
				<th style="align:center">SEQ.</th>
				<th style="align:center">Questão</th>
				<th style="align:center">Resposta</th>
				<th style="align:center">Score</th>
			</tr>
		</thead>
		<tbody>
			<cfset totFraude = 0>
			<cfoutput query="BuscaPerguntasFraude">
				<cfif arrayResp[#ID#] eq #QUANDO_PONTUAR#>
					<cfset Pontuacao_atribuida1 = #Pontuacao_atribuida#>
				<cfelse>
					<cfset Pontuacao_atribuida1 = 0>
				</cfif>
				<tr align="center" <cfif #Pontuacao_atribuida1# eq 0>style="background-color:##ffff99"<cfelse>style="background-color:##b2ecbc"</cfif>>
					<td>#ID#</td>
					<td>#Questao#</td>
					<td>#arrayResp[ID]#</td>
					<td>
						#Pontuacao_atribuida1#
						<cfset totFraude = #totFraude# + #Pontuacao_atribuida1#>
					</td>
				</tr>
			</cfoutput>
			<cfif totFraude lte NumberFormat(buscaPontuacaoFraudeOneAndDone.PONTUACAO_NECESSARIA)>
				<cfset classificacaoF = 'One and Done'>
			<cfelseif totFraude gte NumberFormat(buscaPontuacaoFraudeExpress.PONTUACAO_NECESSARIA)>
				<cfset classificacaoF = 'Express'>
			<cfelse>
				<cfset classificacaoF = 'Others'>
			</cfif>

			<cfif totFraude lte NumberFormat(buscaPontuacaoFraudeLiberado.PONTUACAO_NECESSARIA)>
				<cfset ResultF = 'Liberado'>
			<cfelse>
				<cfset ResultF = 'Barrado'>
			</cfif>
		</tbody>
	</table>
	<div class="row">
		<div class="col-sm-offset-4 col-sm-4">
			<div class="panel panel-default">
				<div class="panel-body painel">
					<div class="col-sm-12" align="center">
						<h2><span>Seu score é: </span><span class="classifica"><cfoutput>#totFraude#</cfoutput></span></h2>
						<br/>
						<h2><span class="classifica"><cfoutput>#classificacaoF#</cfoutput></span></h2>
						<br>
						<div class="progress">
							<div class="progress-bar bg-danger" role="progressbar" style="width: 100%" aria-valuenow="100" aria-valuemin="0" aria-valuemax="100"></div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
	<div class="row" align="center" <cfif ResultF eq 'Liberado'>style="background-color:green"<cfelse>style="background-color:yellow"</cfif>>
		<br/>
		<h2>
			Resultado: <cfif ResultF eq 'Liberado'>Liberado<cfelse>Barrado</cfif>
		</h2>
		<br/>
	</div>
	<br/>
</div>

</body>

<script type="text/javascript">

	$(function () {
		$('#progressbar').progressbar({
			warningMarker: 50,
			dangerMarker: 75,
			maximum: 100,
			step: 1
		});

		$('#progressbar').on("positionChanged", function (e) {
			viewModel.percent(e.percent);
		});

		ko.applyBindings(viewModel);
	});

	var viewModel = {
		percent: ko.observable(0),
		step: ko.observable(1),
		maximum: ko.observable(100),
		position: ko.observable(80),
		interval: undefined,
		isRunning: ko.observable(false),

		stepIt: function () {
			$('#progressbar').progressbar('stepIt');
		},

		reset: function () {
			$('#progressbar').progressbar('reset');
		},

		start: function () {
			if (this.isRunning())
				return;

			this.reset();
			this.isRunning(true);

			var self = this;
			this.interval = setInterval(function () {
				$('#progressbar').progressbar('stepIt');
				if (self.percent() >= 100) {
					clearInterval(self.interval);
					self.interval = undefined;
					self.isRunning(false);
				}
			}, 250);
		}
	};

	viewModel.formattedPercent = ko.computed(function () {
		return this.percent() + '%';
	}, viewModel);

	viewModel.maximum.subscribe(function (newValue) {
		$('#progressbar').progressbar('setMaximum', newValue);
	}, viewModel);

	viewModel.position.subscribe(function (newValue) {
		$('#progressbar').progressbar('setPosition', newValue);
	}, viewModel);

	viewModel.step.subscribe(function (newValue) {
		$('#progressbar').progressbar('setStep', newValue);
	}, viewModel);
</script>