@@ -101,16 +101,24 @@ |
||
101 | 101 | $nbLinks=Link::count($db, $object->element, $object->id); |
102 | 102 | $head[$h][0] = DOL_URL_ROOT.'/asset/document.php?id='.$object->id; |
103 | 103 | $head[$h][1] = $langs->trans('Documents'); |
104 | - if (($nbFiles+$nbLinks) > 0) $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
104 | + if (($nbFiles+$nbLinks) > 0) { |
|
105 | + $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
106 | + } |
|
105 | 107 | $head[$h][2] = 'documents'; |
106 | 108 | $h++; |
107 | 109 | |
108 | 110 | $nbNote = 0; |
109 | - if(!empty($object->note_private)) $nbNote++; |
|
110 | - if(!empty($object->note_public)) $nbNote++; |
|
111 | + if(!empty($object->note_private)) { |
|
112 | + $nbNote++; |
|
113 | + } |
|
114 | + if(!empty($object->note_public)) { |
|
115 | + $nbNote++; |
|
116 | + } |
|
111 | 117 | $head[$h][0] = DOL_URL_ROOT.'/asset/note.php?id='.$object->id; |
112 | 118 | $head[$h][1] = $langs->trans("Notes"); |
113 | - if ($nbNote > 0) $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
119 | + if ($nbNote > 0) { |
|
120 | + $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
121 | + } |
|
114 | 122 | $head[$h][2] = 'note'; |
115 | 123 | $h++; |
116 | 124 |
@@ -54,7 +54,9 @@ |
||
54 | 54 | $nbLinks=Link::count($db, $object->element, $object->id); |
55 | 55 | $head[$tab][0] = DOL_URL_ROOT.'/compta/tva/document.php?id='.$object->id; |
56 | 56 | $head[$tab][1] = $langs->trans("Documents"); |
57 | - if (($nbFiles+$nbLinks) > 0) $head[$tab][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
57 | + if (($nbFiles+$nbLinks) > 0) { |
|
58 | + $head[$tab][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
59 | + } |
|
58 | 60 | $head[$tab][2] = 'documents'; |
59 | 61 | $tab++; |
60 | 62 |
@@ -85,16 +85,24 @@ |
||
85 | 85 | $nbLinks=Link::count($db, $object->element, $object->id); |
86 | 86 | $head[$h][0] = DOL_URL_ROOT.'/don/document.php?id='.$object->id; |
87 | 87 | $head[$h][1] = $langs->trans('Documents'); |
88 | - if (($nbFiles+$nbLinks) > 0) $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
88 | + if (($nbFiles+$nbLinks) > 0) { |
|
89 | + $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
90 | + } |
|
89 | 91 | $head[$h][2] = 'documents'; |
90 | 92 | $h++; |
91 | 93 | |
92 | 94 | $nbNote = 0; |
93 | - if(!empty($object->note_private)) $nbNote++; |
|
94 | - if(!empty($object->note_public)) $nbNote++; |
|
95 | + if(!empty($object->note_private)) { |
|
96 | + $nbNote++; |
|
97 | + } |
|
98 | + if(!empty($object->note_public)) { |
|
99 | + $nbNote++; |
|
100 | + } |
|
95 | 101 | $head[$h][0] = DOL_URL_ROOT.'/don/note.php?id='.$object->id; |
96 | 102 | $head[$h][1] = $langs->trans("Notes"); |
97 | - if ($nbNote > 0) $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
103 | + if ($nbNote > 0) { |
|
104 | + $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
105 | + } |
|
98 | 106 | $head[$h][2] = 'note'; |
99 | 107 | $h++; |
100 | 108 |
@@ -48,7 +48,9 @@ discard block |
||
48 | 48 | $nbContact = count($object->liste_contact(-1,'internal')) + count($object->liste_contact(-1,'external')); |
49 | 49 | $head[$h][0] = DOL_URL_ROOT.'/projet/contact.php?id='.$object->id; |
50 | 50 | $head[$h][1] = $langs->trans("ProjectContact"); |
51 | - if ($nbContact > 0) $head[$h][1].= ' <span class="badge">'.$nbContact.'</span>'; |
|
51 | + if ($nbContact > 0) { |
|
52 | + $head[$h][1].= ' <span class="badge">'.$nbContact.'</span>'; |
|
53 | + } |
|
52 | 54 | $head[$h][2] = 'contact'; |
53 | 55 | $h++; |
54 | 56 | |
@@ -61,7 +63,9 @@ discard block |
||
61 | 63 | require_once DOL_DOCUMENT_ROOT.'/projet/class/task.class.php'; |
62 | 64 | $taskstatic=new Task($db); |
63 | 65 | $nbTasks=count($taskstatic->getTasksArray(0, 0, $object->id, 0, 0)); |
64 | - if ($nbTasks > 0) $head[$h][1].= ' <span class="badge">'.($nbTasks).'</span>'; |
|
66 | + if ($nbTasks > 0) { |
|
67 | + $head[$h][1].= ' <span class="badge">'.($nbTasks).'</span>'; |
|
68 | + } |
|
65 | 69 | $head[$h][2] = 'tasks'; |
66 | 70 | $h++; |
67 | 71 | |
@@ -76,13 +80,18 @@ discard block |
||
76 | 80 | if ($resql) |
77 | 81 | { |
78 | 82 | $obj = $db->fetch_object($resql); |
79 | - if ($obj) $nbTimeSpent=1; |
|
83 | + if ($obj) { |
|
84 | + $nbTimeSpent=1; |
|
85 | + } |
|
86 | + } else { |
|
87 | + dol_print_error($db); |
|
80 | 88 | } |
81 | - else dol_print_error($db); |
|
82 | 89 | |
83 | 90 | $head[$h][0] = DOL_URL_ROOT.'/projet/tasks/time.php?withproject=1&projectid='.$object->id; |
84 | 91 | $head[$h][1] = $langs->trans("TimeSpent"); |
85 | - if ($nbTimeSpent > 0) $head[$h][1].= ' <span class="badge">...</span>'; |
|
92 | + if ($nbTimeSpent > 0) { |
|
93 | + $head[$h][1].= ' <span class="badge">...</span>'; |
|
94 | + } |
|
86 | 95 | $head[$h][2] = 'timespent'; |
87 | 96 | $h++; |
88 | 97 | } |
@@ -107,11 +116,17 @@ discard block |
||
107 | 116 | if (empty($conf->global->MAIN_DISABLE_NOTES_TAB)) |
108 | 117 | { |
109 | 118 | $nbNote = 0; |
110 | - if(!empty($object->note_private)) $nbNote++; |
|
111 | - if(!empty($object->note_public)) $nbNote++; |
|
119 | + if(!empty($object->note_private)) { |
|
120 | + $nbNote++; |
|
121 | + } |
|
122 | + if(!empty($object->note_public)) { |
|
123 | + $nbNote++; |
|
124 | + } |
|
112 | 125 | $head[$h][0] = DOL_URL_ROOT.'/projet/note.php?id='.$object->id; |
113 | 126 | $head[$h][1] = $langs->trans('Notes'); |
114 | - if ($nbNote > 0) $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
127 | + if ($nbNote > 0) { |
|
128 | + $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
129 | + } |
|
115 | 130 | $head[$h][2] = 'notes'; |
116 | 131 | $h++; |
117 | 132 | } |
@@ -123,7 +138,9 @@ discard block |
||
123 | 138 | $nbLinks=Link::count($db, $object->element, $object->id); |
124 | 139 | $head[$h][0] = DOL_URL_ROOT.'/projet/document.php?id='.$object->id; |
125 | 140 | $head[$h][1] = $langs->trans('Documents'); |
126 | - if (($nbFiles+$nbLinks) > 0) $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
141 | + if (($nbFiles+$nbLinks) > 0) { |
|
142 | + $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
143 | + } |
|
127 | 144 | $head[$h][2] = 'document'; |
128 | 145 | $h++; |
129 | 146 | |
@@ -133,7 +150,9 @@ discard block |
||
133 | 150 | $nbComments = $object->getNbComments(); |
134 | 151 | $head[$h][0] = DOL_URL_ROOT.'/projet/comment.php?id='.$object->id; |
135 | 152 | $head[$h][1] = $langs->trans("CommentLink"); |
136 | - if ($nbComments > 0) $head[$h][1].= ' <span class="badge">'.$nbComments.'</span>'; |
|
153 | + if ($nbComments > 0) { |
|
154 | + $head[$h][1].= ' <span class="badge">'.$nbComments.'</span>'; |
|
155 | + } |
|
137 | 156 | $head[$h][2] = 'project_comment'; |
138 | 157 | $h++; |
139 | 158 | } |
@@ -174,7 +193,9 @@ discard block |
||
174 | 193 | $nbContact = count($object->liste_contact(-1,'internal')) + count($object->liste_contact(-1,'external')); |
175 | 194 | $head[$h][0] = DOL_URL_ROOT.'/projet/tasks/contact.php?id='.$object->id.(GETPOST('withproject')?'&withproject=1':''); |
176 | 195 | $head[$h][1] = $langs->trans("TaskRessourceLinks"); |
177 | - if ($nbContact > 0) $head[$h][1].= ' <span class="badge">'.$nbContact.'</span>'; |
|
196 | + if ($nbContact > 0) { |
|
197 | + $head[$h][1].= ' <span class="badge">'.$nbContact.'</span>'; |
|
198 | + } |
|
178 | 199 | $head[$h][2] = 'task_contact'; |
179 | 200 | $h++; |
180 | 201 | |
@@ -189,13 +210,18 @@ discard block |
||
189 | 210 | if ($resql) |
190 | 211 | { |
191 | 212 | $obj = $db->fetch_object($resql); |
192 | - if ($obj) $nbTimeSpent=1; |
|
213 | + if ($obj) { |
|
214 | + $nbTimeSpent=1; |
|
215 | + } |
|
216 | + } else { |
|
217 | + dol_print_error($db); |
|
193 | 218 | } |
194 | - else dol_print_error($db); |
|
195 | 219 | |
196 | 220 | $head[$h][0] = DOL_URL_ROOT.'/projet/tasks/time.php?id='.$object->id.(GETPOST('withproject')?'&withproject=1':''); |
197 | 221 | $head[$h][1] = $langs->trans("TimeSpent"); |
198 | - if ($nbTimeSpent > 0) $head[$h][1].= ' <span class="badge">...</span>'; |
|
222 | + if ($nbTimeSpent > 0) { |
|
223 | + $head[$h][1].= ' <span class="badge">...</span>'; |
|
224 | + } |
|
199 | 225 | $head[$h][2] = 'task_time'; |
200 | 226 | $h++; |
201 | 227 | |
@@ -208,11 +234,17 @@ discard block |
||
208 | 234 | if (empty($conf->global->MAIN_DISABLE_NOTES_TAB)) |
209 | 235 | { |
210 | 236 | $nbNote = 0; |
211 | - if(!empty($object->note_private)) $nbNote++; |
|
212 | - if(!empty($object->note_public)) $nbNote++; |
|
237 | + if(!empty($object->note_private)) { |
|
238 | + $nbNote++; |
|
239 | + } |
|
240 | + if(!empty($object->note_public)) { |
|
241 | + $nbNote++; |
|
242 | + } |
|
213 | 243 | $head[$h][0] = DOL_URL_ROOT.'/projet/tasks/note.php?id='.$object->id.(GETPOST('withproject')?'&withproject=1':''); |
214 | 244 | $head[$h][1] = $langs->trans('Notes'); |
215 | - if ($nbNote > 0) $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
245 | + if ($nbNote > 0) { |
|
246 | + $head[$h][1].= ' <span class="badge">'.$nbNote.'</span>'; |
|
247 | + } |
|
216 | 248 | $head[$h][2] = 'task_notes'; |
217 | 249 | $h++; |
218 | 250 | } |
@@ -224,7 +256,9 @@ discard block |
||
224 | 256 | $nbFiles = count(dol_dir_list($filesdir,'files',0,'','(\.meta|_preview.*\.png)$')); |
225 | 257 | $nbLinks=Link::count($db, $object->element, $object->id); |
226 | 258 | $head[$h][1] = $langs->trans('Documents'); |
227 | - if (($nbFiles+$nbLinks) > 0) $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
259 | + if (($nbFiles+$nbLinks) > 0) { |
|
260 | + $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
261 | + } |
|
228 | 262 | $head[$h][2] = 'task_document'; |
229 | 263 | $h++; |
230 | 264 | |
@@ -234,7 +268,9 @@ discard block |
||
234 | 268 | $nbComments = $object->getNbComments(); |
235 | 269 | $head[$h][0] = DOL_URL_ROOT.'/projet/tasks/comment.php?id='.$object->id.(GETPOST('withproject')?'&withproject=1':''); |
236 | 270 | $head[$h][1] = $langs->trans("CommentLink"); |
237 | - if ($nbComments > 0) $head[$h][1].= ' <span class="badge">'.$nbComments.'</span>'; |
|
271 | + if ($nbComments > 0) { |
|
272 | + $head[$h][1].= ' <span class="badge">'.$nbComments.'</span>'; |
|
273 | + } |
|
238 | 274 | $head[$h][2] = 'task_comment'; |
239 | 275 | $h++; |
240 | 276 | } |
@@ -261,7 +297,9 @@ discard block |
||
261 | 297 | |
262 | 298 | $param=''; |
263 | 299 | $param.=($mode?'&mode='.$mode:''); |
264 | - if (is_object($fuser) && $fuser->id > 0 && $fuser->id != $user->id) $param.='&search_usertoprocessid='.$fuser->id; |
|
300 | + if (is_object($fuser) && $fuser->id > 0 && $fuser->id != $user->id) { |
|
301 | + $param.='&search_usertoprocessid='.$fuser->id; |
|
302 | + } |
|
265 | 303 | |
266 | 304 | if (empty($conf->global->PROJECT_DISABLE_TIMESHEET_PERWEEK)) |
267 | 305 | { |
@@ -380,15 +418,20 @@ discard block |
||
380 | 418 | |
381 | 419 | for ($i = 0 ; $i < $numlines ; $i++) |
382 | 420 | { |
383 | - if ($parent == 0 && $level >= 0) $level = 0; // if $level = -1, we dont' use sublevel recursion, we show all lines |
|
421 | + if ($parent == 0 && $level >= 0) { |
|
422 | + $level = 0; |
|
423 | + } |
|
424 | + // if $level = -1, we dont' use sublevel recursion, we show all lines |
|
384 | 425 | |
385 | 426 | // Process line |
386 | 427 | // print "i:".$i."-".$lines[$i]->fk_project.'<br>'; |
387 | 428 | |
388 | - if ($lines[$i]->fk_parent == $parent || $level < 0) // if $level = -1, we dont' use sublevel recursion, we show all lines |
|
429 | + if ($lines[$i]->fk_parent == $parent || $level < 0) { |
|
430 | + // if $level = -1, we dont' use sublevel recursion, we show all lines |
|
389 | 431 | { |
390 | 432 | // Show task line. |
391 | 433 | $showline=1; |
434 | + } |
|
392 | 435 | $showlineingray=0; |
393 | 436 | |
394 | 437 | // If there is filters to use |
@@ -404,14 +447,12 @@ discard block |
||
404 | 447 | if ($foundtaskforuserdeeper > 0) |
405 | 448 | { |
406 | 449 | $showlineingray=1; // We will show line but in gray |
407 | - } |
|
408 | - else |
|
450 | + } else |
|
409 | 451 | { |
410 | 452 | $showline=0; // No reason to show line |
411 | 453 | } |
412 | 454 | } |
413 | - } |
|
414 | - else |
|
455 | + } else |
|
415 | 456 | { |
416 | 457 | // Caller did not ask to filter on tasks of a specific user (this probably means he want also tasks of all users, into public project |
417 | 458 | // or into all other projects if user has permission to). |
@@ -448,8 +489,11 @@ discard block |
||
448 | 489 | $projectstatic->ref=$lines[$i]->projectref; |
449 | 490 | $projectstatic->public=$lines[$i]->public; |
450 | 491 | $projectstatic->title=$lines[$i]->projectlabel; |
451 | - if ($lines[$i]->public || in_array($lines[$i]->fk_project,$projectsArrayId) || ! empty($user->rights->projet->all->lire)) print $projectstatic->getNomUrl(1); |
|
452 | - else print $projectstatic->getNomUrl(1,'nolink'); |
|
492 | + if ($lines[$i]->public || in_array($lines[$i]->fk_project,$projectsArrayId) || ! empty($user->rights->projet->all->lire)) { |
|
493 | + print $projectstatic->getNomUrl(1); |
|
494 | + } else { |
|
495 | + print $projectstatic->getNomUrl(1,'nolink'); |
|
496 | + } |
|
453 | 497 | //if ($showlineingray) print '</i>'; |
454 | 498 | print "</td>"; |
455 | 499 | |
@@ -465,8 +509,7 @@ discard block |
||
465 | 509 | if ($showlineingray) |
466 | 510 | { |
467 | 511 | print '<i>'.img_object('','projecttask').' '.$lines[$i]->ref.'</i>'; |
468 | - } |
|
469 | - else |
|
512 | + } else |
|
470 | 513 | { |
471 | 514 | $taskstatic->id=$lines[$i]->id; |
472 | 515 | $taskstatic->ref=$lines[$i]->ref; |
@@ -477,14 +520,18 @@ discard block |
||
477 | 520 | |
478 | 521 | // Title of task |
479 | 522 | print "<td>"; |
480 | - if ($showlineingray) print '<i>'; |
|
523 | + if ($showlineingray) { |
|
524 | + print '<i>'; |
|
525 | + } |
|
481 | 526 | //else print '<a href="'.DOL_URL_ROOT.'/projet/tasks/task.php?id='.$lines[$i]->id.'&withproject=1">'; |
482 | 527 | for ($k = 0 ; $k < $level ; $k++) |
483 | 528 | { |
484 | 529 | print " "; |
485 | 530 | } |
486 | 531 | print $lines[$i]->label; |
487 | - if ($showlineingray) print '</i>'; |
|
532 | + if ($showlineingray) { |
|
533 | + print '</i>'; |
|
534 | + } |
|
488 | 535 | //else print '</a>'; |
489 | 536 | print "</td>\n"; |
490 | 537 | |
@@ -500,13 +547,19 @@ discard block |
||
500 | 547 | $taskstatic->fk_statut = $lines[$i]->status; |
501 | 548 | $taskstatic->datee = $lines[$i]->date_end; |
502 | 549 | print dol_print_date($lines[$i]->date_end,'dayhour'); |
503 | - if ($taskstatic->hasDelay()) print img_warning($langs->trans("Late")); |
|
550 | + if ($taskstatic->hasDelay()) { |
|
551 | + print img_warning($langs->trans("Late")); |
|
552 | + } |
|
504 | 553 | print '</td>'; |
505 | 554 | |
506 | 555 | $plannedworkloadoutputformat='allhourmin'; |
507 | 556 | $timespentoutputformat='allhourmin'; |
508 | - if (! empty($conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT)) $plannedworkloadoutputformat=$conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT; |
|
509 | - if (! empty($conf->global->PROJECT_TIMES_SPENT_FORMAT)) $timespentoutputformat=$conf->global->PROJECT_TIME_SPENT_FORMAT; |
|
557 | + if (! empty($conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT)) { |
|
558 | + $plannedworkloadoutputformat=$conf->global->PROJECT_PLANNED_WORKLOAD_FORMAT; |
|
559 | + } |
|
560 | + if (! empty($conf->global->PROJECT_TIMES_SPENT_FORMAT)) { |
|
561 | + $timespentoutputformat=$conf->global->PROJECT_TIME_SPENT_FORMAT; |
|
562 | + } |
|
510 | 563 | |
511 | 564 | // Planned Workload (in working hours) |
512 | 565 | print '<td align="right">'; |
@@ -523,20 +576,32 @@ discard block |
||
523 | 576 | |
524 | 577 | // Time spent |
525 | 578 | print '<td align="right">'; |
526 | - if ($showlineingray) print '<i>'; |
|
527 | - else print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?id='.$lines[$i]->id.($showproject?'':'&withproject=1').'">'; |
|
528 | - if ($lines[$i]->duration) print convertSecondToTime($lines[$i]->duration,$timespentoutputformat); |
|
529 | - else print '--:--'; |
|
530 | - if ($showlineingray) print '</i>'; |
|
531 | - else print '</a>'; |
|
579 | + if ($showlineingray) { |
|
580 | + print '<i>'; |
|
581 | + } else { |
|
582 | + print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?id='.$lines[$i]->id.($showproject?'':'&withproject=1').'">'; |
|
583 | + } |
|
584 | + if ($lines[$i]->duration) { |
|
585 | + print convertSecondToTime($lines[$i]->duration,$timespentoutputformat); |
|
586 | + } else { |
|
587 | + print '--:--'; |
|
588 | + } |
|
589 | + if ($showlineingray) { |
|
590 | + print '</i>'; |
|
591 | + } else { |
|
592 | + print '</a>'; |
|
593 | + } |
|
532 | 594 | print '</td>'; |
533 | 595 | |
534 | 596 | // Progress calculated (Note: ->duration is time spent) |
535 | 597 | print '<td align="right">'; |
536 | 598 | if ($lines[$i]->planned_workload || $lines[$i]->duration) |
537 | 599 | { |
538 | - if ($lines[$i]->planned_workload) print round(100 * $lines[$i]->duration / $lines[$i]->planned_workload,2).' %'; |
|
539 | - else print '<span class="opacitymedium">'.$langs->trans('WorkloadNotDefined').'</span>'; |
|
600 | + if ($lines[$i]->planned_workload) { |
|
601 | + print round(100 * $lines[$i]->duration / $lines[$i]->planned_workload,2).' %'; |
|
602 | + } else { |
|
603 | + print '<span class="opacitymedium">'.$langs->trans('WorkloadNotDefined').'</span>'; |
|
604 | + } |
|
540 | 605 | } |
541 | 606 | print '</td>'; |
542 | 607 | |
@@ -559,8 +624,11 @@ discard block |
||
559 | 624 | if (!empty($num)){ |
560 | 625 | foreach ($tab as $contacttask){ |
561 | 626 | //var_dump($contacttask); |
562 | - if ($source == 'internal') $c = new User($db); |
|
563 | - else $c = new Contact($db); |
|
627 | + if ($source == 'internal') { |
|
628 | + $c = new User($db); |
|
629 | + } else { |
|
630 | + $c = new Contact($db); |
|
631 | + } |
|
564 | 632 | $c->fetch($contacttask['id']); |
565 | 633 | print $c->getNomUrl(1) . ' (' . $contacttask['libelle'] . ')' . '<br>'; |
566 | 634 | } |
@@ -577,21 +645,28 @@ discard block |
||
577 | 645 | |
578 | 646 | print "</tr>\n"; |
579 | 647 | |
580 | - if (! $showlineingray) $inc++; |
|
648 | + if (! $showlineingray) { |
|
649 | + $inc++; |
|
650 | + } |
|
581 | 651 | |
582 | - if ($level >= 0) // Call sublevels |
|
652 | + if ($level >= 0) { |
|
653 | + // Call sublevels |
|
583 | 654 | { |
584 | 655 | $level++; |
585 | - if ($lines[$i]->id) projectLinesa($inc, $lines[$i]->id, $lines, $level, $var, $showproject, $taskrole, $projectsListId, $addordertick); |
|
656 | + } |
|
657 | + if ($lines[$i]->id) { |
|
658 | + projectLinesa($inc, $lines[$i]->id, $lines, $level, $var, $showproject, $taskrole, $projectsListId, $addordertick); |
|
659 | + } |
|
586 | 660 | $level--; |
587 | 661 | } |
588 | 662 | |
589 | 663 | $total_projectlinesa_spent += $lines[$i]->duration; |
590 | 664 | $total_projectlinesa_planned += $lines[$i]->planned_workload; |
591 | - if ($lines[$i]->planned_workload) $total_projectlinesa_spent_if_planned += $lines[$i]->duration; |
|
665 | + if ($lines[$i]->planned_workload) { |
|
666 | + $total_projectlinesa_spent_if_planned += $lines[$i]->duration; |
|
667 | + } |
|
592 | 668 | } |
593 | - } |
|
594 | - else |
|
669 | + } else |
|
595 | 670 | { |
596 | 671 | //$level--; |
597 | 672 | } |
@@ -601,7 +676,9 @@ discard block |
||
601 | 676 | { |
602 | 677 | print '<tr class="liste_total nodrag nodrop">'; |
603 | 678 | print '<td class="liste_total">'.$langs->trans("Total").'</td>'; |
604 | - if ($showproject) print '<td></td><td></td>'; |
|
679 | + if ($showproject) { |
|
680 | + print '<td></td><td></td>'; |
|
681 | + } |
|
605 | 682 | print '<td></td>'; |
606 | 683 | print '<td></td>'; |
607 | 684 | print '<td></td>'; |
@@ -609,12 +686,18 @@ discard block |
||
609 | 686 | print convertSecondToTime($total_projectlinesa_planned, 'allhourmin'); |
610 | 687 | print '</td>'; |
611 | 688 | print '<td align="right" class="nowrap liste_total">'; |
612 | - if ($projectidfortotallink > 0) print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?projectid='.$projectidfortotallink.($showproject?'':'&withproject=1').'">'; |
|
689 | + if ($projectidfortotallink > 0) { |
|
690 | + print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?projectid='.$projectidfortotallink.($showproject?'':'&withproject=1').'">'; |
|
691 | + } |
|
613 | 692 | print convertSecondToTime($total_projectlinesa_spent, 'allhourmin'); |
614 | - if ($projectidfortotallink > 0) print '</a>'; |
|
693 | + if ($projectidfortotallink > 0) { |
|
694 | + print '</a>'; |
|
695 | + } |
|
615 | 696 | print '</td>'; |
616 | 697 | print '<td align="right" class="nowrap liste_total">'; |
617 | - if ($total_projectlinesa_planned) print round(100 * $total_projectlinesa_spent / $total_projectlinesa_planned,2).' %'; |
|
698 | + if ($total_projectlinesa_planned) { |
|
699 | + print round(100 * $total_projectlinesa_spent / $total_projectlinesa_planned,2).' %'; |
|
700 | + } |
|
618 | 701 | print '</td>'; |
619 | 702 | print '<td></td>'; |
620 | 703 | // Contacts of task |
@@ -622,7 +705,9 @@ discard block |
||
622 | 705 | { |
623 | 706 | print '<td></td>'; |
624 | 707 | } |
625 | - if ($addordertick) print '<td class="hideonsmartphone"></td>'; |
|
708 | + if ($addordertick) { |
|
709 | + print '<td class="hideonsmartphone"></td>'; |
|
710 | + } |
|
626 | 711 | print '</tr>'; |
627 | 712 | } |
628 | 713 | |
@@ -660,11 +745,16 @@ discard block |
||
660 | 745 | $numlines=count($lines); |
661 | 746 | |
662 | 747 | // Create a smaller array with sublevels only to be used later. This increase dramatically performances. |
663 | - if ($parent == 0) // Always and only if at first level |
|
748 | + if ($parent == 0) { |
|
749 | + // Always and only if at first level |
|
664 | 750 | { |
665 | - for ($i = 0 ; $i < $numlines ; $i++) |
|
751 | + for ($i = 0 ; |
|
752 | + } |
|
753 | + $i < $numlines ; $i++) |
|
666 | 754 | { |
667 | - if ($lines[$i]->fk_task_parent) $lineswithoutlevel0[]=$lines[$i]; |
|
755 | + if ($lines[$i]->fk_task_parent) { |
|
756 | + $lineswithoutlevel0[]=$lines[$i]; |
|
757 | + } |
|
668 | 758 | } |
669 | 759 | } |
670 | 760 | |
@@ -676,7 +766,9 @@ discard block |
||
676 | 766 | //dol_syslog('projectLinesPerDay inc='.$inc.' preselectedday='.$preselectedday.' task parent id='.$parent.' level='.$level." count(lines)=".$numlines." count(lineswithoutlevel0)=".count($lineswithoutlevel0)); |
677 | 767 | for ($i = 0 ; $i < $numlines ; $i++) |
678 | 768 | { |
679 | - if ($parent == 0) $level = 0; |
|
769 | + if ($parent == 0) { |
|
770 | + $level = 0; |
|
771 | + } |
|
680 | 772 | |
681 | 773 | //if ($lines[$i]->fk_task_parent == $parent) |
682 | 774 | //{ |
@@ -733,7 +825,9 @@ discard block |
||
733 | 825 | print '</tr>'; |
734 | 826 | } |
735 | 827 | |
736 | - if ($oldprojectforbreak != -1) $oldprojectforbreak = $projectstatic->id; |
|
828 | + if ($oldprojectforbreak != -1) { |
|
829 | + $oldprojectforbreak = $projectstatic->id; |
|
830 | + } |
|
737 | 831 | |
738 | 832 | print '<tr class="oddeven">'."\n"; |
739 | 833 | |
@@ -755,17 +849,23 @@ discard block |
||
755 | 849 | |
756 | 850 | // Thirdparty |
757 | 851 | print '<td class="tdoverflowmax100">'; |
758 | - if ($thirdpartystatic->id > 0) print $thirdpartystatic->getNomUrl(1, 'project', 10); |
|
852 | + if ($thirdpartystatic->id > 0) { |
|
853 | + print $thirdpartystatic->getNomUrl(1, 'project', 10); |
|
854 | + } |
|
759 | 855 | print '</td>'; |
760 | 856 | |
761 | 857 | // Ref |
762 | 858 | print '<td>'; |
763 | 859 | print '<!-- Task id = '.$lines[$i]->id.' -->'; |
764 | - for ($k = 0 ; $k < $level ; $k++) print " "; |
|
860 | + for ($k = 0 ; $k < $level ; $k++) { |
|
861 | + print " "; |
|
862 | + } |
|
765 | 863 | print $taskstatic->getNomUrl(1, 'withproject', 'time'); |
766 | 864 | // Label task |
767 | 865 | print '<br>'; |
768 | - for ($k = 0 ; $k < $level ; $k++) print " "; |
|
866 | + for ($k = 0 ; $k < $level ; $k++) { |
|
867 | + print " "; |
|
868 | + } |
|
769 | 869 | print $taskstatic->label; |
770 | 870 | //print "<br>"; |
771 | 871 | //for ($k = 0 ; $k < $level ; $k++) print " "; |
@@ -799,9 +899,13 @@ discard block |
||
799 | 899 | print '</td>'; |
800 | 900 | |
801 | 901 | $cssonholiday=''; |
802 | - if (! $isavailable[$preselectedday]['morning'] && ! $isavailable[$preselectedday]['afternoon']) $cssonholiday.='onholidayallday '; |
|
803 | - elseif (! $isavailable[$preselectedday]['morning']) $cssonholiday.='onholidaymorning '; |
|
804 | - elseif (! $isavailable[$preselectedday]['afternoon']) $cssonholiday.='onholidayafternoon '; |
|
902 | + if (! $isavailable[$preselectedday]['morning'] && ! $isavailable[$preselectedday]['afternoon']) { |
|
903 | + $cssonholiday.='onholidayallday '; |
|
904 | + } elseif (! $isavailable[$preselectedday]['morning']) { |
|
905 | + $cssonholiday.='onholidaymorning '; |
|
906 | + } elseif (! $isavailable[$preselectedday]['afternoon']) { |
|
907 | + $cssonholiday.='onholidayafternoon '; |
|
908 | + } |
|
805 | 909 | |
806 | 910 | // Duration |
807 | 911 | print '<td align="center" class="duration'.($cssonholiday?' '.$cssonholiday:'').'">'; |
@@ -810,7 +914,9 @@ discard block |
||
810 | 914 | $totalforeachline[$preselectedday]+=$lines[$i]->timespent_duration; |
811 | 915 | |
812 | 916 | $alreadyspent=''; |
813 | - if ($dayWorkLoad > 0) $alreadyspent=convertSecondToTime($lines[$i]->timespent_duration,'allhourmin'); |
|
917 | + if ($dayWorkLoad > 0) { |
|
918 | + $alreadyspent=convertSecondToTime($lines[$i]->timespent_duration,'allhourmin'); |
|
919 | + } |
|
814 | 920 | |
815 | 921 | print convertSecondToTime($lines[$i]->timespent_duration,'allhourmin'); |
816 | 922 | |
@@ -886,11 +992,16 @@ discard block |
||
886 | 992 | $numlines=count($lines); |
887 | 993 | |
888 | 994 | // Create a smaller array with sublevels only to be used later. This increase dramatically performances. |
889 | - if ($parent == 0) // Always and only if at first level |
|
995 | + if ($parent == 0) { |
|
996 | + // Always and only if at first level |
|
890 | 997 | { |
891 | - for ($i = 0 ; $i < $numlines ; $i++) |
|
998 | + for ($i = 0 ; |
|
999 | + } |
|
1000 | + $i < $numlines ; $i++) |
|
892 | 1001 | { |
893 | - if ($lines[$i]->fk_task_parent) $lineswithoutlevel0[]=$lines[$i]; |
|
1002 | + if ($lines[$i]->fk_task_parent) { |
|
1003 | + $lineswithoutlevel0[]=$lines[$i]; |
|
1004 | + } |
|
894 | 1005 | } |
895 | 1006 | } |
896 | 1007 | |
@@ -902,7 +1013,9 @@ discard block |
||
902 | 1013 | //dol_syslog('projectLinesPerDay inc='.$inc.' preselectedday='.$preselectedday.' task parent id='.$parent.' level='.$level." count(lines)=".$numlines." count(lineswithoutlevel0)=".count($lineswithoutlevel0)); |
903 | 1014 | for ($i = 0 ; $i < $numlines ; $i++) |
904 | 1015 | { |
905 | - if ($parent == 0) $level = 0; |
|
1016 | + if ($parent == 0) { |
|
1017 | + $level = 0; |
|
1018 | + } |
|
906 | 1019 | |
907 | 1020 | if ($lines[$i]->fk_task_parent == $parent) |
908 | 1021 | { |
@@ -911,10 +1024,12 @@ discard block |
||
911 | 1024 | { |
912 | 1025 | //dol_syslog("projectLinesPerWeek Found line ".$i.", a qualified task (i have role or want to show all tasks) with id=".$lines[$i]->id." project id=".$lines[$i]->fk_project); |
913 | 1026 | |
914 | - if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->id])) // we have no role on task and we request to hide such cases |
|
1027 | + if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->id])) { |
|
1028 | + // we have no role on task and we request to hide such cases |
|
915 | 1029 | { |
916 | 1030 | continue; |
917 | 1031 | } |
1032 | + } |
|
918 | 1033 | |
919 | 1034 | // Break on a new project |
920 | 1035 | if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) |
@@ -955,7 +1070,9 @@ discard block |
||
955 | 1070 | print '<tr class="oddeven trforbreak">'."\n"; |
956 | 1071 | print '<td colspan="9">'; |
957 | 1072 | print $projectstatic->getNomUrl(1,'',0,'<strong>'.$langs->transnoentitiesnoconv("YourRole").':</strong> '.$projectsrole[$lines[$i]->fk_project]); |
958 | - if ($thirdpartystatic->id > 0) print ' - '.$thirdpartystatic->getNomUrl(1); |
|
1073 | + if ($thirdpartystatic->id > 0) { |
|
1074 | + print ' - '.$thirdpartystatic->getNomUrl(1); |
|
1075 | + } |
|
959 | 1076 | if ($projectstatic->title) |
960 | 1077 | { |
961 | 1078 | print ' - '; |
@@ -965,7 +1082,9 @@ discard block |
||
965 | 1082 | print '</tr>'; |
966 | 1083 | } |
967 | 1084 | |
968 | - if ($oldprojectforbreak != -1) $oldprojectforbreak = $projectstatic->id; |
|
1085 | + if ($oldprojectforbreak != -1) { |
|
1086 | + $oldprojectforbreak = $projectstatic->id; |
|
1087 | + } |
|
969 | 1088 | |
970 | 1089 | print '<tr class="oddeven">'."\n"; |
971 | 1090 | |
@@ -989,11 +1108,15 @@ discard block |
||
989 | 1108 | // Ref |
990 | 1109 | print '<td>'; |
991 | 1110 | print '<!-- Task id = '.$lines[$i]->id.' -->'; |
992 | - for ($k = 0 ; $k < $level ; $k++) print " "; |
|
1111 | + for ($k = 0 ; $k < $level ; $k++) { |
|
1112 | + print " "; |
|
1113 | + } |
|
993 | 1114 | print $taskstatic->getNomUrl(1, 'withproject', 'time'); |
994 | 1115 | // Label task |
995 | 1116 | print '<br>'; |
996 | - for ($k = 0 ; $k < $level ; $k++) print " "; |
|
1117 | + for ($k = 0 ; $k < $level ; $k++) { |
|
1118 | + print " "; |
|
1119 | + } |
|
997 | 1120 | print $taskstatic->label; |
998 | 1121 | //print "<br>"; |
999 | 1122 | //for ($k = 0 ; $k < $level ; $k++) print " "; |
@@ -1002,8 +1125,11 @@ discard block |
||
1002 | 1125 | |
1003 | 1126 | // Planned Workload |
1004 | 1127 | print '<td align="right" class="leftborder plannedworkload">'; |
1005 | - if ($lines[$i]->planned_workload) print convertSecondToTime($lines[$i]->planned_workload,'allhourmin'); |
|
1006 | - else print '--:--'; |
|
1128 | + if ($lines[$i]->planned_workload) { |
|
1129 | + print convertSecondToTime($lines[$i]->planned_workload,'allhourmin'); |
|
1130 | + } else { |
|
1131 | + print '--:--'; |
|
1132 | + } |
|
1007 | 1133 | print '</td>'; |
1008 | 1134 | |
1009 | 1135 | // Progress declared % |
@@ -1019,15 +1145,19 @@ discard block |
||
1019 | 1145 | print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?id='.$lines[$i]->id.'">'; |
1020 | 1146 | print convertSecondToTime($lines[$i]->duration,'allhourmin'); |
1021 | 1147 | print '</a>'; |
1148 | + } else { |
|
1149 | + print '--:--'; |
|
1022 | 1150 | } |
1023 | - else print '--:--'; |
|
1024 | 1151 | print "</td>\n"; |
1025 | 1152 | |
1026 | 1153 | // Time spent by user |
1027 | 1154 | print '<td align="right">'; |
1028 | 1155 | $tmptimespent=$taskstatic->getSummaryOfTimeSpent($fuser->id); |
1029 | - if ($tmptimespent['total_duration']) print convertSecondToTime($tmptimespent['total_duration'],'allhourmin'); |
|
1030 | - else print '--:--'; |
|
1156 | + if ($tmptimespent['total_duration']) { |
|
1157 | + print convertSecondToTime($tmptimespent['total_duration'],'allhourmin'); |
|
1158 | + } else { |
|
1159 | + print '--:--'; |
|
1160 | + } |
|
1031 | 1161 | print "</td>\n"; |
1032 | 1162 | |
1033 | 1163 | $disabledproject=1;$disabledtask=1; |
@@ -1053,9 +1183,13 @@ discard block |
||
1053 | 1183 | print '</td>'; |
1054 | 1184 | |
1055 | 1185 | $cssonholiday=''; |
1056 | - if (! $isavailable[$preselectedday]['morning'] && ! $isavailable[$preselectedday]['afternoon']) $cssonholiday.='onholidayallday '; |
|
1057 | - elseif (! $isavailable[$preselectedday]['morning']) $cssonholiday.='onholidaymorning '; |
|
1058 | - elseif (! $isavailable[$preselectedday]['afternoon']) $cssonholiday.='onholidayafternoon '; |
|
1186 | + if (! $isavailable[$preselectedday]['morning'] && ! $isavailable[$preselectedday]['afternoon']) { |
|
1187 | + $cssonholiday.='onholidayallday '; |
|
1188 | + } elseif (! $isavailable[$preselectedday]['morning']) { |
|
1189 | + $cssonholiday.='onholidaymorning '; |
|
1190 | + } elseif (! $isavailable[$preselectedday]['afternoon']) { |
|
1191 | + $cssonholiday.='onholidayafternoon '; |
|
1192 | + } |
|
1059 | 1193 | |
1060 | 1194 | global $daytoparse; |
1061 | 1195 | $tmparray = dol_getdate($daytoparse,true); // detail of current day |
@@ -1063,10 +1197,12 @@ discard block |
||
1063 | 1197 | |
1064 | 1198 | global $numstartworkingday, $numendworkingday; |
1065 | 1199 | $cssweekend=''; |
1066 | - if (($idw + 1) < $numstartworkingday || ($idw + 1) > $numendworkingday) // This is a day is not inside the setup of working days, so we use a week-end css. |
|
1200 | + if (($idw + 1) < $numstartworkingday || ($idw + 1) > $numendworkingday) { |
|
1201 | + // This is a day is not inside the setup of working days, so we use a week-end css. |
|
1067 | 1202 | { |
1068 | 1203 | $cssweekend='weekend'; |
1069 | 1204 | } |
1205 | + } |
|
1070 | 1206 | |
1071 | 1207 | // Duration |
1072 | 1208 | print '<td class="center duration'.($cssonholiday?' '.$cssonholiday:'').($cssweekend?' '.$cssweekend:'').'">'; |
@@ -1074,7 +1210,9 @@ discard block |
||
1074 | 1210 | $totalforeachday[$preselectedday]+=$dayWorkLoad; |
1075 | 1211 | |
1076 | 1212 | $alreadyspent=''; |
1077 | - if ($dayWorkLoad > 0) $alreadyspent=convertSecondToTime($dayWorkLoad,'allhourmin'); |
|
1213 | + if ($dayWorkLoad > 0) { |
|
1214 | + $alreadyspent=convertSecondToTime($dayWorkLoad,'allhourmin'); |
|
1215 | + } |
|
1078 | 1216 | |
1079 | 1217 | $idw = 0; |
1080 | 1218 | |
@@ -1104,11 +1242,14 @@ discard block |
||
1104 | 1242 | |
1105 | 1243 | // Warning |
1106 | 1244 | print '<td align="right">'; |
1107 | - if ((! $lines[$i]->public) && $disabledproject) print $form->textwithpicto('',$langs->trans("UserIsNotContactOfProject")); |
|
1108 | - else if ($disabledtask) |
|
1245 | + if ((! $lines[$i]->public) && $disabledproject) { |
|
1246 | + print $form->textwithpicto('',$langs->trans("UserIsNotContactOfProject")); |
|
1247 | + } else if ($disabledtask) |
|
1109 | 1248 | { |
1110 | 1249 | $titleassigntask = $langs->trans("AssignTaskToMe"); |
1111 | - if ($fuser->id != $user->id) $titleassigntask = $langs->trans("AssignTaskToUser", '...'); |
|
1250 | + if ($fuser->id != $user->id) { |
|
1251 | + $titleassigntask = $langs->trans("AssignTaskToUser", '...'); |
|
1252 | + } |
|
1112 | 1253 | |
1113 | 1254 | print $form->textwithpicto('',$langs->trans("TaskIsNotAssignedToUser", $titleassigntask)); |
1114 | 1255 | } |
@@ -1134,8 +1275,7 @@ discard block |
||
1134 | 1275 | //var_dump($totalforeachday); |
1135 | 1276 | } |
1136 | 1277 | $level--; |
1137 | - } |
|
1138 | - else |
|
1278 | + } else |
|
1139 | 1279 | { |
1140 | 1280 | //$level--; |
1141 | 1281 | } |
@@ -1175,11 +1315,16 @@ discard block |
||
1175 | 1315 | $lineswithoutlevel0=array(); |
1176 | 1316 | |
1177 | 1317 | // Create a smaller array with sublevels only to be used later. This increase dramatically performances. |
1178 | - if ($parent == 0) // Always and only if at first level |
|
1318 | + if ($parent == 0) { |
|
1319 | + // Always and only if at first level |
|
1179 | 1320 | { |
1180 | - for ($i = 0 ; $i < $numlines ; $i++) |
|
1321 | + for ($i = 0 ; |
|
1322 | + } |
|
1323 | + $i < $numlines ; $i++) |
|
1181 | 1324 | { |
1182 | - if ($lines[$i]->fk_task_parent) $lineswithoutlevel0[]=$lines[$i]; |
|
1325 | + if ($lines[$i]->fk_task_parent) { |
|
1326 | + $lineswithoutlevel0[]=$lines[$i]; |
|
1327 | + } |
|
1183 | 1328 | } |
1184 | 1329 | } |
1185 | 1330 | |
@@ -1192,7 +1337,9 @@ discard block |
||
1192 | 1337 | |
1193 | 1338 | for ($i = 0 ; $i < $numlines ; $i++) |
1194 | 1339 | { |
1195 | - if ($parent == 0) $level = 0; |
|
1340 | + if ($parent == 0) { |
|
1341 | + $level = 0; |
|
1342 | + } |
|
1196 | 1343 | |
1197 | 1344 | if ($lines[$i]->fk_task_parent == $parent) |
1198 | 1345 | { |
@@ -1201,10 +1348,12 @@ discard block |
||
1201 | 1348 | { |
1202 | 1349 | //dol_syslog("projectLinesPerWeek Found line ".$i.", a qualified task (i have role or want to show all tasks) with id=".$lines[$i]->id." project id=".$lines[$i]->fk_project); |
1203 | 1350 | |
1204 | - if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->id])) // we have no role on task and we request to hide such cases |
|
1351 | + if ($restricteditformytask == 2 && empty($tasksrole[$lines[$i]->id])) { |
|
1352 | + // we have no role on task and we request to hide such cases |
|
1205 | 1353 | { |
1206 | 1354 | continue; |
1207 | 1355 | } |
1356 | + } |
|
1208 | 1357 | |
1209 | 1358 | // Break on a new project |
1210 | 1359 | if ($parent == 0 && $lines[$i]->fk_project != $lastprojectid) |
@@ -1244,7 +1393,9 @@ discard block |
||
1244 | 1393 | print '<tr class="oddeven trforbreak">'."\n"; |
1245 | 1394 | print '<td colspan="13">'; |
1246 | 1395 | print $projectstatic->getNomUrl(1,'',0,'<strong>'.$langs->transnoentitiesnoconv("YourRole").':</strong> '.$projectsrole[$lines[$i]->fk_project]); |
1247 | - if ($thirdpartystatic->id > 0) print ' - '.$thirdpartystatic->getNomUrl(1); |
|
1396 | + if ($thirdpartystatic->id > 0) { |
|
1397 | + print ' - '.$thirdpartystatic->getNomUrl(1); |
|
1398 | + } |
|
1248 | 1399 | if ($projectstatic->title) |
1249 | 1400 | { |
1250 | 1401 | print ' - '; |
@@ -1254,7 +1405,9 @@ discard block |
||
1254 | 1405 | print '</tr>'; |
1255 | 1406 | } |
1256 | 1407 | |
1257 | - if ($oldprojectforbreak != -1) $oldprojectforbreak = $projectstatic->id; |
|
1408 | + if ($oldprojectforbreak != -1) { |
|
1409 | + $oldprojectforbreak = $projectstatic->id; |
|
1410 | + } |
|
1258 | 1411 | |
1259 | 1412 | print '<tr class="oddeven">'."\n"; |
1260 | 1413 | |
@@ -1278,11 +1431,15 @@ discard block |
||
1278 | 1431 | // Ref |
1279 | 1432 | print '<td class="nowrap">'; |
1280 | 1433 | print '<!-- Task id = '.$lines[$i]->id.' -->'; |
1281 | - for ($k = 0 ; $k < $level ; $k++) print " "; |
|
1434 | + for ($k = 0 ; $k < $level ; $k++) { |
|
1435 | + print " "; |
|
1436 | + } |
|
1282 | 1437 | print $taskstatic->getNomUrl(1, 'withproject', 'time'); |
1283 | 1438 | // Label task |
1284 | 1439 | print '<br>'; |
1285 | - for ($k = 0 ; $k < $level ; $k++) print " "; |
|
1440 | + for ($k = 0 ; $k < $level ; $k++) { |
|
1441 | + print " "; |
|
1442 | + } |
|
1286 | 1443 | //print $taskstatic->getNomUrl(0, 'withproject', 'time'); |
1287 | 1444 | print $taskstatic->label; |
1288 | 1445 | //print "<br>"; |
@@ -1292,8 +1449,11 @@ discard block |
||
1292 | 1449 | |
1293 | 1450 | // Planned Workload |
1294 | 1451 | print '<td align="right" class="leftborder plannedworkload">'; |
1295 | - if ($lines[$i]->planned_workload) print convertSecondToTime($lines[$i]->planned_workload,'allhourmin'); |
|
1296 | - else print '--:--'; |
|
1452 | + if ($lines[$i]->planned_workload) { |
|
1453 | + print convertSecondToTime($lines[$i]->planned_workload,'allhourmin'); |
|
1454 | + } else { |
|
1455 | + print '--:--'; |
|
1456 | + } |
|
1297 | 1457 | print '</td>'; |
1298 | 1458 | |
1299 | 1459 | // Progress declared % |
@@ -1309,15 +1469,19 @@ discard block |
||
1309 | 1469 | print '<a href="'.DOL_URL_ROOT.'/projet/tasks/time.php?id='.$lines[$i]->id.'">'; |
1310 | 1470 | print convertSecondToTime($lines[$i]->duration,'allhourmin'); |
1311 | 1471 | print '</a>'; |
1472 | + } else { |
|
1473 | + print '--:--'; |
|
1312 | 1474 | } |
1313 | - else print '--:--'; |
|
1314 | 1475 | print "</td>\n"; |
1315 | 1476 | |
1316 | 1477 | // Time spent by user |
1317 | 1478 | print '<td align="right">'; |
1318 | 1479 | $tmptimespent=$taskstatic->getSummaryOfTimeSpent($fuser->id); |
1319 | - if ($tmptimespent['total_duration']) print convertSecondToTime($tmptimespent['total_duration'],'allhourmin'); |
|
1320 | - else print '--:--'; |
|
1480 | + if ($tmptimespent['total_duration']) { |
|
1481 | + print convertSecondToTime($tmptimespent['total_duration'],'allhourmin'); |
|
1482 | + } else { |
|
1483 | + print '--:--'; |
|
1484 | + } |
|
1321 | 1485 | print "</td>\n"; |
1322 | 1486 | |
1323 | 1487 | $disabledproject=1;$disabledtask=1; |
@@ -1345,24 +1509,32 @@ discard block |
||
1345 | 1509 | $tmpday=dol_time_plus_duree($firstdaytoshow, $idw, 'd'); |
1346 | 1510 | |
1347 | 1511 | $cssonholiday=''; |
1348 | - if (! $isavailable[$tmpday]['morning'] && ! $isavailable[$tmpday]['afternoon']) $cssonholiday.='onholidayallday '; |
|
1349 | - elseif (! $isavailable[$tmpday]['morning']) $cssonholiday.='onholidaymorning '; |
|
1350 | - elseif (! $isavailable[$tmpday]['afternoon']) $cssonholiday.='onholidayafternoon '; |
|
1512 | + if (! $isavailable[$tmpday]['morning'] && ! $isavailable[$tmpday]['afternoon']) { |
|
1513 | + $cssonholiday.='onholidayallday '; |
|
1514 | + } elseif (! $isavailable[$tmpday]['morning']) { |
|
1515 | + $cssonholiday.='onholidaymorning '; |
|
1516 | + } elseif (! $isavailable[$tmpday]['afternoon']) { |
|
1517 | + $cssonholiday.='onholidayafternoon '; |
|
1518 | + } |
|
1351 | 1519 | |
1352 | 1520 | $tmparray=dol_getdate($tmpday); |
1353 | 1521 | $dayWorkLoad = $projectstatic->weekWorkLoadPerTask[$tmpday][$lines[$i]->id]; |
1354 | 1522 | $totalforeachday[$tmpday]+=$dayWorkLoad; |
1355 | 1523 | |
1356 | 1524 | $alreadyspent=''; |
1357 | - if ($dayWorkLoad > 0) $alreadyspent=convertSecondToTime($dayWorkLoad,'allhourmin'); |
|
1525 | + if ($dayWorkLoad > 0) { |
|
1526 | + $alreadyspent=convertSecondToTime($dayWorkLoad,'allhourmin'); |
|
1527 | + } |
|
1358 | 1528 | $alttitle=$langs->trans("AddHereTimeSpentForDay",$tmparray['day'],$tmparray['mon']); |
1359 | 1529 | |
1360 | 1530 | global $numstartworkingday, $numendworkingday; |
1361 | 1531 | $cssweekend=''; |
1362 | - if (($idw + 1) < $numstartworkingday || ($idw + 1) > $numendworkingday) // This is a day is not inside the setup of working days, so we use a week-end css. |
|
1532 | + if (($idw + 1) < $numstartworkingday || ($idw + 1) > $numendworkingday) { |
|
1533 | + // This is a day is not inside the setup of working days, so we use a week-end css. |
|
1363 | 1534 | { |
1364 | 1535 | $cssweekend='weekend'; |
1365 | 1536 | } |
1537 | + } |
|
1366 | 1538 | |
1367 | 1539 | $tableCell ='<td align="center" class="hide'.$idw.($cssonholiday?' '.$cssonholiday:'').($cssweekend?' '.$cssweekend:'').'">'; |
1368 | 1540 | $placeholder=''; |
@@ -1382,11 +1554,14 @@ discard block |
||
1382 | 1554 | |
1383 | 1555 | // Warning |
1384 | 1556 | print '<td align="right">'; |
1385 | - if ((! $lines[$i]->public) && $disabledproject) print $form->textwithpicto('',$langs->trans("UserIsNotContactOfProject")); |
|
1386 | - else if ($disabledtask) |
|
1557 | + if ((! $lines[$i]->public) && $disabledproject) { |
|
1558 | + print $form->textwithpicto('',$langs->trans("UserIsNotContactOfProject")); |
|
1559 | + } else if ($disabledtask) |
|
1387 | 1560 | { |
1388 | 1561 | $titleassigntask = $langs->trans("AssignTaskToMe"); |
1389 | - if ($fuser->id != $user->id) $titleassigntask = $langs->trans("AssignTaskToUser", '...'); |
|
1562 | + if ($fuser->id != $user->id) { |
|
1563 | + $titleassigntask = $langs->trans("AssignTaskToUser", '...'); |
|
1564 | + } |
|
1390 | 1565 | |
1391 | 1566 | print $form->textwithpicto('',$langs->trans("TaskIsNotAssignedToUser", $titleassigntask)); |
1392 | 1567 | } |
@@ -1413,8 +1588,7 @@ discard block |
||
1413 | 1588 | //var_dump($totalforeachday); |
1414 | 1589 | } |
1415 | 1590 | $level--; |
1416 | - } |
|
1417 | - else |
|
1591 | + } else |
|
1418 | 1592 | { |
1419 | 1593 | //$level--; |
1420 | 1594 | } |
@@ -1453,7 +1627,9 @@ discard block |
||
1453 | 1627 | searchTaskInChild($inc, $lines[$i]->id, $lines, $taskrole); |
1454 | 1628 | //print 'Found inc='.$inc.'<br>'; |
1455 | 1629 | |
1456 | - if ($inc > 0) return $inc; |
|
1630 | + if ($inc > 0) { |
|
1631 | + return $inc; |
|
1632 | + } |
|
1457 | 1633 | } |
1458 | 1634 | } |
1459 | 1635 | |
@@ -1487,7 +1663,9 @@ discard block |
||
1487 | 1663 | $project_year_filter=0; |
1488 | 1664 | |
1489 | 1665 | $title=$langs->trans("Projects"); |
1490 | - if (strcmp($statut, '') && $statut >= 0) $title=$langs->trans("Projects").' '.$langs->trans($projectstatic->statuts_long[$statut]); |
|
1666 | + if (strcmp($statut, '') && $statut >= 0) { |
|
1667 | + $title=$langs->trans("Projects").' '.$langs->trans($projectstatic->statuts_long[$statut]); |
|
1668 | + } |
|
1491 | 1669 | |
1492 | 1670 | $arrayidtypeofcontact=array(); |
1493 | 1671 | |
@@ -1500,14 +1678,15 @@ discard block |
||
1500 | 1678 | $sql.= ", ".MAIN_DB_PREFIX."projet_task as t"; |
1501 | 1679 | $sql.= ", ".MAIN_DB_PREFIX."element_contact as ec"; |
1502 | 1680 | $sql.= ", ".MAIN_DB_PREFIX."c_type_contact as ctc"; |
1503 | - } |
|
1504 | - else |
|
1681 | + } else |
|
1505 | 1682 | { |
1506 | 1683 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."projet_task as t ON p.rowid = t.fk_projet"; |
1507 | 1684 | } |
1508 | 1685 | $sql.= " WHERE p.entity IN (".getEntity('project').")"; |
1509 | 1686 | $sql.= " AND p.rowid IN (".$projectsListId.")"; |
1510 | - if ($socid) $sql.= " AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".$socid.")"; |
|
1687 | + if ($socid) { |
|
1688 | + $sql.= " AND (p.fk_soc IS NULL OR p.fk_soc = 0 OR p.fk_soc = ".$socid.")"; |
|
1689 | + } |
|
1511 | 1690 | if ($mytasks) |
1512 | 1691 | { |
1513 | 1692 | $sql.= " AND p.rowid = t.fk_projet"; |
@@ -1550,9 +1729,12 @@ discard block |
||
1550 | 1729 | $arrayidofprojects[$objp->projectid]=$objp->projectid; |
1551 | 1730 | $i++; |
1552 | 1731 | } |
1732 | + } else { |
|
1733 | + dol_print_error($db); |
|
1734 | + } |
|
1735 | + if (empty($arrayidofprojects)) { |
|
1736 | + $arrayidofprojects[0]=-1; |
|
1553 | 1737 | } |
1554 | - else dol_print_error($db); |
|
1555 | - if (empty($arrayidofprojects)) $arrayidofprojects[0]=-1; |
|
1556 | 1738 | |
1557 | 1739 | // Get list of project with calculation on tasks |
1558 | 1740 | $sql2 = "SELECT p.rowid as projectid, p.ref, p.title, p.fk_soc, s.nom as socname, p.fk_user_creat, p.public, p.fk_statut as status, p.fk_opp_status as opp_status, p.opp_amount,"; |
@@ -1586,8 +1768,12 @@ discard block |
||
1586 | 1768 | if (empty($conf->global->PROJECT_HIDE_TASKS)) |
1587 | 1769 | { |
1588 | 1770 | print_liste_field_titre("Tasks","","","","",'align="right"',$sortfield,$sortorder); |
1589 | - if (! in_array('plannedworkload', $hiddenfields)) print_liste_field_titre("PlannedWorkload","","","","",'align="right"',$sortfield,$sortorder); |
|
1590 | - if (! in_array('declaredprogress', $hiddenfields)) print_liste_field_titre("ProgressDeclared","","","","",'align="right"',$sortfield,$sortorder); |
|
1771 | + if (! in_array('plannedworkload', $hiddenfields)) { |
|
1772 | + print_liste_field_titre("PlannedWorkload","","","","",'align="right"',$sortfield,$sortorder); |
|
1773 | + } |
|
1774 | + if (! in_array('declaredprogress', $hiddenfields)) { |
|
1775 | + print_liste_field_titre("ProgressDeclared","","","","",'align="right"',$sortfield,$sortorder); |
|
1776 | + } |
|
1591 | 1777 | } |
1592 | 1778 | print_liste_field_titre("Status","","","","",'align="right"',$sortfield,$sortorder); |
1593 | 1779 | print "</tr>\n"; |
@@ -1616,7 +1802,9 @@ discard block |
||
1616 | 1802 | print '<tr class="oddeven">'; |
1617 | 1803 | print '<td>'; |
1618 | 1804 | print $projectstatic->getNomUrl(1); |
1619 | - if (! in_array('projectlabel', $hiddenfields)) print '<br>'.dol_trunc($objp->title,24); |
|
1805 | + if (! in_array('projectlabel', $hiddenfields)) { |
|
1806 | + print '<br>'.dol_trunc($objp->title,24); |
|
1807 | + } |
|
1620 | 1808 | print '</td>'; |
1621 | 1809 | print '<td>'; |
1622 | 1810 | if ($objp->fk_soc > 0) |
@@ -1630,11 +1818,15 @@ discard block |
||
1630 | 1818 | if (! empty($conf->global->PROJECT_USE_OPPORTUNITIES)) |
1631 | 1819 | { |
1632 | 1820 | print '<td align="right">'; |
1633 | - if ($objp->opp_amount) print price($objp->opp_amount, 0, '', 1, -1, -1, $conf->currency); |
|
1821 | + if ($objp->opp_amount) { |
|
1822 | + print price($objp->opp_amount, 0, '', 1, -1, -1, $conf->currency); |
|
1823 | + } |
|
1634 | 1824 | print '</td>'; |
1635 | 1825 | print '<td align="right">'; |
1636 | 1826 | $code = dol_getIdFromCode($db, $objp->opp_status, 'c_lead_status', 'rowid', 'code'); |
1637 | - if ($code) print $langs->trans("OppStatus".$code); |
|
1827 | + if ($code) { |
|
1828 | + print $langs->trans("OppStatus".$code); |
|
1829 | + } |
|
1638 | 1830 | print '</td>'; |
1639 | 1831 | } |
1640 | 1832 | if (empty($conf->global->PROJECT_HIDE_TASKS)) |
@@ -1679,15 +1871,18 @@ discard block |
||
1679 | 1871 | if (empty($conf->global->PROJECT_HIDE_TASKS)) |
1680 | 1872 | { |
1681 | 1873 | print '<td class="liste_total" align="right">'.$total_task.'</td>'; |
1682 | - if (! in_array('plannedworkload', $hiddenfields)) print '<td class="liste_total" align="right">'.($total_plannedworkload?convertSecondToTime($total_plannedworkload):'').'</td>'; |
|
1683 | - if (! in_array('declaredprogress', $hiddenfields)) print '<td class="liste_total" align="right">'.($total_plannedworkload?round(100*$total_declaredprogressworkload/$total_plannedworkload,0).'%':'').'</td>'; |
|
1874 | + if (! in_array('plannedworkload', $hiddenfields)) { |
|
1875 | + print '<td class="liste_total" align="right">'.($total_plannedworkload?convertSecondToTime($total_plannedworkload):'').'</td>'; |
|
1876 | + } |
|
1877 | + if (! in_array('declaredprogress', $hiddenfields)) { |
|
1878 | + print '<td class="liste_total" align="right">'.($total_plannedworkload?round(100*$total_declaredprogressworkload/$total_plannedworkload,0).'%':'').'</td>'; |
|
1879 | + } |
|
1684 | 1880 | } |
1685 | 1881 | print '<td class="liste_total"></td>'; |
1686 | 1882 | print '</tr>'; |
1687 | 1883 | |
1688 | 1884 | $db->free($resql); |
1689 | - } |
|
1690 | - else |
|
1885 | + } else |
|
1691 | 1886 | { |
1692 | 1887 | dol_print_error($db); |
1693 | 1888 | } |
@@ -50,11 +50,12 @@ discard block |
||
50 | 50 | dol_syslog("For better performance, enable the native json in your PHP", LOG_WARNING); |
51 | 51 | |
52 | 52 | $num=0; |
53 | - if (is_object($elements)) // Count number of properties for an object |
|
53 | + if (is_object($elements)) { |
|
54 | + // Count number of properties for an object |
|
54 | 55 | { |
55 | 56 | foreach($elements as $key => $value) $num++; |
56 | 57 | } |
57 | - else |
|
58 | + } else |
|
58 | 59 | { |
59 | 60 | $num=count($elements); |
60 | 61 | } |
@@ -68,28 +69,43 @@ discard block |
||
68 | 69 | $output = '['; |
69 | 70 | for ($i = 0, $last = ($num - 1); $i < $num; $i++) |
70 | 71 | { |
71 | - if (! isset($elements[$keysofelements[$i]])) continue; |
|
72 | - if (is_array($elements[$keysofelements[$i]]) || is_object($elements[$keysofelements[$i]])) $output.= json_encode($elements[$keysofelements[$i]]); |
|
73 | - else $output .= _val($elements[$keysofelements[$i]]); |
|
74 | - if ($i !== $last) $output.= ','; |
|
72 | + if (! isset($elements[$keysofelements[$i]])) { |
|
73 | + continue; |
|
74 | + } |
|
75 | + if (is_array($elements[$keysofelements[$i]]) || is_object($elements[$keysofelements[$i]])) { |
|
76 | + $output.= json_encode($elements[$keysofelements[$i]]); |
|
77 | + } else { |
|
78 | + $output .= _val($elements[$keysofelements[$i]]); |
|
79 | + } |
|
80 | + if ($i !== $last) { |
|
81 | + $output.= ','; |
|
82 | + } |
|
75 | 83 | } |
76 | 84 | $output.= ']'; |
77 | - } |
|
78 | - else |
|
85 | + } else |
|
79 | 86 | { |
80 | 87 | // associative (object) |
81 | 88 | $output = '{'; |
82 | 89 | $last = $num - 1; |
83 | 90 | $i = 0; |
84 | 91 | $tmpelements=array(); |
85 | - if (is_array($elements)) $tmpelements=$elements; |
|
86 | - if (is_object($elements)) $tmpelements=get_object_vars($elements); |
|
92 | + if (is_array($elements)) { |
|
93 | + $tmpelements=$elements; |
|
94 | + } |
|
95 | + if (is_object($elements)) { |
|
96 | + $tmpelements=get_object_vars($elements); |
|
97 | + } |
|
87 | 98 | foreach($tmpelements as $key => $value) |
88 | 99 | { |
89 | 100 | $output .= '"'.$key.'":'; |
90 | - if (is_array($value)) $output.= json_encode($value); |
|
91 | - else $output .= _val($value); |
|
92 | - if ($i !== $last) $output.= ','; |
|
101 | + if (is_array($value)) { |
|
102 | + $output.= json_encode($value); |
|
103 | + } else { |
|
104 | + $output .= _val($value); |
|
105 | + } |
|
106 | + if ($i !== $last) { |
|
107 | + $output.= ','; |
|
108 | + } |
|
93 | 109 | ++$i; |
94 | 110 | } |
95 | 111 | $output.= '}'; |
@@ -198,12 +214,16 @@ discard block |
||
198 | 214 | } |
199 | 215 | |
200 | 216 | return '"'.$ascii.'"'; |
217 | + } elseif (is_int($val)) { |
|
218 | + return sprintf('%d', $val); |
|
219 | + } elseif (is_float($val)) { |
|
220 | + return sprintf('%F', $val); |
|
221 | + } elseif (is_bool($val)) { |
|
222 | + return ($val ? 'true' : 'false'); |
|
223 | + } else { |
|
224 | + return 'null'; |
|
225 | + } |
|
201 | 226 | } |
202 | - elseif (is_int($val)) return sprintf('%d', $val); |
|
203 | - elseif (is_float($val)) return sprintf('%F', $val); |
|
204 | - elseif (is_bool($val)) return ($val ? 'true' : 'false'); |
|
205 | - else return 'null'; |
|
206 | -} |
|
207 | 227 | |
208 | 228 | if (! function_exists('json_decode')) |
209 | 229 | { |
@@ -241,20 +261,31 @@ discard block |
||
241 | 261 | { |
242 | 262 | if (! $comment) |
243 | 263 | { |
244 | - if (($json[$i] == '{') || ($json[$i] == '[')) $out.= 'array('; |
|
245 | - else if (($json[$i] == '}') || ($json[$i] == ']')) $out.= ')'; |
|
246 | - else if ($json[$i] == ':') $out.= ' => '; |
|
247 | - else $out.=$json[$i]; |
|
264 | + if (($json[$i] == '{') || ($json[$i] == '[')) { |
|
265 | + $out.= 'array('; |
|
266 | + } else if (($json[$i] == '}') || ($json[$i] == ']')) { |
|
267 | + $out.= ')'; |
|
268 | + } else if ($json[$i] == ':') { |
|
269 | + $out.= ' => '; |
|
270 | + } else { |
|
271 | + $out.=$json[$i]; |
|
272 | + } |
|
273 | + } else { |
|
274 | + $out.= $json[$i]; |
|
275 | + } |
|
276 | + if ($json[$i] == '"' && $json[($i-1)]!="\\") { |
|
277 | + $comment = !$comment; |
|
248 | 278 | } |
249 | - else $out.= $json[$i]; |
|
250 | - if ($json[$i] == '"' && $json[($i-1)]!="\\") $comment = !$comment; |
|
251 | 279 | } |
252 | 280 | |
253 | 281 | $out=_unval($out); |
254 | 282 | |
255 | 283 | // Return an array |
256 | - if ($out != '') eval('$array = '.$out.';'); |
|
257 | - else $array=array(); |
|
284 | + if ($out != '') { |
|
285 | + eval('$array = '.$out.';'); |
|
286 | + } else { |
|
287 | + $array=array(); |
|
288 | + } |
|
258 | 289 | |
259 | 290 | // Return an object |
260 | 291 | if (! $assoc) |
@@ -267,7 +298,9 @@ discard block |
||
267 | 298 | } |
268 | 299 | foreach ($array as $key => $value) |
269 | 300 | { |
270 | - if ($key) $object->{$key} = $value; |
|
301 | + if ($key) { |
|
302 | + $object->{$key} = $value; |
|
303 | + } |
|
271 | 304 | } |
272 | 305 | |
273 | 306 | return $object; |
@@ -48,8 +48,11 @@ discard block |
||
48 | 48 | $ref_supplier=(! empty($line->ref_supplier)?$line->ref_supplier:(! empty($line->ref_fourn)?$line->ref_fourn:'')); // TODO Not yet saved for supplier invoices, only supplier orders |
49 | 49 | $note=(! empty($line->note)?$line->note:''); |
50 | 50 | |
51 | - if ($issupplierline) $prodser = new ProductFournisseur($db); |
|
52 | - else $prodser = new Product($db); |
|
51 | + if ($issupplierline) { |
|
52 | + $prodser = new ProductFournisseur($db); |
|
53 | + } else { |
|
54 | + $prodser = new Product($db); |
|
55 | + } |
|
53 | 56 | |
54 | 57 | if ($idprod) |
55 | 58 | { |
@@ -57,9 +60,15 @@ discard block |
||
57 | 60 | // If a predefined product and multilang and on other lang, we renamed label with label translated |
58 | 61 | if (! empty($conf->global->MAIN_MULTILANGS) && ($outputlangs->defaultlang != $langs->defaultlang)) |
59 | 62 | { |
60 | - if (! empty($prodser->multilangs[$outputlangs->defaultlang]["label"]) && $label == $prodser->label) $label=$prodser->multilangs[$outputlangs->defaultlang]["label"]; |
|
61 | - if (! empty($prodser->multilangs[$outputlangs->defaultlang]["description"]) && $desc == $prodser->description) $desc=$prodser->multilangs[$outputlangs->defaultlang]["description"]; |
|
62 | - if (! empty($prodser->multilangs[$outputlangs->defaultlang]["note"]) && $note == $prodser->note) $note=$prodser->multilangs[$outputlangs->defaultlang]["note"]; |
|
63 | + if (! empty($prodser->multilangs[$outputlangs->defaultlang]["label"]) && $label == $prodser->label) { |
|
64 | + $label=$prodser->multilangs[$outputlangs->defaultlang]["label"]; |
|
65 | + } |
|
66 | + if (! empty($prodser->multilangs[$outputlangs->defaultlang]["description"]) && $desc == $prodser->description) { |
|
67 | + $desc=$prodser->multilangs[$outputlangs->defaultlang]["description"]; |
|
68 | + } |
|
69 | + if (! empty($prodser->multilangs[$outputlangs->defaultlang]["note"]) && $note == $prodser->note) { |
|
70 | + $note=$prodser->multilangs[$outputlangs->defaultlang]["note"]; |
|
71 | + } |
|
63 | 72 | } |
64 | 73 | } |
65 | 74 | |
@@ -75,35 +84,34 @@ discard block |
||
75 | 84 | $discount->fetch($line->fk_remise_except); |
76 | 85 | $sourceref=!empty($discount->discount_type)?$discount->ref_invoive_supplier_source:$discount->ref_facture_source; |
77 | 86 | $libelleproduitservice=$outputlangs->transnoentitiesnoconv("DiscountFromCreditNote",$sourceref); |
78 | - } |
|
79 | - elseif ($desc == '(DEPOSIT)' && $line->fk_remise_except) |
|
87 | + } elseif ($desc == '(DEPOSIT)' && $line->fk_remise_except) |
|
80 | 88 | { |
81 | 89 | $discount=new DiscountAbsolute($db); |
82 | 90 | $discount->fetch($line->fk_remise_except); |
83 | 91 | $sourceref=!empty($discount->discount_type)?$discount->ref_invoive_supplier_source:$discount->ref_facture_source; |
84 | 92 | $libelleproduitservice=$outputlangs->transnoentitiesnoconv("DiscountFromDeposit",$sourceref); |
85 | 93 | // Add date of deposit |
86 | - if (! empty($conf->global->INVOICE_ADD_DEPOSIT_DATE)) $libelleproduitservice.=' ('.dol_print_date($discount->datec,'day','',$outputlangs).')'; |
|
87 | - } |
|
88 | - elseif ($desc == '(EXCESS RECEIVED)' && $line->fk_remise_except) |
|
94 | + if (! empty($conf->global->INVOICE_ADD_DEPOSIT_DATE)) { |
|
95 | + $libelleproduitservice.=' ('.dol_print_date($discount->datec,'day','',$outputlangs).')'; |
|
96 | + } |
|
97 | + } elseif ($desc == '(EXCESS RECEIVED)' && $line->fk_remise_except) |
|
89 | 98 | { |
90 | 99 | $discount=new DiscountAbsolute($db); |
91 | 100 | $discount->fetch($line->fk_remise_except); |
92 | 101 | $libelleproduitservice=$outputlangs->transnoentitiesnoconv("DiscountFromExcessReceived",$discount->ref_facture_source); |
93 | - } |
|
94 | - elseif ($desc == '(EXCESS PAID)' && $line->fk_remise_except) |
|
102 | + } elseif ($desc == '(EXCESS PAID)' && $line->fk_remise_except) |
|
95 | 103 | { |
96 | 104 | $discount=new DiscountAbsolute($db); |
97 | 105 | $discount->fetch($line->fk_remise_except); |
98 | 106 | $libelleproduitservice=$outputlangs->transnoentitiesnoconv("DiscountFromExcessPaid",$discount->ref_invoice_supplier_source); |
99 | - } |
|
100 | - else |
|
107 | + } else |
|
101 | 108 | { |
102 | 109 | if ($idprod) |
103 | 110 | { |
104 | - if (empty($hidedesc)) $libelleproduitservice=dol_concatdesc($libelleproduitservice, $desc); |
|
105 | - } |
|
106 | - else |
|
111 | + if (empty($hidedesc)) { |
|
112 | + $libelleproduitservice=dol_concatdesc($libelleproduitservice, $desc); |
|
113 | + } |
|
114 | + } else |
|
107 | 115 | { |
108 | 116 | $libelleproduitservice=dol_concatdesc($libelleproduitservice, $desc); |
109 | 117 | } |
@@ -118,13 +126,14 @@ discard block |
||
118 | 126 | { |
119 | 127 | $prefix_prodserv = ""; |
120 | 128 | $ref_prodserv = ""; |
121 | - if (! empty($conf->global->PRODUCT_ADD_TYPE_IN_DOCUMENTS)) // In standard mode, we do not show this |
|
129 | + if (! empty($conf->global->PRODUCT_ADD_TYPE_IN_DOCUMENTS)) { |
|
130 | + // In standard mode, we do not show this |
|
122 | 131 | { |
123 | 132 | if ($prodser->isService()) |
124 | 133 | { |
125 | 134 | $prefix_prodserv = $outputlangs->transnoentitiesnoconv("Service")." "; |
126 | - } |
|
127 | - else |
|
135 | + } |
|
136 | + } else |
|
128 | 137 | { |
129 | 138 | $prefix_prodserv = $outputlangs->transnoentitiesnoconv("Product")." "; |
130 | 139 | } |
@@ -132,8 +141,14 @@ discard block |
||
132 | 141 | |
133 | 142 | if (empty($hideref)) |
134 | 143 | { |
135 | - if ($issupplierline) $ref_prodserv = $prodser->ref.' ('.$outputlangs->trans("SupplierRef").' '.$ref_supplier.')'; // Show local ref and supplier ref |
|
136 | - else $ref_prodserv = $prodser->ref; // Show local ref only |
|
144 | + if ($issupplierline) { |
|
145 | + $ref_prodserv = $prodser->ref.' ('.$outputlangs->trans("SupplierRef").' '.$ref_supplier.')'; |
|
146 | + } |
|
147 | + // Show local ref and supplier ref |
|
148 | + else { |
|
149 | + $ref_prodserv = $prodser->ref; |
|
150 | + } |
|
151 | + // Show local ref only |
|
137 | 152 | |
138 | 153 | $ref_prodserv .= " - "; |
139 | 154 | } |
@@ -59,7 +59,9 @@ discard block |
||
59 | 59 | $nbLinks=Link::count($db, $object->element, $object->id); |
60 | 60 | $head[$h][0] = DOL_URL_ROOT.'/compta/sociales/document.php?id='.$object->id; |
61 | 61 | $head[$h][1] = $langs->trans("Documents"); |
62 | - if (($nbFiles+$nbLinks) > 0) $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
62 | + if (($nbFiles+$nbLinks) > 0) { |
|
63 | + $head[$h][1].= ' <span class="badge">'.($nbFiles+$nbLinks).'</span>'; |
|
64 | + } |
|
63 | 65 | $head[$h][2] = 'documents'; |
64 | 66 | $h++; |
65 | 67 | |
@@ -154,28 +156,35 @@ discard block |
||
154 | 156 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
155 | 157 | $sql.= " WHERE f.entity = " . $conf->entity; |
156 | 158 | $sql.= " AND f.fk_statut in (1,2)"; // Validated or paid (partially or completely) |
157 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
158 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
159 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
160 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
161 | + } else { |
|
162 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
163 | + } |
|
159 | 164 | $sql.= " AND f.rowid = d.".$fk_facture; |
160 | 165 | $sql.= " AND s.rowid = f.fk_soc"; |
161 | 166 | if ($y && $m) |
162 | 167 | { |
163 | 168 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
164 | 169 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
165 | - } |
|
166 | - else if ($y) |
|
170 | + } else if ($y) |
|
167 | 171 | { |
168 | 172 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
169 | 173 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
170 | 174 | } |
171 | - if ($q) $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
172 | - if ($date_start && $date_end) $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
175 | + if ($q) { |
|
176 | + $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
177 | + } |
|
178 | + if ($date_start && $date_end) { |
|
179 | + $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
180 | + } |
|
173 | 181 | $sql.= " AND (d.product_type = 0"; // Limit to products |
174 | 182 | $sql.= " AND d.date_start is null AND d.date_end IS NULL)"; // enhance detection of products |
175 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
183 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
184 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
185 | + } |
|
176 | 186 | $sql.= " ORDER BY d.rowid, d.".$fk_facture; |
177 | - } |
|
178 | - else |
|
187 | + } else |
|
179 | 188 | { |
180 | 189 | // Count on payments date |
181 | 190 | $sql = "SELECT d.rowid, d.product_type as dtype, d.".$fk_facture." as facid, d.$f_rate as rate, d.total_ht as total_ht, d.total_ttc as total_ttc, d.".$total_tva." as total_vat, d.description as descr,"; |
@@ -193,8 +202,11 @@ discard block |
||
193 | 202 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
194 | 203 | $sql.= " WHERE f.entity = " . $conf->entity; |
195 | 204 | $sql.= " AND f.fk_statut in (1,2)"; // Paid (partially or completely) |
196 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
197 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
205 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
206 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
207 | + } else { |
|
208 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
209 | + } |
|
198 | 210 | $sql.= " AND f.rowid = d.".$fk_facture; |
199 | 211 | $sql.= " AND s.rowid = f.fk_soc"; |
200 | 212 | $sql.= " AND pf.".$fk_facture2." = f.rowid"; |
@@ -203,22 +215,31 @@ discard block |
||
203 | 215 | { |
204 | 216 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
205 | 217 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
206 | - } |
|
207 | - else if ($y) |
|
218 | + } else if ($y) |
|
208 | 219 | { |
209 | 220 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
210 | 221 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
211 | 222 | } |
212 | - if ($q) $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
213 | - if ($date_start && $date_end) $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
223 | + if ($q) { |
|
224 | + $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
225 | + } |
|
226 | + if ($date_start && $date_end) { |
|
227 | + $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
228 | + } |
|
214 | 229 | $sql.= " AND (d.product_type = 0"; // Limit to products |
215 | 230 | $sql.= " AND d.date_start is null AND d.date_end IS NULL)"; // enhance detection of products |
216 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
231 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
232 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
233 | + } |
|
217 | 234 | $sql.= " ORDER BY d.rowid, d.".$fk_facture.", pf.rowid"; |
218 | 235 | } |
219 | 236 | |
220 | - if (! $sql) return -1; |
|
221 | - if ($sql == 'TODO') return -2; |
|
237 | + if (! $sql) { |
|
238 | + return -1; |
|
239 | + } |
|
240 | + if ($sql == 'TODO') { |
|
241 | + return -2; |
|
242 | + } |
|
222 | 243 | if ($sql != 'TODO') |
223 | 244 | { |
224 | 245 | dol_syslog("Tax.lib.php::tax_by_thirdparty", LOG_DEBUG); |
@@ -230,14 +251,24 @@ discard block |
||
230 | 251 | $oldrowid=''; |
231 | 252 | while($assoc = $db->fetch_array($resql)) |
232 | 253 | { |
233 | - if (! isset($list[$assoc['company_id']]['totalht'])) $list[$assoc['company_id']]['totalht']=0; |
|
234 | - if (! isset($list[$assoc['company_id']]['vat'])) $list[$assoc['company_id']]['vat']=0; |
|
235 | - if (! isset($list[$assoc['company_id']]['localtax1'])) $list[$assoc['company_id']]['localtax1']=0; |
|
236 | - if (! isset($list[$assoc['company_id']]['localtax2'])) $list[$assoc['company_id']]['localtax2']=0; |
|
254 | + if (! isset($list[$assoc['company_id']]['totalht'])) { |
|
255 | + $list[$assoc['company_id']]['totalht']=0; |
|
256 | + } |
|
257 | + if (! isset($list[$assoc['company_id']]['vat'])) { |
|
258 | + $list[$assoc['company_id']]['vat']=0; |
|
259 | + } |
|
260 | + if (! isset($list[$assoc['company_id']]['localtax1'])) { |
|
261 | + $list[$assoc['company_id']]['localtax1']=0; |
|
262 | + } |
|
263 | + if (! isset($list[$assoc['company_id']]['localtax2'])) { |
|
264 | + $list[$assoc['company_id']]['localtax2']=0; |
|
265 | + } |
|
237 | 266 | |
238 | - if ($assoc['rowid'] != $oldrowid) // Si rupture sur d.rowid |
|
267 | + if ($assoc['rowid'] != $oldrowid) { |
|
268 | + // Si rupture sur d.rowid |
|
239 | 269 | { |
240 | 270 | $oldrowid=$assoc['rowid']; |
271 | + } |
|
241 | 272 | $list[$assoc['company_id']]['totalht'] += $assoc['total_ht']; |
242 | 273 | $list[$assoc['company_id']]['vat'] += $assoc['total_vat']; |
243 | 274 | $list[$assoc['company_id']]['localtax1'] += $assoc['total_localtax1']; |
@@ -273,8 +304,7 @@ discard block |
||
273 | 304 | |
274 | 305 | $company_id = $assoc['company_id']; |
275 | 306 | } |
276 | - } |
|
277 | - else |
|
307 | + } else |
|
278 | 308 | { |
279 | 309 | dol_print_error($db); |
280 | 310 | return -3; |
@@ -302,28 +332,35 @@ discard block |
||
302 | 332 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
303 | 333 | $sql.= " WHERE f.entity = " . $conf->entity; |
304 | 334 | $sql.= " AND f.fk_statut in (1,2)"; // Validated or paid (partially or completely) |
305 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
306 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
335 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
336 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
337 | + } else { |
|
338 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
339 | + } |
|
307 | 340 | $sql.= " AND f.rowid = d.".$fk_facture; |
308 | 341 | $sql.= " AND s.rowid = f.fk_soc"; |
309 | 342 | if ($y && $m) |
310 | 343 | { |
311 | 344 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
312 | 345 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
313 | - } |
|
314 | - else if ($y) |
|
346 | + } else if ($y) |
|
315 | 347 | { |
316 | 348 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
317 | 349 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
318 | 350 | } |
319 | - if ($q) $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
320 | - if ($date_start && $date_end) $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
351 | + if ($q) { |
|
352 | + $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
353 | + } |
|
354 | + if ($date_start && $date_end) { |
|
355 | + $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
356 | + } |
|
321 | 357 | $sql.= " AND (d.product_type = 1"; // Limit to services |
322 | 358 | $sql.= " OR d.date_start is NOT null OR d.date_end IS NOT NULL)"; // enhance detection of service |
323 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
359 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
360 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
361 | + } |
|
324 | 362 | $sql.= " ORDER BY d.rowid, d.".$fk_facture; |
325 | - } |
|
326 | - else |
|
363 | + } else |
|
327 | 364 | { |
328 | 365 | // Count on payments date |
329 | 366 | $sql = "SELECT d.rowid, d.product_type as dtype, d.".$fk_facture." as facid, d.$f_rate as rate, d.total_ht as total_ht, d.total_ttc as total_ttc, d.".$total_tva." as total_vat, d.description as descr,"; |
@@ -341,8 +378,11 @@ discard block |
||
341 | 378 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
342 | 379 | $sql.= " WHERE f.entity = " . $conf->entity; |
343 | 380 | $sql.= " AND f.fk_statut in (1,2)"; // Paid (partially or completely) |
344 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
345 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
381 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
382 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
383 | + } else { |
|
384 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
385 | + } |
|
346 | 386 | $sql.= " AND f.rowid = d.".$fk_facture; |
347 | 387 | $sql.= " AND s.rowid = f.fk_soc"; |
348 | 388 | $sql.= " AND pf.".$fk_facture2." = f.rowid"; |
@@ -351,17 +391,22 @@ discard block |
||
351 | 391 | { |
352 | 392 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
353 | 393 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
354 | - } |
|
355 | - else if ($y) |
|
394 | + } else if ($y) |
|
356 | 395 | { |
357 | 396 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
358 | 397 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
359 | 398 | } |
360 | - if ($q) $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
361 | - if ($date_start && $date_end) $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
399 | + if ($q) { |
|
400 | + $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
401 | + } |
|
402 | + if ($date_start && $date_end) { |
|
403 | + $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
404 | + } |
|
362 | 405 | $sql.= " AND (d.product_type = 1"; // Limit to services |
363 | 406 | $sql.= " OR d.date_start is NOT null OR d.date_end IS NOT NULL)"; // enhance detection of service |
364 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
407 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
408 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
409 | + } |
|
365 | 410 | $sql.= " ORDER BY d.rowid, d.".$fk_facture.", pf.rowid"; |
366 | 411 | } |
367 | 412 | |
@@ -370,7 +415,10 @@ discard block |
||
370 | 415 | dol_syslog("Tax.lib.php::tax_by_rate no accountancy module enabled".$sql,LOG_ERR); |
371 | 416 | return -1; // -1 = Not accountancy module enabled |
372 | 417 | } |
373 | - if ($sql == 'TODO') return -2; // -2 = Feature not yet available |
|
418 | + if ($sql == 'TODO') { |
|
419 | + return -2; |
|
420 | + } |
|
421 | + // -2 = Feature not yet available |
|
374 | 422 | if ($sql != 'TODO') |
375 | 423 | { |
376 | 424 | dol_syslog("Tax.lib.php::tax_by_rate", LOG_DEBUG); |
@@ -381,14 +429,24 @@ discard block |
||
381 | 429 | $oldrowid=''; |
382 | 430 | while($assoc = $db->fetch_array($resql)) |
383 | 431 | { |
384 | - if (! isset($list[$assoc['company_id']]['totalht'])) $list[$assoc['company_id']]['totalht']=0; |
|
385 | - if (! isset($list[$assoc['company_id']]['vat'])) $list[$assoc['company_id']]['vat']=0; |
|
386 | - if (! isset($list[$assoc['company_id']]['localtax1'])) $list[$assoc['company_id']]['localtax1']=0; |
|
387 | - if (! isset($list[$assoc['company_id']]['localtax2'])) $list[$assoc['company_id']]['localtax2']=0; |
|
432 | + if (! isset($list[$assoc['company_id']]['totalht'])) { |
|
433 | + $list[$assoc['company_id']]['totalht']=0; |
|
434 | + } |
|
435 | + if (! isset($list[$assoc['company_id']]['vat'])) { |
|
436 | + $list[$assoc['company_id']]['vat']=0; |
|
437 | + } |
|
438 | + if (! isset($list[$assoc['company_id']]['localtax1'])) { |
|
439 | + $list[$assoc['company_id']]['localtax1']=0; |
|
440 | + } |
|
441 | + if (! isset($list[$assoc['company_id']]['localtax2'])) { |
|
442 | + $list[$assoc['company_id']]['localtax2']=0; |
|
443 | + } |
|
388 | 444 | |
389 | - if ($assoc['rowid'] != $oldrowid) // Si rupture sur d.rowid |
|
445 | + if ($assoc['rowid'] != $oldrowid) { |
|
446 | + // Si rupture sur d.rowid |
|
390 | 447 | { |
391 | 448 | $oldrowid=$assoc['rowid']; |
449 | + } |
|
392 | 450 | $list[$assoc['company_id']]['totalht'] += $assoc['total_ht']; |
393 | 451 | $list[$assoc['company_id']]['vat'] += $assoc['total_vat']; |
394 | 452 | $list[$assoc['company_id']]['localtax1'] += $assoc['total_localtax1']; |
@@ -424,8 +482,7 @@ discard block |
||
424 | 482 | |
425 | 483 | $company_id = $assoc['company_id']; |
426 | 484 | } |
427 | - } |
|
428 | - else |
|
485 | + } else |
|
429 | 486 | { |
430 | 487 | dol_print_error($db); |
431 | 488 | return -3; |
@@ -435,10 +492,12 @@ discard block |
||
435 | 492 | |
436 | 493 | // CASE OF EXPENSE REPORT |
437 | 494 | |
438 | - if ($direction == 'buy') // buy only for expense reports |
|
495 | + if ($direction == 'buy') { |
|
496 | + // buy only for expense reports |
|
439 | 497 | { |
440 | 498 | // Define sql request |
441 | 499 | $sql=''; |
500 | + } |
|
442 | 501 | |
443 | 502 | // Count on payments date |
444 | 503 | $sql = "SELECT d.rowid, d.product_type as dtype, e.rowid as facid, d.$f_rate as rate, d.total_ht as total_ht, d.total_ttc as total_ttc, d.total_tva as total_vat, e.note_private as descr,"; |
@@ -455,17 +514,22 @@ discard block |
||
455 | 514 | { |
456 | 515 | $sql.= " AND p.datep >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
457 | 516 | $sql.= " AND p.datep <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
458 | - } |
|
459 | - else if ($y) |
|
517 | + } else if ($y) |
|
460 | 518 | { |
461 | 519 | $sql.= " AND p.datep >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
462 | 520 | $sql.= " AND p.datep <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
463 | 521 | } |
464 | - if ($q) $sql.= " AND (date_format(p.datep,'%m') > ".(($q-1)*3)." AND date_format(p.datep,'%m') <= ".($q*3).")"; |
|
465 | - if ($date_start && $date_end) $sql.= " AND p.datep >= '".$db->idate($date_start)."' AND p.datep <= '".$db->idate($date_end)."'"; |
|
522 | + if ($q) { |
|
523 | + $sql.= " AND (date_format(p.datep,'%m') > ".(($q-1)*3)." AND date_format(p.datep,'%m') <= ".($q*3).")"; |
|
524 | + } |
|
525 | + if ($date_start && $date_end) { |
|
526 | + $sql.= " AND p.datep >= '".$db->idate($date_start)."' AND p.datep <= '".$db->idate($date_end)."'"; |
|
527 | + } |
|
466 | 528 | $sql.= " AND (d.product_type = -1"; |
467 | 529 | $sql.= " OR e.date_debut is NOT null OR e.date_fin IS NOT NULL)"; // enhance detection of service |
468 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.total_tva <> 0)"; |
|
530 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
531 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.total_tva <> 0)"; |
|
532 | + } |
|
469 | 533 | $sql.= " ORDER BY e.rowid"; |
470 | 534 | |
471 | 535 | if (! $sql) |
@@ -473,7 +537,10 @@ discard block |
||
473 | 537 | dol_syslog("Tax.lib.php::tax_by_rate no accountancy module enabled".$sql,LOG_ERR); |
474 | 538 | return -1; // -1 = Not accountancy module enabled |
475 | 539 | } |
476 | - if ($sql == 'TODO') return -2; // -2 = Feature not yet available |
|
540 | + if ($sql == 'TODO') { |
|
541 | + return -2; |
|
542 | + } |
|
543 | + // -2 = Feature not yet available |
|
477 | 544 | if ($sql != 'TODO') |
478 | 545 | { |
479 | 546 | dol_syslog("Tax.lib.php::tax_by_rate", LOG_DEBUG); |
@@ -484,14 +551,24 @@ discard block |
||
484 | 551 | $oldrowid=''; |
485 | 552 | while($assoc = $db->fetch_array($resql)) |
486 | 553 | { |
487 | - if (! isset($list[$assoc['company_id']]['totalht'])) $list[$assoc['company_id']]['totalht']=0; |
|
488 | - if (! isset($list[$assoc['company_id']]['vat'])) $list[$assoc['company_id']]['vat']=0; |
|
489 | - if (! isset($list[$assoc['company_id']]['localtax1'])) $list[$assoc['company_id']]['localtax1']=0; |
|
490 | - if (! isset($list[$assoc['company_id']]['localtax2'])) $list[$assoc['company_id']]['localtax2']=0; |
|
554 | + if (! isset($list[$assoc['company_id']]['totalht'])) { |
|
555 | + $list[$assoc['company_id']]['totalht']=0; |
|
556 | + } |
|
557 | + if (! isset($list[$assoc['company_id']]['vat'])) { |
|
558 | + $list[$assoc['company_id']]['vat']=0; |
|
559 | + } |
|
560 | + if (! isset($list[$assoc['company_id']]['localtax1'])) { |
|
561 | + $list[$assoc['company_id']]['localtax1']=0; |
|
562 | + } |
|
563 | + if (! isset($list[$assoc['company_id']]['localtax2'])) { |
|
564 | + $list[$assoc['company_id']]['localtax2']=0; |
|
565 | + } |
|
491 | 566 | |
492 | - if ($assoc['rowid'] != $oldrowid) // Si rupture sur d.rowid |
|
567 | + if ($assoc['rowid'] != $oldrowid) { |
|
568 | + // Si rupture sur d.rowid |
|
493 | 569 | { |
494 | 570 | $oldrowid=$assoc['rowid']; |
571 | + } |
|
495 | 572 | $list[$assoc['company_id']]['totalht'] += $assoc['total_ht']; |
496 | 573 | $list[$assoc['company_id']]['vat'] += $assoc['total_vat']; |
497 | 574 | $list[$assoc['company_id']]['localtax1'] += $assoc['total_localtax1']; |
@@ -528,8 +605,7 @@ discard block |
||
528 | 605 | |
529 | 606 | $company_id = $assoc['company_id']; |
530 | 607 | } |
531 | - } |
|
532 | - else |
|
608 | + } else |
|
533 | 609 | { |
534 | 610 | dol_print_error($db); |
535 | 611 | return -3; |
@@ -579,8 +655,7 @@ discard block |
||
579 | 655 | $paymenttable='paiement'; |
580 | 656 | $paymentfacturetable='paiement_facture'; |
581 | 657 | $invoicefieldref='ref'; |
582 | - } |
|
583 | - else |
|
658 | + } else |
|
584 | 659 | { |
585 | 660 | $invoicetable='facture_fourn'; |
586 | 661 | $invoicedettable='facture_fourn_det'; |
@@ -623,28 +698,35 @@ discard block |
||
623 | 698 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
624 | 699 | $sql.= " WHERE f.entity = " . $conf->entity; |
625 | 700 | $sql.= " AND f.fk_statut in (1,2)"; // Validated or paid (partially or completely) |
626 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
627 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
701 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
702 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
703 | + } else { |
|
704 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
705 | + } |
|
628 | 706 | $sql.= " AND f.rowid = d.".$fk_facture; |
629 | 707 | $sql.= " AND s.rowid = f.fk_soc"; |
630 | 708 | if ($y && $m) |
631 | 709 | { |
632 | 710 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
633 | 711 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
634 | - } |
|
635 | - else if ($y) |
|
712 | + } else if ($y) |
|
636 | 713 | { |
637 | 714 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
638 | 715 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
639 | 716 | } |
640 | - if ($q) $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
641 | - if ($date_start && $date_end) $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
717 | + if ($q) { |
|
718 | + $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
719 | + } |
|
720 | + if ($date_start && $date_end) { |
|
721 | + $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
722 | + } |
|
642 | 723 | $sql.= " AND (d.product_type = 0"; // Limit to products |
643 | 724 | $sql.= " AND d.date_start is null AND d.date_end IS NULL)"; // enhance detection of products |
644 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
725 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
726 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
727 | + } |
|
645 | 728 | $sql.= " ORDER BY d.rowid, d.".$fk_facture; |
646 | - } |
|
647 | - else |
|
729 | + } else |
|
648 | 730 | { |
649 | 731 | // Count on payments date |
650 | 732 | $sql = "SELECT d.rowid, d.product_type as dtype, d.".$fk_facture." as facid, d.$f_rate as rate, d.total_ht as total_ht, d.total_ttc as total_ttc, d.".$total_tva." as total_vat, d.description as descr,"; |
@@ -662,8 +744,11 @@ discard block |
||
662 | 744 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
663 | 745 | $sql.= " WHERE f.entity = " . $conf->entity; |
664 | 746 | $sql.= " AND f.fk_statut in (1,2)"; // Paid (partially or completely) |
665 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
666 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
747 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
748 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
749 | + } else { |
|
750 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
751 | + } |
|
667 | 752 | $sql.= " AND f.rowid = d.".$fk_facture; |
668 | 753 | $sql.= " AND s.rowid = f.fk_soc"; |
669 | 754 | $sql.= " AND pf.".$fk_facture2." = f.rowid"; |
@@ -672,22 +757,31 @@ discard block |
||
672 | 757 | { |
673 | 758 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
674 | 759 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
675 | - } |
|
676 | - else if ($y) |
|
760 | + } else if ($y) |
|
677 | 761 | { |
678 | 762 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
679 | 763 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
680 | 764 | } |
681 | - if ($q) $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
682 | - if ($date_start && $date_end) $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
765 | + if ($q) { |
|
766 | + $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
767 | + } |
|
768 | + if ($date_start && $date_end) { |
|
769 | + $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
770 | + } |
|
683 | 771 | $sql.= " AND (d.product_type = 0"; // Limit to products |
684 | 772 | $sql.= " AND d.date_start is null AND d.date_end IS NULL)"; // enhance detection of products |
685 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
773 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
774 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
775 | + } |
|
686 | 776 | $sql.= " ORDER BY d.rowid, d.".$fk_facture.", pf.rowid"; |
687 | 777 | } |
688 | 778 | |
689 | - if (! $sql) return -1; |
|
690 | - if ($sql == 'TODO') return -2; |
|
779 | + if (! $sql) { |
|
780 | + return -1; |
|
781 | + } |
|
782 | + if ($sql == 'TODO') { |
|
783 | + return -2; |
|
784 | + } |
|
691 | 785 | if ($sql != 'TODO') |
692 | 786 | { |
693 | 787 | dol_syslog("Tax.lib.php::tax_by_rate", LOG_DEBUG); |
@@ -700,14 +794,24 @@ discard block |
||
700 | 794 | while($assoc = $db->fetch_array($resql)) |
701 | 795 | { |
702 | 796 | // Code to avoid warnings when array entry not defined |
703 | - if (! isset($list[$assoc['rate']]['totalht'])) $list[$assoc['rate']]['totalht']=0; |
|
704 | - if (! isset($list[$assoc['rate']]['vat'])) $list[$assoc['rate']]['vat']=0; |
|
705 | - if (! isset($list[$assoc['rate']]['localtax1'])) $list[$assoc['rate']]['localtax1']=0; |
|
706 | - if (! isset($list[$assoc['rate']]['localtax2'])) $list[$assoc['rate']]['localtax2']=0; |
|
797 | + if (! isset($list[$assoc['rate']]['totalht'])) { |
|
798 | + $list[$assoc['rate']]['totalht']=0; |
|
799 | + } |
|
800 | + if (! isset($list[$assoc['rate']]['vat'])) { |
|
801 | + $list[$assoc['rate']]['vat']=0; |
|
802 | + } |
|
803 | + if (! isset($list[$assoc['rate']]['localtax1'])) { |
|
804 | + $list[$assoc['rate']]['localtax1']=0; |
|
805 | + } |
|
806 | + if (! isset($list[$assoc['rate']]['localtax2'])) { |
|
807 | + $list[$assoc['rate']]['localtax2']=0; |
|
808 | + } |
|
707 | 809 | |
708 | - if ($assoc['rowid'] != $oldrowid) // Si rupture sur d.rowid |
|
810 | + if ($assoc['rowid'] != $oldrowid) { |
|
811 | + // Si rupture sur d.rowid |
|
709 | 812 | { |
710 | 813 | $oldrowid=$assoc['rowid']; |
814 | + } |
|
711 | 815 | $list[$assoc['rate']]['totalht'] += $assoc['total_ht']; |
712 | 816 | $list[$assoc['rate']]['vat'] += $assoc['total_vat']; |
713 | 817 | $list[$assoc['rate']]['localtax1'] += $assoc['total_localtax1']; |
@@ -742,8 +846,7 @@ discard block |
||
742 | 846 | |
743 | 847 | $rate = $assoc['rate']; |
744 | 848 | } |
745 | - } |
|
746 | - else |
|
849 | + } else |
|
747 | 850 | { |
748 | 851 | dol_print_error($db); |
749 | 852 | return -3; |
@@ -771,28 +874,35 @@ discard block |
||
771 | 874 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
772 | 875 | $sql.= " WHERE f.entity = " . $conf->entity; |
773 | 876 | $sql.= " AND f.fk_statut in (1,2)"; // Validated or paid (partially or completely) |
774 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
775 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
877 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
878 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
879 | + } else { |
|
880 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
881 | + } |
|
776 | 882 | $sql.= " AND f.rowid = d.".$fk_facture; |
777 | 883 | $sql.= " AND s.rowid = f.fk_soc"; |
778 | 884 | if ($y && $m) |
779 | 885 | { |
780 | 886 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
781 | 887 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
782 | - } |
|
783 | - else if ($y) |
|
888 | + } else if ($y) |
|
784 | 889 | { |
785 | 890 | $sql.= " AND f.datef >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
786 | 891 | $sql.= " AND f.datef <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
787 | 892 | } |
788 | - if ($q) $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
789 | - if ($date_start && $date_end) $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
893 | + if ($q) { |
|
894 | + $sql.= " AND (date_format(f.datef,'%m') > ".(($q-1)*3)." AND date_format(f.datef,'%m') <= ".($q*3).")"; |
|
895 | + } |
|
896 | + if ($date_start && $date_end) { |
|
897 | + $sql.= " AND f.datef >= '".$db->idate($date_start)."' AND f.datef <= '".$db->idate($date_end)."'"; |
|
898 | + } |
|
790 | 899 | $sql.= " AND (d.product_type = 1"; // Limit to services |
791 | 900 | $sql.= " OR d.date_start is NOT null OR d.date_end IS NOT NULL)"; // enhance detection of service |
792 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
901 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
902 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
903 | + } |
|
793 | 904 | $sql.= " ORDER BY d.rowid, d.".$fk_facture; |
794 | - } |
|
795 | - else |
|
905 | + } else |
|
796 | 906 | { |
797 | 907 | // Count on payments date |
798 | 908 | $sql = "SELECT d.rowid, d.product_type as dtype, d.".$fk_facture." as facid, d.$f_rate as rate, d.total_ht as total_ht, d.total_ttc as total_ttc, d.".$total_tva." as total_vat, d.description as descr,"; |
@@ -810,8 +920,11 @@ discard block |
||
810 | 920 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."product as p on d.fk_product = p.rowid"; |
811 | 921 | $sql.= " WHERE f.entity = " . $conf->entity; |
812 | 922 | $sql.= " AND f.fk_statut in (1,2)"; // Paid (partially or completely) |
813 | - if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) $sql.= " AND f.type IN (0,1,2,5)"; |
|
814 | - else $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
923 | + if (! empty($conf->global->FACTURE_DEPOSITS_ARE_JUST_PAYMENTS)) { |
|
924 | + $sql.= " AND f.type IN (0,1,2,5)"; |
|
925 | + } else { |
|
926 | + $sql.= " AND f.type IN (0,1,2,3,5)"; |
|
927 | + } |
|
815 | 928 | $sql.= " AND f.rowid = d.".$fk_facture; |
816 | 929 | $sql.= " AND s.rowid = f.fk_soc"; |
817 | 930 | $sql.= " AND pf.".$fk_facture2." = f.rowid"; |
@@ -820,17 +933,22 @@ discard block |
||
820 | 933 | { |
821 | 934 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
822 | 935 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
823 | - } |
|
824 | - else if ($y) |
|
936 | + } else if ($y) |
|
825 | 937 | { |
826 | 938 | $sql.= " AND pa.datep >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
827 | 939 | $sql.= " AND pa.datep <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
828 | 940 | } |
829 | - if ($q) $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
830 | - if ($date_start && $date_end) $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
941 | + if ($q) { |
|
942 | + $sql.= " AND (date_format(pa.datep,'%m') > ".(($q-1)*3)." AND date_format(pa.datep,'%m') <= ".($q*3).")"; |
|
943 | + } |
|
944 | + if ($date_start && $date_end) { |
|
945 | + $sql.= " AND pa.datep >= '".$db->idate($date_start)."' AND pa.datep <= '".$db->idate($date_end)."'"; |
|
946 | + } |
|
831 | 947 | $sql.= " AND (d.product_type = 1"; // Limit to services |
832 | 948 | $sql.= " OR d.date_start is NOT null OR d.date_end IS NOT NULL)"; // enhance detection of service |
833 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
949 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
950 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.".$total_tva." <> 0)"; |
|
951 | + } |
|
834 | 952 | $sql.= " ORDER BY d.rowid, d.".$fk_facture.", pf.rowid"; |
835 | 953 | } |
836 | 954 | |
@@ -839,7 +957,10 @@ discard block |
||
839 | 957 | dol_syslog("Tax.lib.php::tax_by_rate no accountancy module enabled".$sql,LOG_ERR); |
840 | 958 | return -1; // -1 = Not accountancy module enabled |
841 | 959 | } |
842 | - if ($sql == 'TODO') return -2; // -2 = Feature not yet available |
|
960 | + if ($sql == 'TODO') { |
|
961 | + return -2; |
|
962 | + } |
|
963 | + // -2 = Feature not yet available |
|
843 | 964 | if ($sql != 'TODO') |
844 | 965 | { |
845 | 966 | dol_syslog("Tax.lib.php::tax_by_rate", LOG_DEBUG); |
@@ -851,14 +972,24 @@ discard block |
||
851 | 972 | while($assoc = $db->fetch_array($resql)) |
852 | 973 | { |
853 | 974 | // Code to avoid warnings when array entry not defined |
854 | - if (! isset($list[$assoc['rate']]['totalht'])) $list[$assoc['rate']]['totalht']=0; |
|
855 | - if (! isset($list[$assoc['rate']]['vat'])) $list[$assoc['rate']]['vat']=0; |
|
856 | - if (! isset($list[$assoc['rate']]['localtax1'])) $list[$assoc['rate']]['localtax1']=0; |
|
857 | - if (! isset($list[$assoc['rate']]['localtax2'])) $list[$assoc['rate']]['localtax2']=0; |
|
975 | + if (! isset($list[$assoc['rate']]['totalht'])) { |
|
976 | + $list[$assoc['rate']]['totalht']=0; |
|
977 | + } |
|
978 | + if (! isset($list[$assoc['rate']]['vat'])) { |
|
979 | + $list[$assoc['rate']]['vat']=0; |
|
980 | + } |
|
981 | + if (! isset($list[$assoc['rate']]['localtax1'])) { |
|
982 | + $list[$assoc['rate']]['localtax1']=0; |
|
983 | + } |
|
984 | + if (! isset($list[$assoc['rate']]['localtax2'])) { |
|
985 | + $list[$assoc['rate']]['localtax2']=0; |
|
986 | + } |
|
858 | 987 | |
859 | - if ($assoc['rowid'] != $oldrowid) // Si rupture sur d.rowid |
|
988 | + if ($assoc['rowid'] != $oldrowid) { |
|
989 | + // Si rupture sur d.rowid |
|
860 | 990 | { |
861 | 991 | $oldrowid=$assoc['rowid']; |
992 | + } |
|
862 | 993 | $list[$assoc['rate']]['totalht'] += $assoc['total_ht']; |
863 | 994 | $list[$assoc['rate']]['vat'] += $assoc['total_vat']; |
864 | 995 | $list[$assoc['rate']]['localtax1'] += $assoc['total_localtax1']; |
@@ -893,8 +1024,7 @@ discard block |
||
893 | 1024 | |
894 | 1025 | $rate = $assoc['rate']; |
895 | 1026 | } |
896 | - } |
|
897 | - else |
|
1027 | + } else |
|
898 | 1028 | { |
899 | 1029 | dol_print_error($db); |
900 | 1030 | return -3; |
@@ -904,10 +1034,12 @@ discard block |
||
904 | 1034 | |
905 | 1035 | // CASE OF EXPENSE REPORT |
906 | 1036 | |
907 | - if ($direction == 'buy') // buy only for expense reports |
|
1037 | + if ($direction == 'buy') { |
|
1038 | + // buy only for expense reports |
|
908 | 1039 | { |
909 | 1040 | // Define sql request |
910 | 1041 | $sql=''; |
1042 | + } |
|
911 | 1043 | |
912 | 1044 | // Count on payments date |
913 | 1045 | $sql = "SELECT d.rowid, d.product_type as dtype, e.rowid as facid, d.$f_rate as rate, d.total_ht as total_ht, d.total_ttc as total_ttc, d.total_tva as total_vat, e.note_private as descr,"; |
@@ -924,17 +1056,22 @@ discard block |
||
924 | 1056 | { |
925 | 1057 | $sql.= " AND p.datep >= '".$db->idate(dol_get_first_day($y,$m,false))."'"; |
926 | 1058 | $sql.= " AND p.datep <= '".$db->idate(dol_get_last_day($y,$m,false))."'"; |
927 | - } |
|
928 | - else if ($y) |
|
1059 | + } else if ($y) |
|
929 | 1060 | { |
930 | 1061 | $sql.= " AND p.datep >= '".$db->idate(dol_get_first_day($y,1,false))."'"; |
931 | 1062 | $sql.= " AND p.datep <= '".$db->idate(dol_get_last_day($y,12,false))."'"; |
932 | 1063 | } |
933 | - if ($q) $sql.= " AND (date_format(p.datep,'%m') > ".(($q-1)*3)." AND date_format(p.datep,'%m') <= ".($q*3).")"; |
|
934 | - if ($date_start && $date_end) $sql.= " AND p.datep >= '".$db->idate($date_start)."' AND p.datep <= '".$db->idate($date_end)."'"; |
|
1064 | + if ($q) { |
|
1065 | + $sql.= " AND (date_format(p.datep,'%m') > ".(($q-1)*3)." AND date_format(p.datep,'%m') <= ".($q*3).")"; |
|
1066 | + } |
|
1067 | + if ($date_start && $date_end) { |
|
1068 | + $sql.= " AND p.datep >= '".$db->idate($date_start)."' AND p.datep <= '".$db->idate($date_end)."'"; |
|
1069 | + } |
|
935 | 1070 | $sql.= " AND (d.product_type = -1"; |
936 | 1071 | $sql.= " OR e.date_debut is NOT null OR e.date_fin IS NOT NULL)"; // enhance detection of service |
937 | - if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) $sql.= " AND (d.".$f_rate." <> 0 OR d.total_tva <> 0)"; |
|
1072 | + if (empty($conf->global->MAIN_INCLUDE_ZERO_VAT_IN_REPORTS)) { |
|
1073 | + $sql.= " AND (d.".$f_rate." <> 0 OR d.total_tva <> 0)"; |
|
1074 | + } |
|
938 | 1075 | $sql.= " ORDER BY e.rowid"; |
939 | 1076 | |
940 | 1077 | if (! $sql) |
@@ -942,7 +1079,10 @@ discard block |
||
942 | 1079 | dol_syslog("Tax.lib.php::tax_by_rate no accountancy module enabled".$sql,LOG_ERR); |
943 | 1080 | return -1; // -1 = Not accountancy module enabled |
944 | 1081 | } |
945 | - if ($sql == 'TODO') return -2; // -2 = Feature not yet available |
|
1082 | + if ($sql == 'TODO') { |
|
1083 | + return -2; |
|
1084 | + } |
|
1085 | + // -2 = Feature not yet available |
|
946 | 1086 | if ($sql != 'TODO') |
947 | 1087 | { |
948 | 1088 | dol_syslog("Tax.lib.php::tax_by_rate", LOG_DEBUG); |
@@ -954,14 +1094,24 @@ discard block |
||
954 | 1094 | while($assoc = $db->fetch_array($resql)) |
955 | 1095 | { |
956 | 1096 | // Code to avoid warnings when array entry not defined |
957 | - if (! isset($list[$assoc['rate']]['totalht'])) $list[$assoc['rate']]['totalht']=0; |
|
958 | - if (! isset($list[$assoc['rate']]['vat'])) $list[$assoc['rate']]['vat']=0; |
|
959 | - if (! isset($list[$assoc['rate']]['localtax1'])) $list[$assoc['rate']]['localtax1']=0; |
|
960 | - if (! isset($list[$assoc['rate']]['localtax2'])) $list[$assoc['rate']]['localtax2']=0; |
|
1097 | + if (! isset($list[$assoc['rate']]['totalht'])) { |
|
1098 | + $list[$assoc['rate']]['totalht']=0; |
|
1099 | + } |
|
1100 | + if (! isset($list[$assoc['rate']]['vat'])) { |
|
1101 | + $list[$assoc['rate']]['vat']=0; |
|
1102 | + } |
|
1103 | + if (! isset($list[$assoc['rate']]['localtax1'])) { |
|
1104 | + $list[$assoc['rate']]['localtax1']=0; |
|
1105 | + } |
|
1106 | + if (! isset($list[$assoc['rate']]['localtax2'])) { |
|
1107 | + $list[$assoc['rate']]['localtax2']=0; |
|
1108 | + } |
|
961 | 1109 | |
962 | - if ($assoc['rowid'] != $oldrowid) // Si rupture sur d.rowid |
|
1110 | + if ($assoc['rowid'] != $oldrowid) { |
|
1111 | + // Si rupture sur d.rowid |
|
963 | 1112 | { |
964 | 1113 | $oldrowid=$assoc['rowid']; |
1114 | + } |
|
965 | 1115 | $list[$assoc['rate']]['totalht'] += $assoc['total_ht']; |
966 | 1116 | $list[$assoc['rate']]['vat'] += $assoc['total_vat']; |
967 | 1117 | $list[$assoc['rate']]['localtax1'] += $assoc['total_localtax1']; |
@@ -997,8 +1147,7 @@ discard block |
||
997 | 1147 | |
998 | 1148 | $rate = $assoc['rate']; |
999 | 1149 | } |
1000 | - } |
|
1001 | - else |
|
1150 | + } else |
|
1002 | 1151 | { |
1003 | 1152 | dol_print_error($db); |
1004 | 1153 | return -3; |
@@ -45,13 +45,19 @@ discard block |
||
45 | 45 | */ |
46 | 46 | function ajax_autocompleter($selected, $htmlname, $url, $urloption='', $minLength=2, $autoselect=0, $ajaxoptions=array()) |
47 | 47 | { |
48 | - if (empty($minLength)) $minLength=1; |
|
48 | + if (empty($minLength)) { |
|
49 | + $minLength=1; |
|
50 | + } |
|
49 | 51 | |
50 | 52 | $dataforrenderITem='ui-autocomplete'; |
51 | 53 | $dataforitem='ui-autocomplete-item'; |
52 | 54 | // Allow two constant to use other values for backward compatibility |
53 | - if (defined('JS_QUERY_AUTOCOMPLETE_RENDERITEM')) $dataforrenderITem=constant('JS_QUERY_AUTOCOMPLETE_RENDERITEM'); |
|
54 | - if (defined('JS_QUERY_AUTOCOMPLETE_ITEM')) $dataforitem=constant('JS_QUERY_AUTOCOMPLETE_ITEM'); |
|
55 | + if (defined('JS_QUERY_AUTOCOMPLETE_RENDERITEM')) { |
|
56 | + $dataforrenderITem=constant('JS_QUERY_AUTOCOMPLETE_RENDERITEM'); |
|
57 | + } |
|
58 | + if (defined('JS_QUERY_AUTOCOMPLETE_ITEM')) { |
|
59 | + $dataforitem=constant('JS_QUERY_AUTOCOMPLETE_ITEM'); |
|
60 | + } |
|
55 | 61 | |
56 | 62 | // Input search_htmlname is original field |
57 | 63 | // Input htmlname is a second input field used when using ajax autocomplete. |
@@ -377,13 +383,23 @@ discard block |
||
377 | 383 | |
378 | 384 | // select2 disabled for smartphones with standard browser. |
379 | 385 | // TODO With select2 v4, it seems ok, except that responsive style on table become crazy when scrolling at end of array) |
380 | - if (! empty($conf->browser->layout) && $conf->browser->layout == 'phone') return ''; |
|
386 | + if (! empty($conf->browser->layout) && $conf->browser->layout == 'phone') { |
|
387 | + return ''; |
|
388 | + } |
|
381 | 389 | |
382 | - if (! empty($conf->global->MAIN_DISABLE_AJAX_COMBOX)) return ''; |
|
383 | - if (empty($conf->use_javascript_ajax)) return ''; |
|
384 | - if (empty($conf->global->MAIN_USE_JQUERY_MULTISELECT) && ! defined('REQUIRE_JQUERY_MULTISELECT')) return ''; |
|
390 | + if (! empty($conf->global->MAIN_DISABLE_AJAX_COMBOX)) { |
|
391 | + return ''; |
|
392 | + } |
|
393 | + if (empty($conf->use_javascript_ajax)) { |
|
394 | + return ''; |
|
395 | + } |
|
396 | + if (empty($conf->global->MAIN_USE_JQUERY_MULTISELECT) && ! defined('REQUIRE_JQUERY_MULTISELECT')) { |
|
397 | + return ''; |
|
398 | + } |
|
385 | 399 | |
386 | - if (empty($minLengthToAutocomplete)) $minLengthToAutocomplete=0; |
|
400 | + if (empty($minLengthToAutocomplete)) { |
|
401 | + $minLengthToAutocomplete=0; |
|
402 | + } |
|
387 | 403 | |
388 | 404 | $tmpplugin='select2'; |
389 | 405 | $msg="\n".'<!-- JS CODE TO ENABLE '.$tmpplugin.' for id = '.$htmlname.' --> |
@@ -410,10 +426,13 @@ discard block |
||
410 | 426 | }, |
411 | 427 | dropdownCssClass: \'ui-dialog\' |
412 | 428 | })'; |
413 | - if ($forcefocus) $msg.= '.select2(\'focus\')'; |
|
429 | + if ($forcefocus) { |
|
430 | + $msg.= '.select2(\'focus\')'; |
|
431 | + } |
|
414 | 432 | $msg.= ';'."\n"; |
415 | 433 | |
416 | - if (is_array($events) && count($events)) // If an array of js events to do were provided. |
|
434 | + if (is_array($events) && count($events)) { |
|
435 | + // If an array of js events to do were provided. |
|
417 | 436 | { |
418 | 437 | $msg.= ' |
419 | 438 | jQuery("#'.$htmlname.'").change(function () { |
@@ -463,6 +482,7 @@ discard block |
||
463 | 482 | ); |
464 | 483 | }'; |
465 | 484 | } |
485 | + } |
|
466 | 486 | |
467 | 487 | $msg.= '});'."\n"; |
468 | 488 | $msg.= "</script>\n"; |
@@ -488,10 +508,12 @@ discard block |
||
488 | 508 | |
489 | 509 | if (empty($conf->use_javascript_ajax)) |
490 | 510 | { |
491 | - if (empty($conf->global->$code)) print '<a href="'.$_SERVER['PHP_SELF'].'?action=set_'.$code.'&entity='.$entity.'">'.img_picto($langs->trans("Disabled"),'off').'</a>'; |
|
492 | - else print '<a href="'.$_SERVER['PHP_SELF'].'?action=del_'.$code.'&entity='.$entity.'">'.img_picto($langs->trans("Enabled"),'on').'</a>'; |
|
493 | - } |
|
494 | - else |
|
511 | + if (empty($conf->global->$code)) { |
|
512 | + print '<a href="'.$_SERVER['PHP_SELF'].'?action=set_'.$code.'&entity='.$entity.'">'.img_picto($langs->trans("Disabled"),'off').'</a>'; |
|
513 | + } else { |
|
514 | + print '<a href="'.$_SERVER['PHP_SELF'].'?action=del_'.$code.'&entity='.$entity.'">'.img_picto($langs->trans("Enabled"),'on').'</a>'; |
|
515 | + } |
|
516 | + } else |
|
495 | 517 | { |
496 | 518 | $out= "\n<!-- Ajax code to switch constant ".$code." -->".' |
497 | 519 | <script type="text/javascript"> |
@@ -60,8 +60,11 @@ discard block |
||
60 | 60 | } |
61 | 61 | if (in_array('date',$filter)) |
62 | 62 | { |
63 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
64 | - else $sqlwhere.=" AND"; |
|
63 | + if (empty($sqlwhere)) { |
|
64 | + $sqlwhere=' WHERE '; |
|
65 | + } else { |
|
66 | + $sqlwhere.=" AND"; |
|
67 | + } |
|
65 | 68 | $sqlwhere.= " f.fk_statut > 0"; |
66 | 69 | $sqlwhere.= " AND f.datef >= '".$db->idate($dateafterdate)."'"; |
67 | 70 | $sqlwhere.= " AND f.datef <= '".$db->idate($datebeforedate)."'"; |
@@ -70,17 +73,25 @@ discard block |
||
70 | 73 | if (in_array('nopayment',$filter)) |
71 | 74 | { |
72 | 75 | $sql.= " LEFT JOIN ".MAIN_DB_PREFIX."paiement_facture as pf ON f.rowid = pf.fk_facture"; |
73 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
74 | - else $sqlwhere.=" AND"; |
|
76 | + if (empty($sqlwhere)) { |
|
77 | + $sqlwhere=' WHERE '; |
|
78 | + } else { |
|
79 | + $sqlwhere.=" AND"; |
|
80 | + } |
|
75 | 81 | $sqlwhere.= " f.fk_statut > 0"; |
76 | 82 | $sqlwhere.= " AND pf.fk_paiement IS NULL"; |
77 | 83 | } |
78 | 84 | if (in_array('payments',$filter) || in_array('bank',$filter)) |
79 | 85 | { |
80 | 86 | $sql.= ", ".MAIN_DB_PREFIX."paiement_facture as pf, ".MAIN_DB_PREFIX."paiement as p"; |
81 | - if (in_array('bank',$filter)) $sql.= ", ".MAIN_DB_PREFIX."bank as b"; |
|
82 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
83 | - else $sqlwhere.=" AND"; |
|
87 | + if (in_array('bank',$filter)) { |
|
88 | + $sql.= ", ".MAIN_DB_PREFIX."bank as b"; |
|
89 | + } |
|
90 | + if (empty($sqlwhere)) { |
|
91 | + $sqlwhere=' WHERE '; |
|
92 | + } else { |
|
93 | + $sqlwhere.=" AND"; |
|
94 | + } |
|
84 | 95 | $sqlwhere.= " f.fk_statut > 0"; |
85 | 96 | $sqlwhere.= " AND f.rowid = pf.fk_facture"; |
86 | 97 | $sqlwhere.= " AND pf.fk_paiement = p.rowid"; |
@@ -98,41 +109,62 @@ discard block |
||
98 | 109 | } |
99 | 110 | if (in_array('nodeposit',$filter)) |
100 | 111 | { |
101 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
102 | - else $sqlwhere.=" AND"; |
|
112 | + if (empty($sqlwhere)) { |
|
113 | + $sqlwhere=' WHERE '; |
|
114 | + } else { |
|
115 | + $sqlwhere.=" AND"; |
|
116 | + } |
|
103 | 117 | $sqlwhere.=' type <> 3'; |
104 | 118 | } |
105 | 119 | if (in_array('noreplacement',$filter)) |
106 | 120 | { |
107 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
108 | - else $sqlwhere.=" AND"; |
|
121 | + if (empty($sqlwhere)) { |
|
122 | + $sqlwhere=' WHERE '; |
|
123 | + } else { |
|
124 | + $sqlwhere.=" AND"; |
|
125 | + } |
|
109 | 126 | $sqlwhere.=' type <> 1'; |
110 | 127 | } |
111 | 128 | if (in_array('nocreditnote',$filter)) |
112 | 129 | { |
113 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
114 | - else $sqlwhere.=" AND"; |
|
130 | + if (empty($sqlwhere)) { |
|
131 | + $sqlwhere=' WHERE '; |
|
132 | + } else { |
|
133 | + $sqlwhere.=" AND"; |
|
134 | + } |
|
115 | 135 | $sqlwhere.=' type <> 2'; |
116 | 136 | } |
117 | 137 | if (in_array('excludethirdparties',$filter) && is_array($thirdpartiesid)) |
118 | 138 | { |
119 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
120 | - else $sqlwhere.=" AND"; |
|
139 | + if (empty($sqlwhere)) { |
|
140 | + $sqlwhere=' WHERE '; |
|
141 | + } else { |
|
142 | + $sqlwhere.=" AND"; |
|
143 | + } |
|
121 | 144 | $sqlwhere.=' f.fk_soc NOT IN ('.join(',',$thirdpartiesid).')'; |
122 | 145 | } |
123 | 146 | if (in_array('onlythirdparties',$filter) && is_array($thirdpartiesid)) |
124 | 147 | { |
125 | - if (empty($sqlwhere)) $sqlwhere=' WHERE '; |
|
126 | - else $sqlwhere.=" AND"; |
|
148 | + if (empty($sqlwhere)) { |
|
149 | + $sqlwhere=' WHERE '; |
|
150 | + } else { |
|
151 | + $sqlwhere.=" AND"; |
|
152 | + } |
|
127 | 153 | $sqlwhere.=' f.fk_soc IN ('.join(',',$thirdpartiesid).')'; |
128 | 154 | } |
129 | - if ($sqlwhere) $sql.=$sqlwhere; |
|
130 | - if ($sqlorder) $sql.=$sqlorder; |
|
155 | + if ($sqlwhere) { |
|
156 | + $sql.=$sqlwhere; |
|
157 | + } |
|
158 | + if ($sqlorder) { |
|
159 | + $sql.=$sqlorder; |
|
160 | + } |
|
131 | 161 | |
132 | 162 | //print $sql; exit; |
133 | 163 | dol_syslog("scripts/invoices/rebuild_merge.php:", LOG_DEBUG); |
134 | 164 | |
135 | - if ($usestdout) print '--- start'."\n"; |
|
165 | + if ($usestdout) { |
|
166 | + print '--- start'."\n"; |
|
167 | + } |
|
136 | 168 | |
137 | 169 | // Start of transaction |
138 | 170 | //$db->begin(); |
@@ -175,11 +207,14 @@ discard block |
||
175 | 207 | $filename=$conf->facture->dir_output.'/'.$fac->ref.'/'.$fac->ref.'.pdf'; |
176 | 208 | if ($regenerate || ! dol_is_file($filename)) |
177 | 209 | { |
178 | - if ($usestdout) print "Build PDF for invoice ".$obj->ref." - Lang = ".$outputlangs->defaultlang."\n"; |
|
210 | + if ($usestdout) { |
|
211 | + print "Build PDF for invoice ".$obj->ref." - Lang = ".$outputlangs->defaultlang."\n"; |
|
212 | + } |
|
179 | 213 | $result= $fac->generateDocument($regenerate?$regenerate:$fac->modelpdf, $outputlangs); |
180 | - } |
|
181 | - else { |
|
182 | - if ($usestdout) print "PDF for invoice ".$obj->ref." already exists\n"; |
|
214 | + } else { |
|
215 | + if ($usestdout) { |
|
216 | + print "PDF for invoice ".$obj->ref." already exists\n"; |
|
217 | + } |
|
183 | 218 | } |
184 | 219 | |
185 | 220 | // Add file into files array |
@@ -189,8 +224,11 @@ discard block |
||
189 | 224 | if ($result <= 0) |
190 | 225 | { |
191 | 226 | $error++; |
192 | - if ($usestdout) print "Error: Failed to build PDF for invoice ".($fac->ref?$fac->ref:' id '.$obj->rowid)."\n"; |
|
193 | - else dol_syslog("Failed to build PDF for invoice ".($fac->ref?$fac->ref:' id '.$obj->rowid), LOG_ERR); |
|
227 | + if ($usestdout) { |
|
228 | + print "Error: Failed to build PDF for invoice ".($fac->ref?$fac->ref:' id '.$obj->rowid)."\n"; |
|
229 | + } else { |
|
230 | + dol_syslog("Failed to build PDF for invoice ".($fac->ref?$fac->ref:' id '.$obj->rowid), LOG_ERR); |
|
231 | + } |
|
194 | 232 | } |
195 | 233 | |
196 | 234 | $cpt++; |
@@ -203,8 +241,11 @@ discard block |
||
203 | 241 | $page_hauteur = $formatarray['height']; |
204 | 242 | $format = array($page_largeur,$page_hauteur); |
205 | 243 | |
206 | - if ($usestdout) print "Using output PDF format ".join('x',$format)."\n"; |
|
207 | - else dol_syslog("Using output PDF format ".join('x',$format), LOG_ERR); |
|
244 | + if ($usestdout) { |
|
245 | + print "Using output PDF format ".join('x',$format)."\n"; |
|
246 | + } else { |
|
247 | + dol_syslog("Using output PDF format ".join('x',$format), LOG_ERR); |
|
248 | + } |
|
208 | 249 | |
209 | 250 | |
210 | 251 | // Now, build a merged files with all files in $files array |
@@ -219,14 +260,19 @@ discard block |
||
219 | 260 | } |
220 | 261 | $pdf->SetFont(pdf_getPDFFont($langs)); |
221 | 262 | |
222 | - if ($conf->global->MAIN_DISABLE_PDF_COMPRESSION) $pdf->SetCompression(false); |
|
263 | + if ($conf->global->MAIN_DISABLE_PDF_COMPRESSION) { |
|
264 | + $pdf->SetCompression(false); |
|
265 | + } |
|
223 | 266 | //$pdf->SetCompression(false); |
224 | 267 | |
225 | 268 | // Add all others |
226 | 269 | foreach($files as $file) |
227 | 270 | { |
228 | - if ($usestdout) print "Merge PDF file for invoice ".$file."\n"; |
|
229 | - else dol_syslog("Merge PDF file for invoice ".$file); |
|
271 | + if ($usestdout) { |
|
272 | + print "Merge PDF file for invoice ".$file."\n"; |
|
273 | + } else { |
|
274 | + dol_syslog("Merge PDF file for invoice ".$file); |
|
275 | + } |
|
230 | 276 | |
231 | 277 | // Charge un document PDF depuis un fichier. |
232 | 278 | $pagecount = $pdf->setSourceFile($file); |
@@ -244,40 +290,52 @@ discard block |
||
244 | 290 | |
245 | 291 | // Save merged file |
246 | 292 | $filename=$fileprefix; |
247 | - if (empty($filename)) $filename='mergedpdf'; |
|
248 | - if (! empty($filesuffix)) $filename.='_'.$filesuffix; |
|
293 | + if (empty($filename)) { |
|
294 | + $filename='mergedpdf'; |
|
295 | + } |
|
296 | + if (! empty($filesuffix)) { |
|
297 | + $filename.='_'.$filesuffix; |
|
298 | + } |
|
249 | 299 | $file=$diroutputpdf.'/'.$filename.'.pdf'; |
250 | 300 | |
251 | 301 | if (! $error && $pagecount) |
252 | 302 | { |
253 | 303 | $pdf->Output($file,'F'); |
254 | - if (! empty($conf->global->MAIN_UMASK)) |
|
255 | - @chmod($file, octdec($conf->global->MAIN_UMASK)); |
|
304 | + if (! empty($conf->global->MAIN_UMASK)) { |
|
305 | + @chmod($file, octdec($conf->global->MAIN_UMASK)); |
|
306 | + } |
|
256 | 307 | } |
257 | 308 | |
258 | 309 | if ($usestdout) |
259 | 310 | { |
260 | - if (! $error) print "Merged PDF has been built in ".$file."\n"; |
|
261 | - else print "Can't build PDF ".$file."\n"; |
|
311 | + if (! $error) { |
|
312 | + print "Merged PDF has been built in ".$file."\n"; |
|
313 | + } else { |
|
314 | + print "Can't build PDF ".$file."\n"; |
|
315 | + } |
|
262 | 316 | } |
263 | 317 | |
264 | 318 | $result = 1; |
265 | - } |
|
266 | - else |
|
319 | + } else |
|
267 | 320 | { |
268 | - if ($usestdout) print "No invoices found for criteria.\n"; |
|
269 | - else dol_syslog("No invoices found for criteria"); |
|
321 | + if ($usestdout) { |
|
322 | + print "No invoices found for criteria.\n"; |
|
323 | + } else { |
|
324 | + dol_syslog("No invoices found for criteria"); |
|
325 | + } |
|
270 | 326 | $result = 0; |
271 | 327 | } |
272 | - } |
|
273 | - else |
|
328 | + } else |
|
274 | 329 | { |
275 | 330 | dol_print_error($db); |
276 | 331 | dol_syslog("scripts/invoices/rebuild_merge.php: Error"); |
277 | 332 | $error++; |
278 | 333 | } |
279 | 334 | |
280 | - if ($error) return -1; |
|
281 | - else return $result; |
|
282 | -} |
|
335 | + if ($error) { |
|
336 | + return -1; |
|
337 | + } else { |
|
338 | + return $result; |
|
339 | + } |
|
340 | + } |
|
283 | 341 |