+ ((context.DB_STATS_DateJob != null && !""\r
.equals(context.DB_STATS_DateJob)) ? context.DB_STATS_DateJob\r
: TalendDate.getDate("CCYY-MM-DD"))\r
- + "' AS DATE) - 1 AND cdt.id_item = proprio.id_item AND proprio.proprietaire = TRUE AND cdt.id_item = item.id AND personne.id = proprio.id_autorite group by personne.id_externe,to_char(cdt.date_creation,'HH24') ) v_cdt on v_cdt.personne_id = v_act.personne_id and v_cdt.heure = v_act.heure";\r
+ + "' AS DATE) - 1 AND cdt.item_id = proprio.item_id AND proprio.proprietaire = TRUE AND cdt.item_id = item.id AND personne.id = proprio.autorite_id group by personne.id_externe,to_char(cdt.date_creation,'HH24') ) v_cdt on v_cdt.personne_id = v_act.personne_id and v_cdt.heure = v_act.heure";\r
\r
java.sql.ResultSet rs_tPostgresqlInput_1 = stmt_tPostgresqlInput_1\r
.executeQuery(dbquery_tPostgresqlInput_1);\r
\r
ods_blog = null;\r
\r
- // # Output table : 'ods_blog'
+ // # Output table : 'ods_blog'\r
ods_blog_tmp.application = "CDT";\r
ods_blog_tmp.porteur = row3.code_porteur;\r
ods_blog_tmp.type_lycee = row3.type_structure;\r
ods_blog_tmp.c5 = null;\r
ods_blog_tmp.c6 = null;\r
ods_blog = ods_blog_tmp;\r
- // ###############################
+ // ###############################\r
\r
- } // end of Var scope
+ } // end of Var scope\r
\r
rejectedInnerJoin_tMap_1 = false;\r
\r
\r
if (!rejectedInnerJoin_tMap_2) {\r
\r
- // # Output table : 'update'
+ // # Output table : 'update'\r
update_tmp.application = row6.application;\r
update_tmp.porteur = "CRIF";\r
update_tmp.type_lycee = row7.type_structure;\r
update_tmp.c5 = row6.c5;\r
update_tmp.c6 = row6.c6;\r
update = update_tmp;\r
- } // closing inner join bracket (2)
- // ###############################
+ } // closing inner join bracket (2)\r
+ // ###############################\r
\r
- } // end of Var scope
+ } // end of Var scope\r
\r
rejectedInnerJoin_tMap_2 = false;\r
\r
ResumeUtil resumeUtil = null;\r
}\r
/************************************************************************************************\r
- * 282658 characters generated by Talend Open Studio on the 27 avril 2012\r
- * 18:38:56 CEST\r
+ * 282658 characters generated by Talend Open Studio on the 9 mai 2012 10:24:02\r
+ * CEST\r
************************************************************************************************/\r