[FogBugz #650] Suppression des visites non validées #713
Loading…
Reference in New Issue
There is no content yet.
Delete Branch "%!s(<nil>)"
Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?
Assigned To: CLOSED
Project: Mobile Portal
Area: Divers
Category: Fonctionnalité
Priority: A fixer impérativement
Event ID: 3312
Date: 2017-11-28T09:15:13Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist
Event ID: 3311
Date: 2017-11-28T09:15:13Z
Person: Frederik Benoist
Description: Résolu (Implémenté) and assigned to Frederik Benoist by Frederik Benoist
Event ID: 3272
Date: 2017-10-23T04:10:01Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
IKKS- Auto-validation des visites contenant une synthèse ou un contrôle
UPDATE mr_visite mvisSET id_visite_type =
NVL (
id_visite_type,
(SELECT id_visite_type
FROM mr_visite_type
WHERE ( libelle_traduit LIKE '%Flas%'
OR libelle_traduit LIKE '%express%')
AND mvis.id_distrib_visite = mr_visite_type.id_distrib)),
copie_cr_etab = NULL,
envoi_cr_etab = NULL,
envoi_cr_resp = NULL,
usr_modlog = 0,
date_validation =
TO_DATE (
TO_CHAR (NVL (date_visite_fin, date_visite), 'DD/MM/RRRR')
|| ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS'),
usr_moddat =
TO_DATE (TO_CHAR (SYSDATE - 1, 'DD/MM/RRRR') || ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS')
WHERE id_visite IN (13567,
13222,
13223,
13036,
13038,
12939,
12630,
12518,
12360,
12605,
12337,
12327,
11608,
12212,
12031,
11303,
11794,
11307,
11930,
11416,
11295,
11428,
11692,
11691,
11622,
10378,
11330,
11126,
11905,
11512,
11125,
11314,
12056,
11265,
10901,
10673,
10631,
10672,
11200,
10625,
11185,
10372,
10804,
10622,
10701,
10918,
10700,
10367,
9853,
10161,
10197,
10207,
9716,
9875,
9769,
9645,
9306,
9604,
9458,
8957,
9309,
9237,
9154,
8886,
9198,
8633,
8596,
8896,
8747,
8411,
8183,
7759,
8406,
8418,
7945,
7813,
7941,
7663,
7713,
7570,
7620,
7491,
7650,
7677,
7463,
7380,
7490,
7260,
7715,
7110,
7114,
7242,
6503,
6488,
6318,
6317,
6664,
6498,
6784,
6663,
6638,
6494,
6642,
6643,
6177,
6337,
6442,
6335,
6332,
6329,
6438,
6105,
6029,
5719,
5869,
5507,
5776,
5638,
5666,
5665,
5458,
5423,
5488,
5195);
Event ID: 3271
Date: 2017-10-23T04:05:20Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
KIDILIZ- Auto-validation des visites contenant une synthèse ou un contrôle
UPDATE mr_visite mvisSET id_visite_type =
NVL (
id_visite_type,
(SELECT id_visite_type
FROM mr_visite_type
WHERE ( libelle_traduit LIKE '%Flas%'
OR libelle_traduit LIKE '%express%')
AND mvis.id_distrib_visite = mr_visite_type.id_distrib)),
copie_cr_etab = NULL,
envoi_cr_etab = NULL,
envoi_cr_resp = NULL,
usr_modlog = 0,
date_validation =
TO_DATE (
TO_CHAR (NVL (date_visite_fin, date_visite), 'DD/MM/RRRR')
|| ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS'),
usr_moddat =
TO_DATE (TO_CHAR (SYSDATE - 1, 'DD/MM/RRRR') || ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS')
WHERE id_visite IN (27775,
28176,
27137,
27138,
27728,
25478,
27450,
26513,
26785,
26661,
26663,
26662,
26454,
26255,
26182,
26181,
26134,
26180,
25896,
24750,
25849,
25614,
23995,
25521,
24808,
23415,
25272,
24373,
23008,
24679,
24735,
24060,
23987,
23092,
23681,
23615,
22907,
23167,
22650,
22971,
22180,
21712,
22178,
21247,
21246,
21585,
21458,
21235,
21516,
21391,
21228,
21390,
20075,
20396,
20063,
17868,
19895,
19781,
19776,
19778,
19222,
19606,
19605,
19604,
18306,
19196,
19168,
19169,
18307,
18871,
18018,
18935,
18931,
18052,
18211,
18547,
18546,
18752,
17919,
17920,
17912,
17910,
17911,
17759,
17690,
17284,
17568,
17561,
17563,
17353,
17335,
17333,
17236,
17237,
17002,
17101,
16694,
16695,
17018,
17019,
17021,
17022,
17020,
16795,
16994,
16693,
16692,
16798,
16691,
16690,
16688,
16689,
16687,
16450,
16451,
16321,
16320,
16322,
16323,
16319,
16318,
16315,
16316,
16314,
16312,
16313,
16189,
16190,
16191,
16188,
16185,
16186,
16187,
16184,
16056,
16133,
16127,
16128,
15985,
15988,
15990,
15989,
15987,
15993,
15649,
15648,
15645,
15647,
15638,
15637,
15636,
15635,
15631,
15657,
15642,
15629,
15634,
15646,
15021,
15463,
14996,
14593,
14685,
14860,
14792,
14682,
14800,
14179,
14087,
14099,
13821,
13827,
13728,
13285,
13112,
13010,
12678,
12612,
12673,
12413,
12671,
12670,
12669,
11619,
11618,
11616,
11615,
11700,
11613,
11600,
11471,
11208,
9973,
11058,
10977,
10896,
10862,
10610,
10160,
10095,
9909,
9694,
9462,
8481,
7908,
7909,
7871,
7872,
7448,
7212,
7170,
7120,
6764,
6597,
6598,
6546,
5863,
5581,
5420,
5332,
5419,
4920,
4716,
4365,
4216,
4095,
3915,
3789,
3473,
3402,
3311,
2906,
2880,
2793,
2763,
2686,
2659,
2450,
2505,
1647,
2111,
1778,
1869,
1836,
1804,
1317,
1685,
1649,
1571,
1452,
1446,
1408,
739,
1235,
736,
1233,
1231,
1232,
983,
1229,
1230,
1036,
1037,
1048,
553,
1046,
982,
899,
837,
437,
804,
794,
800,
817,
786,
734,
707,
700,
643,
644,
316,
248,
157,
249,
362,
363);
Event ID: 3270
Date: 2017-10-22T17:21:17Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Meme chose pour IKKS
UPDATE mr_visite mvisSET id_visite_type =
(SELECT id_visite_type
FROM mr_visite_type
WHERE libelle_traduit LIKE '%Photos boutique%'
AND mvis.id_distrib_visite = mr_visite_type.id_distrib),
copie_cr_etab = NULL,
envoi_cr_etab = NULL,
envoi_cr_resp = NULL,
usr_modlog = 0,
date_validation =
TO_DATE (
TO_CHAR (NVL (date_visite_fin, date_visite), 'DD/MM/RRRR')
|| ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS'),
usr_moddat =
TO_DATE (TO_CHAR (SYSDATE - 1, 'DD/MM/RRRR') || ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS')
WHERE id_visite IN (13129,
13024,
13001,
12603,
11610,
12284,
12131,
12213,
12214,
12216,
12217,
12218,
12219,
11926,
11927,
11928,
11929,
12215,
11906,
11908,
11909,
11910,
11911,
11093,
11686,
11700,
10857,
11560,
10798,
10861,
11048,
11519,
11357,
11309,
11901,
11902,
11211,
11212,
11213,
11214,
10664,
10663,
10302,
10239,
9460,
9882,
8669,
9418,
8758,
8786,
9236,
9248,
9015,
9217,
8777,
8813,
8871,
8870,
8749,
8945,
8904,
8639,
8622,
8621,
8457,
7191,
7069,
7192,
8131,
8143,
8130,
8132,
8084,
8001,
7812,
7811,
7933,
7934,
7798,
7627,
7626,
7719,
7723,
7625,
7621,
7686,
7107,
7508,
6812,
7515,
7693,
7447,
6765,
7517,
7516,
7056,
6759,
7252,
7251,
6818,
6646,
6612,
6617,
6355,
5997,
6583,
6458,
6226,
5512,
5718,
5896,
5898,
5848,
5506,
5505,
5504,
5503,
5930,
5795,
5798,
5842,
5797,
5470,
5844,
5466,
5464,
5463,
5462,
5459,
5477,
5476,
5451,
5450,
5525,
5526,
5481,
5446,
5493,
5490,
5358,
6485,
4912)
Event ID: 3269
Date: 2017-10-22T11:02:24Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
J'ai gardé les visites pour KIDILIZ les visites qui contenaient des photos
UPDATE mr_visite mvisSET id_visite_type =
(SELECT id_visite_type
FROM mr_visite_type
WHERE libelle_traduit LIKE '%Photos boutique%'
AND mvis.id_distrib_visite = mr_visite_type.id_distrib),
copie_cr_etab = NULL,
envoi_cr_etab = NULL,
envoi_cr_resp = NULL,
usr_modlog = 0,
date_validation =
TO_DATE (
TO_CHAR (NVL (date_visite_fin, date_visite), 'DD/MM/RRRR')
|| ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS'),
usr_moddat =
TO_DATE (TO_CHAR (SYSDATE - 1, 'DD/MM/RRRR') || ' 23:59:59',
'DD/MM/RRRR HH24:MI;SS')
WHERE id_visite IN (5833,
5834,
5850,
5837,
5836,
5839,
5847,
5848,
20985,
1960,
15470,
14709,
14966,
14967,
14688,
13803,
13113,
13115,
12978,
12412,
12330,
12309,
12253,
12169,
11515,
11517,
11518,
11516,
11148,
10319,
10318,
10261,
10094,
9723,
7893,
7891,
7987,
7986,
7985,
15580,
25266,
25363,
25267,
25265,
25264,
25262,
24959,
23450,
21241,
18305,
18693,
18872,
15147,
15148,
15144,
15140,
15141,
15142,
15157,
15145,
14669,
13056,
12863,
12789,
11538,
11244,
10380,
10038,
5638,
5289,
5288,
4965,
2669,
1709,
1234,
1047,
13518,
13497,
13437,
13439,
13430,
12403,
6543,
5808,
26417,
22017,
4348,
23733,
27091,
26907,
26303,
25143,
25313,
25779,
25312,
25490,
25307,
25146,
24497,
24954,
23673,
24958,
23663,
22442,
22738,
22073,
22071,
22074,
20854,
19113,
16396,
16394,
17086,
16032,
15557,
12949,
12861,
26109,
26110,
26107,
24888,
24889,
23882,
23218,
23215,
21714,
21715,
21831,
20735,
19668,
19594,
19593,
19590,
19790,
19589,
19533,
17903,
19534,
19532,
19529,
19531,
19530,
17838,
17839,
17832,
22906,
23599,
13083,
12395,
11211,
11050,
10501,
8348,
4162,
3337,
15836,
15837,
14758,
14757,
7880,
11016,
10992,
9132,
6821,
6759,
4324,
17276,
14971,
3807,
180,
15582,
6502,
6501,
23985,
20021,
19365,
17793,
16681,
2513,
2511,
2512,
12668,
27111,
27110,
20068,
18846,
14579,
14583,
13853,
13819,
8075,
18246,
18735,
13890,
4800,
495,
27794,
27993,
27790,
27789,
27787,
27783,
27786,
27551,
27532,
27533,
26641,
26639,
27278,
26629,
26742,
26631,
25560,
6362,
6359,
21808,
22049,
21674,
18477,
6328,
5237,
5235,
3964,
14681,
24079,
24080,
23324,
21172,
17146,
173)
Event ID: 3268
Date: 2017-10-20T05:58:02Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
55 = Visite sans CR
UPDATE mr_visite
SET id_visite_type = 55, usr_modlog = 6, usr_moddat = SYSDATE
WHERE TO_CHAR (date_validation, 'HH24:MI:SS') = '23:59:00'
AND abandon IS NULL
AND TO_CHAR (NVL (date_visite_fin, date_visite), 'RRRRMMDD') =
TO_CHAR (date_validation, 'RRRRMMDD');
Event ID: 3256
Date: 2017-10-18T06:46:46Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
Event ID: 3255
Date: 2017-10-17T16:46:36Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
IMPORTANT valider les visites d'INGRID
393 visites ont été autovalidées à 23h59
UPDATE mr_visite
SET id_visite_type = NVL (id_visite_type, 42),
date_validation =
TO_DATE (
TO_CHAR (NVL (date_visite_fin, date_visite), 'DD/MM/RRRR')
|| ' 23:59',
'DD/MM/RRRR HH24:MI')
WHERE id_utilisateur IN
(SELECT id_regional
FROM mp_visite_droits mvd
WHERE mvd.responsable = 1 AND id_utilisateur = 186)
AND abandon IS NULL
AND TRUNC (date_visite) < TO_DATE ('01/10/2017')
AND date_validation IS NULL;
Event ID: 3254
Date: 2017-10-16T05:53:08Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist
SELECT mru.id_utilisateur,mru.nom,
mru.prenom,
mru.mail_intranet,
COUNT (*)
FROM mr_visite mvis
JOIN mr_utilisateur mru
ON mru.id_utilisateur = mvis.id_utilisateur
AND EXISTS
(SELECT NULL
FROM mp_etab metab
WHERE metab.id_regional = mru.id_utilisateur)
AND mru.statut_compte = 1
WHERE mvis.date_validation IS NULL
AND TRUNC (mvis.date_visite) BETWEEN TO_DATE ('01/01/2016',
'DD/MM/RRRR')
AND TRUNC (SYSDATE) - 30
AND mvis.abandon IS NULL
GROUP BY mru.id_utilisateur,
mru.nom,
mru.prenom,
mru.mail_intranet
ORDER BY COUNT (*) DESC
Event ID: 3253
Date: 2017-10-16T05:52:43Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist
Event ID: 3252
Date: 2017-10-16T05:52:43Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist