print "</tr>\n"; $i++; } print '<tr class="liste_total"><td align="right">' . $langs->trans("Total") . " :</td><td class=\"nowrap\" align=\"right\"><b>" . price($total) . "</b></td><td> </td></tr>"; print "</table>"; $db->free($result); } else { dol_print_error($db); } } /* * View */ llxHeader(); $tva = new Tva($db); $textprevyear = "<a href=\"index.php?year=" . ($year_current - 1) . "\">" . img_previous() . "</a>"; $textnextyear = " <a href=\"index.php?year=" . ($year_current + 1) . "\">" . img_next() . "</a>"; print_fiche_titre($langs->trans("VAT"), "{$textprevyear} " . $langs->trans("Year") . " {$year_start} {$textnextyear}"); print $langs->trans("VATReportBuildWithOptionDefinedInModule") . '<br>'; print '(' . $langs->trans("TaxModuleSetupToModifyRules", DOL_URL_ROOT . '/admin/taxes.php') . ')<br>'; print '<br>'; print '<table width="100%" class="notopnoleftnoright">'; print '<tr><td class="notopnoleft" width="50%">'; print_titre($langs->trans("VATSummary")); // The report mode is the one defined by defaut in tax module setup //print $modetax; //print '('.$langs->trans("SeeVATReportInInputOutputMode",'<a href="'.$_SERVER["PHP_SELF"].'?year='.$year_start.'&modetax=0">','</a>').')'; print '</td><td>'; print_titre($langs->trans("VATPaid")); print '</td></tr>'; print '<tr><td class="notopnoleft" width="50%" valign="top">';
if ($resql) { $num = $db->num_rows($resql); $i = 0; while ($i < $num) { $row = $db->fetch_row($resql); $decaiss[$row[1]] = -$row[0]; $i++; } } else { dol_print_error($db); } // Onglets $head = bank_prepare_head($acct); dol_fiche_head($head, 'annual', $langs->trans("FinancialAccount"), 0, 'account'); $title = $langs->trans("FinancialAccount") . " : " . $acct->label; $link = $year_start ? "<a href='" . $_SERVER["PHP_SELF"] . "?account=" . $acct->id . "&year_start=" . ($year_start - 1) . "'>" . img_previous() . "</a> " . $langs->trans("Year") . " <a href='" . $_SERVER["PHP_SELF"] . "?account=" . $acct->id . "&year_start=" . ($year_start + 1) . "'>" . img_next() . "</a>" : ""; print '<table class="border" width="100%">'; $linkback = '<a href="' . DOL_URL_ROOT . '/compta/bank/index.php">' . $langs->trans("BackToList") . '</a>'; // Ref print '<tr><td width="25%">' . $langs->trans("Ref") . '</td>'; print '<td colspan="3">'; if ($_GET["account"]) { if (!preg_match('/,/', $id)) { print $form->showrefnav($acct, 'ref', $linkback, 1, 'ref'); } else { $bankaccount = new Account($db); $listid = explode(',', $id); foreach ($listid as $key => $aId) { $bankaccount->fetch($aId); $bankaccount->label = $bankaccount->ref; print $bankaccount->getNomUrl(1);
$nextyear++; } // For month $link = "<a href='" . $_SERVER["PHP_SELF"] . "?account=" . $account . ($_GET["option"] != 'all' ? '' : '&option=all') . "&year=" . $prevyear . "&month=" . $prevmonth . "'>" . img_previous() . "</a> " . $langs->trans("Month") . " <a href='" . $_SERVER["PHP_SELF"] . "?account=" . $account . "&year=" . $nextyear . "&month=" . $nextmonth . "'>" . img_next() . "</a>"; print '<tr><td align="right">' . $link . '</td></tr>'; print '<tr><td align="center">'; $file = "movement" . $account . "-" . $year . $month . ".png"; print $show4; print '</td></tr>'; print '<tr><td align="center">'; print $show1; print '</td></tr>'; // For year $prevyear = $year - 1; $nextyear = $year + 1; $link = "<a href='" . $_SERVER["PHP_SELF"] . "?account=" . $account . ($_GET["option"] != 'all' ? '' : '&option=all') . "&year=" . $prevyear . "'>" . img_previous() . "</a> " . $langs->trans("Year") . " <a href='" . $_SERVER["PHP_SELF"] . "?account=" . $account . "&year=" . $nextyear . "'>" . img_next() . "</a>"; print '<tr><td align="right">' . $link . '</td></tr>'; print '<tr><td align="center">'; print $show5; print '</td></tr>'; print '<tr><td align="center">'; print $show2; print '</td></tr>'; } if ($mode == 'showalltime') { print '<tr><td align="center">'; print $show3; print '</td></tr>'; } print '</table>'; llxFooter();
/** * Fonction servant a afficher les fleches de navigation dans les pages de listes * * @param int $page Number of page * @param string $file Lien * @param string $options Autres parametres d'url a propager dans les liens ("" par defaut) * @param boolean|int $nextpage Do we show a next page button * @param string $betweenarrows HTML Content to show between arrows * @return void */ function print_fleche_navigation($page, $file, $options = '', $nextpage = 0, $betweenarrows = '') { global $conf, $langs; if ($page > 0) { if (empty($conf->dol_use_jmobile)) { print '<a href="' . $file . '?page=' . ($page - 1) . $options . '">' . img_previous($langs->trans("Previous")) . '</a>'; } else { print '<a data-role="button" data-icon="arrow-l" data-iconpos="left" href="' . $file . '?page=' . ($page - 1) . $options . '">' . $langs->trans("Previous") . '</a>'; } } if ($betweenarrows) { print ($page > 0 ? ' ' : '') . $betweenarrows . ($nextpage > 0 ? ' ' : ''); } if ($nextpage > 0) { if (empty($conf->dol_use_jmobile)) { print '<a href="' . $file . '?page=' . ($page + 1) . $options . '">' . img_next($langs->trans("Next")) . '</a>'; } else { print '<a data-role="button" data-icon="arrow-r" data-iconpos="right" href="' . $file . '?page=' . ($page + 1) . $options . '">' . $langs->trans("Next") . '</a>'; } } }
$nav .= " <span id=\"month_name\">" . dol_print_date(dol_mktime(0, 0, 0, $month, 1, $year), "%b %Y"); $nav .= " </span>\n"; $nav .= "<a href=\"?year=" . $next_year . "&month=" . $next_month . $param . "\">" . img_next($langs->trans("Next"), 'class="valignbottom"') . "</a>\n"; $nav .= " (<a href=\"?year=" . $nowyear . "&month=" . $nowmonth . $param . "\">" . $langs->trans("Today") . "</a>)"; $picto = 'calendar'; } if ($action == 'show_week') { $nav = "<a href=\"?year=" . $prev_year . "&month=" . $prev_month . "&day=" . $prev_day . $param . "\">" . img_previous($langs->trans("Previous"), 'class="valignbottom"') . "</a>\n"; $nav .= " <span id=\"month_name\">" . dol_print_date(dol_mktime(0, 0, 0, $first_month, $first_day, $first_year), "%Y") . ", " . $langs->trans("Week") . " " . $week; $nav .= " </span>\n"; $nav .= "<a href=\"?year=" . $next_year . "&month=" . $next_month . "&day=" . $next_day . $param . "\">" . img_next($langs->trans("Next"), 'class="valignbottom"') . "</a>\n"; $nav .= " (<a href=\"?year=" . $nowyear . "&month=" . $nowmonth . "&day=" . $nowday . $param . "\">" . $langs->trans("Today") . "</a>)"; $picto = 'calendarweek'; } if ($action == 'show_day') { $nav = "<a href=\"?year=" . $prev_year . "&month=" . $prev_month . "&day=" . $prev_day . $param . "\">" . img_previous($langs->trans("Previous"), 'class="valignbottom"') . "</a>\n"; $nav .= " <span id=\"month_name\">" . dol_print_date(dol_mktime(0, 0, 0, $month, $day, $year), "daytextshort"); $nav .= " </span>\n"; $nav .= "<a href=\"?year=" . $next_year . "&month=" . $next_month . "&day=" . $next_day . $param . "\">" . img_next($langs->trans("Next"), 'class="valignbottom"') . "</a>\n"; $nav .= " (<a href=\"?year=" . $nowyear . "&month=" . $nowmonth . "&day=" . $nowday . $param . "\">" . $langs->trans("Today") . "</a>)"; $picto = 'calendarday'; } // Must be after the nav definition $param .= '&year=' . $year . '&month=' . $month . ($day ? '&day=' . $day : ''); //print 'x'.$param; $tabactive = ''; if ($action == 'show_month') { $tabactive = 'cardmonth'; } if ($action == 'show_week') { $tabactive = 'cardweek';
dol_syslog("htdocs/accountancy/customer/index.php fixaccountancycode", LOG_DEBUG); $resql1 = $db->query($sql1); if (!$resql1) { $error++; $db->rollback(); setEventMessage($db->lasterror(), 'errors'); } else { $db->commit(); setEventMessage($langs->trans('Done'), 'mesgs'); } } /* * View */ llxHeader('', $langs->trans("SuppliersVentilation")); $textprevyear = '<a href="' . $_SERVER["PHP_SELF"] . '?year=' . ($year_current - 1) . '">' . img_previous() . '</a>'; $textnextyear = ' <a href="' . $_SERVER["PHP_SELF"] . '?year=' . ($year_current + 1) . '">' . img_next() . '</a>'; print load_fiche_titre($langs->trans("SuppliersVentilation") . " " . $textprevyear . " " . $langs->trans("Year") . " " . $year_start . " " . $textnextyear); print '<b>' . $langs->trans("DescVentilSupplier") . '</b>'; print '<div class="inline-block divButAction">'; print '<a class="butAction" href="' . $_SERVER['PHP_SELF'] . '?year=' . $year_current . '&action=validatehistory">' . $langs->trans("ValidateHistory") . '</a>'; print '<a class="butAction" href="' . $_SERVER['PHP_SELF'] . '?year=' . $year_current . '&action=fixaccountancycode">' . $langs->trans("CleanFixHistory", $year_current) . '</a>'; print '<a class="butAction" href="' . $_SERVER['PHP_SELF'] . '?year=' . $year_current . '&action=cleanaccountancycode">' . $langs->trans("CleanHistory", $year_current) . '</a>'; print '</div>'; $y = $year_current; $var = true; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre"><td width="200" align="left">' . $langs->trans("Account") . '</td>'; print '<td width="200" align="left">' . $langs->trans("Label") . '</td>'; print '<td width="60" align="center">' . $langs->trans("JanuaryMin") . '</td>'; print '<td width="60" align="center">' . $langs->trans("FebruaryMin") . '</td>';
print '<input type="hidden" name="req_nb" value="' . $req_nb . '">'; print '<input type="hidden" name="req_desc" value="' . $req_desc . '">'; print '<input type="hidden" name="req_debit" value="' . $req_debit . '">'; print '<input type="hidden" name="req_credit" value="' . $req_credit . '">'; print '<input type="hidden" name="thirdparty" value="' . $thirdparty . '">'; print '<input type="hidden" name="nbpage" value="' . $totalPages . '">'; print '<input type="hidden" name="id" value="' . $object->id . '">'; print '<input type="hidden" name="req_stdtmonth" value="' . $req_stdtmonth . '">'; print '<input type="hidden" name="req_stdtyear" value="' . $req_stdtyear . '">'; print '<input type="hidden" name="req_stdtday" value="' . $req_stdtday . '">'; print '<input type="hidden" name="req_enddtmonth" value="' . $req_enddtmonth . '">'; print '<input type="hidden" name="req_enddtday" value="' . $req_enddtday . '">'; print '<input type="hidden" name="req_enddtyear" value="' . $req_enddtyear . '">'; $navig = '<div data-role="fieldcontain">'; if ($limitsql > $viewline) { $navig .= '<a href="account.php?' . $param . '&page=' . ($page + 1) . '">' . img_previous() . '</a>'; } $navig .= '<label for="negpage">' . $langs->trans("Page") . "</label> "; // ' Page '; $navig .= '<input type="text" name="negpage" id="negpage" size="1" class="flat" value="' . ($totalPages - $page) . '">'; $navig .= '/' . $totalPages . ' '; if ($total_lines > $limitsql) { $navig .= '<a href="' . $_SERVER["PHP_SELF"] . '?' . $param . '&page=' . ($page - 1) . '">' . img_next() . '</a>'; } $navig .= '</div>'; //var_dump($navig); if ($action != 'addline' && $action != 'delete') { print '<div class="floatright">' . $navig . '</div>'; } // Form to add a transaction with no invoice if ($user->rights->banque->modifier && $action == 'addline') {
/** * Return a HTML area with the reference of object and a navigation bar for a business object * To add a particular filter on select, you must set $object->next_prev_filter to SQL criteria. * @param object Object to show * @param paramid Name of parameter to use to name the id into the URL link * @param morehtml More html content to output just before the nav bar * @param shownav Show Condition (navigation is shown if value is 1) * @param fieldid Nom du champ en base a utiliser pour select next et previous * @param fieldref Nom du champ objet ref (object->ref) a utiliser pour select next et previous * @param morehtmlref Code html supplementaire a afficher apres ref * @param moreparam More param to add in nav link url. * @return string Portion HTML avec ref + boutons nav */ function showrefnav($object, $paramid, $morehtml = '', $shownav = 1, $fieldid = 'rowid', $fieldref = 'ref', $morehtmlref = '', $moreparam = '') { $ret = ''; //print "$paramid,$morehtml,$shownav,$fieldid,$fieldref,$morehtmlref,$moreparam"; $object->load_previous_next_ref(isset($object->next_prev_filter) ? $object->next_prev_filter : '', $fieldid); $previous_ref = $object->ref_previous ? '<a href="' . $_SERVER["PHP_SELF"] . '?' . $paramid . '=' . urlencode($object->ref_previous) . $moreparam . '">' . img_previous() . '</a>' : ''; $next_ref = $object->ref_next ? '<a href="' . $_SERVER["PHP_SELF"] . '?' . $paramid . '=' . urlencode($object->ref_next) . $moreparam . '">' . img_next() . '</a>' : ''; //print "xx".$previous_ref."x".$next_ref; if ($previous_ref || $next_ref || $morehtml) { $ret .= '<table class="nobordernopadding" width="100%"><tr class="nobordernopadding"><td class="nobordernopadding">'; } $ret .= $object->{$fieldref}; if ($morehtmlref) { $ret .= ' ' . $morehtmlref; } if ($morehtml) { $ret .= '</td><td class="nobordernopadding" align="right">' . $morehtml; } if ($shownav && ($previous_ref || $next_ref)) { $ret .= '</td><td class="nobordernopadding" align="center" width="20">' . $previous_ref . '</td>'; $ret .= '<td class="nobordernopadding" align="center" width="20">' . $next_ref; } if ($previous_ref || $next_ref || $morehtml) { $ret .= '</td></tr></table>'; } return $ret; }
llxHeader('', $langs->trans("SpecialExpensesArea")); $title = $langs->trans("SpecialExpensesArea"); if ($_GET["mode"] == 'sconly') { $title = $langs->trans("SocialContributionsPayments"); } $param = ''; if (GETPOST("mode") == 'sconly') { $param = '&mode=sconly'; } if ($sortfield) { $param .= '&sortfield=' . $sortfield; } if ($sortorder) { $param .= '&sortorder=' . $sortorder; } print load_fiche_titre($title, $year ? "<a href='index.php?year=" . ($year - 1) . $param . "'>" . img_previous() . "</a> " . $langs->trans("Year") . " {$year} <a href='index.php?year=" . ($year + 1) . $param . "'>" . img_next() . "</a>" : "", 'title_accountancy.png'); if ($year) { $param .= '&year=' . $year; } if (GETPOST("mode") != 'sconly') { print $langs->trans("DescTaxAndDividendsArea") . '<br>'; print "<br>"; } if ($conf->tax->enabled) { // Social contributions only if (GETPOST("mode") != 'sconly') { print load_fiche_titre($langs->trans("SocialContributionsPayments") . ($year ? ' (' . $langs->trans("Year") . ' ' . $year . ')' : ''), '', ''); } print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print_liste_field_titre($langs->trans("PeriodEndDate"), $_SERVER["PHP_SELF"], "cs.date_ech", "", $param, 'width="140px"', $sortfield, $sortorder);
} $year = GETPOST('year'); if (empty($year)) { $tmpdate = dol_getdate(dol_now()); $year = $tmpdate['year']; } /* * View */ $langs->load('users'); llxHeader(array(), $langs->trans('CPTitreMenu') . ' (' . $langs->trans("Year") . ' ' . $year . ')'); $cp = new Holiday($db); // Recent changes are more important than old changes $log_holiday = $cp->fetchLog('ORDER BY cpl.rowid DESC', " AND date_action BETWEEN '" . $db->idate(dol_get_first_day($year, 1, 1)) . "' AND '" . $db->idate(dol_get_last_day($year, 12, 1)) . "'"); // Load $cp->logs print_fiche_titre($langs->trans('LogCP'), '<a href="' . $_SERVER["PHP_SELF"] . '?year=' . ($year - 1) . '">' . img_previous() . '</a> ' . $langs->trans("Year") . ':' . $year . ' <a href="' . $_SERVER["PHP_SELF"] . '?year=' . ($year + 1) . '">' . img_next() . '</a>'); print '<table class="noborder" width="100%">'; print '<tbody>'; print '<tr class="liste_titre">'; print '<td class="liste_titre">' . $langs->trans('ID') . '</td>'; print '<td class="liste_titre" align="center">' . $langs->trans('Date') . '</td>'; print '<td class="liste_titre">' . $langs->trans('ActionByCP') . '</td>'; print '<td class="liste_titre">' . $langs->trans('UserUpdateCP') . '</td>'; print '<td class="liste_titre">' . $langs->trans('Description') . '</td>'; print '<td class="liste_titre" align="right">' . $langs->trans('PrevSoldeCP') . '</td>'; print '<td class="liste_titre" align="right">' . $langs->trans('NewSoldeCP') . '</td>'; print '</tr>'; $var = true; foreach ($cp->logs as $logs_CP) { $var = !$var; $user_action = new User($db);
if ($localTaxType == 1) { $LT = 'LT1'; $LTSummary = 'LT1Summary'; $LTPaid = 'LT1Paid'; $LTCustomer = 'LT1Customer'; $LTSupplier = 'LT1Supplier'; $CalcLT = $conf->global->MAIN_INFO_LOCALTAX_CALC1; } else { $LT = 'LT2'; $LTSummary = 'LT2Summary'; $LTPaid = 'LT2Paid'; $LTCustomer = 'LT2Customer'; $LTSupplier = 'LT2Supplier'; $CalcLT = $conf->global->MAIN_INFO_LOCALTAX_CALC2; } $textprevyear = "<a href=\"index.php?localTaxType=" . $localTaxType . "&year=" . ($year_current - 1) . "\">" . img_previous() . "</a>"; $textnextyear = " <a href=\"index.php?localTaxType=" . $localTaxType . "&year=" . ($year_current + 1) . "\">" . img_next() . "</a>"; print_fiche_titre($langs->transcountry($LT, $mysoc->country_code), "{$textprevyear} " . $langs->trans("Year") . " {$year_start} {$textnextyear}"); print $langs->trans("LTReportBuildWithOptionDefinedInModule") . '<br>'; print '(' . $langs->trans("TaxModuleSetupToModifyRulesLT", DOL_URL_ROOT . '/admin/company.php') . ')<br>'; print '<br>'; print '<table width="100%" class="nobordernopadding">'; print '<tr><td>'; print_titre($langs->transcountry($LTSummary, $mysoc->country_code)); print '</td><td width="5"> </td><td>'; print_titre($langs->transcountry($LTPaid, $mysoc->country_code)); print '</td></tr>'; print '<tr><td width="50%" valign="top">'; print "<table class=\"noborder\" width=\"100%\">"; print "<tr class=\"liste_titre\">"; print "<td width=\"30%\">" . $langs->trans("Year") . " {$y}</td>";
$prevmonth = $month - 1; $nextmonth = $month + 1; if ($prevmonth < 1) { $prevmonth = 12; $prevyear--; } if ($nextmonth > 12) { $nextmonth = 1; $nextyear++; } // For month $lien = "<a href='" . $_SERVER["PHP_SELF"] . "?id=" . $id . (GETPOST('option', 'string') != 'all' ? '' : '&option=all') . "&year=" . $prevyear . "&month=" . $prevmonth . "'>" . img_previous() . "</a> " . $langs->trans("Month") . " <a href='" . $_SERVER["PHP_SELF"] . "?id=" . $id . "&year=" . $nextyear . "&month=" . $nextmonth . "'>" . img_next() . "</a>"; print '<tr><td align="right">' . $lien . '</td></tr>'; print '<tr><td align="center">'; $file = "movement" . $id . "-" . $year . $month . ".png"; print $show1; print '</td></tr>'; // For year $prevyear = $year - 1; $nextyear = $year + 1; $lien = "<a href='" . $_SERVER["PHP_SELF"] . "?id=" . $id . (GETPOST('option', 'string') != 'all' ? '' : '&option=all') . "&year=" . $prevyear . "'>" . img_previous() . "</a> " . $langs->trans("Year") . " <a href='" . $_SERVER["PHP_SELF"] . "?id=" . $id . "&year=" . $nextyear . "'>" . img_next() . "</a>"; print '<tr><td align="right">' . $lien . '</td></tr>'; print '<tr><td align="center">'; $file = "movement" . $id . "-" . $year . ".png"; print $show2; print '</td></tr>'; } print '</table>'; print "\n</div>\n"; llxFooter(); $db->close();
$mode='customer'; if (isset($_GET["mode"])) $mode=$_GET["mode"]; /* * View */ llxHeader(); $title=$langs->trans("TripsAndExpensesStatistics"); $dir=$conf->deplacement->dir_temp; $mesg = '<a href="month.php?year='.($year - 1).'&mode='.$mode.'">'.img_previous().'</a> '; $mesg.= $langs->trans("Year")." $year"; $mesg.= ' <a href="month.php?year='.($year + 1).'&mode='.$mode.'">'.img_next().'</a>'; print_fiche_titre($title, $mesg); create_exdir($dir); $stats = new DeplacementStats($db, $socid); $data = $stats->getNbByMonth($year); $filename = $dir."/tripsexpensesnb-".$year.".png"; $fileurl = DOL_URL_ROOT.'/viewimage.php?modulepart=tripsexpensesstats&file=tripsexpensesnb-'.$year.'.png'; $px = new DolGraph();
print "</tr>\n"; $i++; } print '<tr class="liste_total"><td align="right">' . $langs->trans("Total") . " :</td><td class=\"nowrap\" align=\"right\"><b>" . price($total) . "</b></td><td> </td></tr>"; print "</table>"; $db->free($result); } else { dol_print_error($db); } } /* * View */ llxHeader(); $tva = new Tva($db); $textprevyear = "<a href=\"index.php?year=" . ($year_current - 1) . "\">" . img_previous($langs->trans("Previous"), 'class="valignbottom"') . "</a>"; $textnextyear = " <a href=\"index.php?year=" . ($year_current + 1) . "\">" . img_next($langs->trans("Next"), 'class="valignbottom"') . "</a>"; print load_fiche_titre($langs->trans("VAT"), "{$textprevyear} " . $langs->trans("Year") . " {$year_start} {$textnextyear}"); print $langs->trans("VATReportBuildWithOptionDefinedInModule") . '<br>'; print '(' . $langs->trans("TaxModuleSetupToModifyRules", DOL_URL_ROOT . '/admin/taxes.php') . ')<br>'; print '<br>'; print '<table width="100%" class="notopnoleftnoright">'; print '<tr><td class="notopnoleft" width="50%">'; print load_fiche_titre($langs->trans("VATSummary")); // The report mode is the one defined by defaut in tax module setup //print $modetax; //print '('.$langs->trans("SeeVATReportInInputOutputMode",'<a href="'.$_SERVER["PHP_SELF"].'?year='.$year_start.'&modetax=0">','</a>').')'; print '</td><td>'; print load_fiche_titre($langs->trans("VATPaid")); print '</td></tr>'; print '<tr><td class="notopnoleft" width="50%" valign="top">';
llxHeader('', $langs->trans("SpecialExpensesArea")); $title = $langs->trans("SpecialExpensesArea"); if ($_GET["mode"] == 'sconly') { $title = $langs->trans("SocialContributionsPayments"); } $param = ''; if (GETPOST("mode") == 'sconly') { $param = '&mode=sconly'; } if ($sortfield) { $param .= '&sortfield=' . $sortfield; } if ($sortorder) { $param .= '&sortorder=' . $sortorder; } print_fiche_titre($title, $year ? "<a href='index.php?year=" . ($year - 1) . $param . "'>" . img_previous() . "</a> " . $langs->trans("Year") . " {$year} <a href='index.php?year=" . ($year + 1) . $param . "'>" . img_next() . "</a>" : ""); if ($year) { $param .= '&year=' . $year; } if (GETPOST("mode") != 'sconly') { print $langs->trans("DescTaxAndDividendsArea") . '<br>'; print "<br>"; } // Payment Salary if ($conf->salaries->enabled) { if (empty($_GET["mode"]) || $_GET["mode"] != 'sconly') { $sal = new PaymentSalary($db); print_fiche_titre($langs->trans("SalariesPayments") . ($year ? ' (' . $langs->trans("Year") . ' ' . $year . ')' : ''), '', ''); $sql = "SELECT s.rowid, s.amount, s.label, s.datev as dm"; $sql .= " FROM " . MAIN_DB_PREFIX . "payment_salary as s"; $sql .= " WHERE s.entity = " . $conf->entity;
/** * Fonction servant a afficher les fleches de navigation dans les pages de listes * @param page Numero of page * @param file Lien * @param options Autres parametres d'url a propager dans les liens ("" par defaut) * @param nextpage Faut-il une page suivante * @param betweenarrows HTML Content to show between arrows */ function print_fleche_navigation($page, $file, $options = '', $nextpage, $betweenarrows = '') { global $conf, $langs; if ($page > 0) { print '<a href="' . $file . '?page=' . ($page - 1) . $options . '">' . img_previous($langs->trans("Previous")) . '</a>'; } if ($betweenarrows) { print ($page > 0 ? ' ' : '') . $betweenarrows . ($nextpage > 0 ? ' ' : ''); } if ($nextpage > 0) { print '<a href="' . $file . '?page=' . ($page + 1) . $options . '">' . img_next($langs->trans("Next")) . '</a>'; } }
$langs->load("bills"); $langs->load("other"); // Filter $year = $_GET["year"]; if ($year == 0) { $year_current = strftime("%Y", time()); $year_start = $year_current; } else { $year_current = $year; $year_start = $year; } /* * View */ llxHeader('', 'Compta - Ventilation'); $textprevyear = "<a href=\"paiement_mois.php?year=" . ($year_current - 1) . "\">" . img_previous() . "</a>"; $textnextyear = " <a href=\"paiement_mois.php?year=" . ($year_current + 1) . "\">" . img_next() . "</a>"; print_fiche_titre($langs->trans("Encaissement") . " " . $textprevyear . " " . $langs->trans("Year") . " " . $year_start . " " . $textnextyear); print '<table border="0" width="100%" class="notopnoleftnoright">'; print '<tr><td valign="top" width="30%" class="notopnoleft">'; $y = $year_current; $var = true; print '<table class="noborder" width="100%">'; print "</table>\n"; print '</td><td valign="top" width="70%" class="notopnoleftnoright"></td>'; print '</tr><tr><td colspan=2>'; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre"><td width=150>' . $langs->trans("Appartement") . '</td>'; print '<td align="center">' . $langs->trans("January") . '</td>'; print '<td align="center">' . $langs->trans("February") . '</td>'; print '<td align="center">' . $langs->trans("March") . '</td>';
// Security check if ($user->societe_id > 0) { $socid = $user->societe_id; } if (!$user->rights->pos->stats) { accessforbidden(); } /* * View */ $helpurl = 'EN:Module_DoliPos|FR:Module_DoliPos_FR|ES:Módulo_DoliPos'; llxHeader('', '', $helpurl); $html = new Form($db); $nom = $langs->trans("SalesTurnover"); $period = "{$year_start} - {$year_end}"; $periodlink = $year_start ? "<a href='" . $_SERVER["PHP_SELF"] . "?year_start=" . ($year_start - 1) . "&modecompta=" . $modecompta . "'>" . img_previous() . "</a> <a href='" . $_SERVER["PHP_SELF"] . "?year_start=" . ($year_start + 1) . "&modecompta=" . $modecompta . "'>" . img_next() . "</a>" : ""; $description = $langs->trans("RulesResult"); $builddate = time(); report_header($nom, $nomlink, $period, $periodlink, $description, $builddate, $exportlink); $sql = "SELECT date_format(f.date_valid,'%Y-%m') as dm, sum(f.total_ttc) as amount_ttc"; $sql .= " FROM " . MAIN_DB_PREFIX . "facture as f"; $sql .= ", " . MAIN_DB_PREFIX . "pos_facture as pf"; $sql .= " WHERE f.fk_statut in (1,2,3,4)"; $sql .= " AND f.rowid = pf.fk_facture"; $sql .= " AND f.entity = " . $conf->entity; if ($socid) { $sql .= " AND f.fk_soc = " . $socid; } $sql .= " GROUP BY dm"; $sql .= " ORDER BY dm"; $result = $db->query($sql);
$first_year = $prev['first_year']; $week = $prev['week']; $day = (int) $day; $next = dol_get_next_week($first_day, $week, $first_month, $first_year); $next_year = $next['year']; $next_month = $next['month']; $next_day = $next['day']; // Define firstdaytoshow and lastdaytoshow (warning: lastdaytoshow is last second to show + 1) $firstdaytoshow = dol_mktime(0, 0, 0, $first_month, $first_day, $first_year); $lastdaytoshow = dol_time_plus_duree($firstdaytoshow, 7, 'd'); //print $firstday.'-'.$first_month.'-'.$first_year; //print dol_print_date($firstdaytoshow,'dayhour'); //print dol_print_date($lastdaytoshow,'dayhour'); $max_day_in_month = date("t", dol_mktime(0, 0, 0, $month, 1, $year)); $tmpday = $first_day; $nav = "<a href=\"?year=" . $prev_year . "&month=" . $prev_month . "&day=" . $prev_day . $param . "\">" . img_previous($langs->trans("Previous")) . "</a>\n"; $nav .= " <span id=\"month_name\">" . dol_print_date(dol_mktime(0, 0, 0, $first_month, $first_day, $first_year), "%Y") . ", " . $langs->trans("Week") . " " . $week; $nav .= " </span>\n"; $nav .= "<a href=\"?year=" . $next_year . "&month=" . $next_month . "&day=" . $next_day . $param . "\">" . img_next($langs->trans("Next")) . "</a>\n"; $nav .= " (<a href=\"?year=" . $nowyear . "&month=" . $nowmonth . "&day=" . $nowday . $param . "\">" . $langs->trans("Today") . "</a>)"; $picto = 'calendarweek'; $nav .= ' <form name="dateselect" action="' . $_SERVER["PHP_SELF"] . '?action=show_peruser' . $param . '">'; $nav .= '<input type="hidden" name="token" value="' . $_SESSION['newtoken'] . '">'; $nav .= '<input type="hidden" name="action" value="' . $action . '">'; $nav .= '<input type="hidden" name="usertodo" value="' . $filtert . '">'; $nav .= '<input type="hidden" name="usergroup" value="' . $usergroup . '">'; $nav .= '<input type="hidden" name="actioncode" value="' . $actioncode . '">'; $nav .= '<input type="hidden" name="status" value="' . $status . '">'; $nav .= '<input type="hidden" name="socid" value="' . $socid . '">'; $nav .= '<input type="hidden" name="projectid" value="' . $projectid . '">'; $nav .= '<input type="hidden" name="begin_h" value="' . $begin_h . '">';
$numrows = $db->num_rows($result); $i = 0; // Ligne Solde debut releve print "<tr><td colspan=\"4\"><a href=\"releve.php?num={$num}&ve=1&rel={$rel}&account=" . $acct->id . "\"> </a></td>"; print "<td align=\"right\" colspan=\"2\"><b>" . $langs->trans("InitialBankBalance") . " :</b></td><td align=\"right\"><b>" . price($total) . "</b></td><td> </td></tr>\n"; while ($i < $numrows) { $objp = $db->fetch_object($result); $total = $total + $objp->amount; $var = !$var; print "<tr " . $bc[$var] . ">"; // Date operation print '<td class="nowrap" align="center">' . dol_print_date($db->jdate($objp->do), "day") . '</td>'; // Date de valeur print '<td align="center" valign="center" class="nowrap">'; print '<a href="releve.php?action=dvprev&num=' . $num . '&account=' . $acct->id . '&dvid=' . $objp->rowid . '">'; print img_previous() . '</a> '; print dol_print_date($db->jdate($objp->dv), "day") . ' '; print '<a href="releve.php?action=dvnext&num=' . $num . '&account=' . $acct->id . '&dvid=' . $objp->rowid . '">'; print img_next() . '</a>'; print "</td>\n"; // Type and num if ($objp->fk_type == 'SOLD') { $type_label = ' '; } else { $type_label = $langs->trans("PaymentTypeShort" . $objp->fk_type) != "PaymentTypeShort" . $objp->fk_type ? $langs->trans("PaymentTypeShort" . $objp->fk_type) : $objp->fk_type; } print '<td class="nowrap">' . $type_label . ' ' . ($objp->num_chq ? $objp->num_chq : '') . '</td>'; // Description print '<td valign="center"><a href="' . DOL_URL_ROOT . '/compta/bank/ligne.php?rowid=' . $objp->rowid . '&account=' . $acct->id . '">'; $reg = array(); preg_match('/\\((.+)\\)/i', $objp->label, $reg);
$sql .= $db->order($sortfield, $sortorder); $sql .= $db->plimit($limit + 1, $offset); $resql = $db->query($sql); if ($resql) { $num = $db->num_rows($resql); $i = 0; $var = true; $param = ''; if ($year) { $param .= '&year=' . $year; } if ($typeid) { $param .= '&typeid=' . $typeid; } if ($year) { print_fiche_titre($langs->trans("SocialContributions"), $year ? "<a href='index.php?year=" . ($year - 1) . "'>" . img_previous() . "</a> " . $langs->trans("Year") . " {$year} <a href='index.php?year=" . ($year + 1) . "'>" . img_next() . "</a>" : ""); } else { print_barre_liste($langs->trans("SocialContributions"), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, $totalnboflines); } dol_htmloutput_mesg($mesg); if (empty($mysoc->country_id) && empty($mysoc->country_code)) { print '<div class="error">'; $langs->load("errors"); $countrynotdefined = $langs->trans("ErrorSetACountryFirst"); print $countrynotdefined; print '</div>'; } else { print '<form method="GET" action="' . $_SERVER["PHP_SELF"] . '">'; print "<table class=\"noborder\" width=\"100%\">"; print "<tr class=\"liste_titre\">"; print_liste_field_titre($langs->trans("Ref"), $_SERVER["PHP_SELF"], "id", "", $param, "", $sortfield, $sortorder);
print "</td></tr></table>"; } /* * View */ llxHeader(); $cyear = isset($_GET["year"])?$_GET["year"]:0; if (! $cyear) { $cyear = strftime ("%Y", time()); } print_fiche_titre("Chiffre d'Affaire transform� (pr�vu-r�alis�)",($cyear?"<a href='comp.php?year=".($cyear-1)."'>".img_previous()."</a> Ann�e $cyear <a href='comp.php?year=".($cyear+1)."'>".img_next()."</a>":"")); ppt($db, $cyear, $socid); if ($details == 1) { print "<TABLE border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"4\"><tr><td valign=\"top\" width=\"50%\">"; factures ($db, $year, $month, 1); print "</td><td valign=\"top\" width=\"50%\">"; propals ($db, $year, $month); print "</td></tr></table>"; } $db->close(); llxFooter('$Date: 2011/07/31 22:23:14 $ - $Revision: 1.45 $');