1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
<script language="javascript">
function verifier_saisie_date_debut_et_fin(num_semaine_deb,num_semaine_fin,annee,num_crc,code_canal,date_deb,date_fin)
{
var execute = true;
alert(num_semaine_deb+","+num_semaine_fin+","+annee+","+num_crc+","+code_canal+","+date_deb+","+date_fin);)
if(execute)
{
if (date_fin=="")
{
if((code_canal ==5) || (code_canal ==9) || (code_canal ==1))
{
requete = "SELECT of.libelle_offre,ob.objectifs,v.nbvente FROM offres of LEFT OUTER JOIN ( SELECT ob.code_offre, sum(ob.obj) AS objectifs FROM obectifs ob WHERE ob.num_semaine = "+num_semaine_deb+" AND ob.annee = "+annee+" AND ob.num_agent IN (SELECT num_agent from agents,equipes,crc where agents.num_equipe = equipes.code_equipe AND crc.num_crc = equipes.crc AND equipes.crc = '"+num_crc+"') GROUP BY ob.code_offre) ob ON ob.code_offre = of.code_offre";
requete = requete+" LEFT OUTER JOIN (SELECT v.code_offre, count(v.num_vente) AS nbvente FROM ventes v WHERE v.num_agent IN (SELECT num_agent from agents,equipes,crc where agents.num_equipe = equipes.code_equipe AND crc.num_crc = equipes.crc AND equipes.crc = '"+num_crc+"')AND v.date_vente = '"+date_deb+"' GROUP BY v.code_offre) v ON v.code_offre = of.code_offre WHERE of.code_canal = 'crc_qe' order by ordre";
}
this.document.res_obj.requete_XLS.value=requete;
return true;
}
}
else
{
i=num_semaine_fin-num_semaine_deb;
}
else
{
return false;
}
}
</script> |
Partager