Ejemplo n.º 1
0
            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>&nbsp;</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">';
Ejemplo n.º 2
0
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);
Ejemplo n.º 3
0
        $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();
Ejemplo n.º 4
0
/**
 *	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>';
        }
    }
}
Ejemplo n.º 5
0
    $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 . "&amp;month=" . $next_month . $param . "\">" . img_next($langs->trans("Next"), 'class="valignbottom"') . "</a>\n";
    $nav .= " &nbsp; (<a href=\"?year=" . $nowyear . "&amp;month=" . $nowmonth . $param . "\">" . $langs->trans("Today") . "</a>)";
    $picto = 'calendar';
}
if ($action == 'show_week') {
    $nav = "<a href=\"?year=" . $prev_year . "&amp;month=" . $prev_month . "&amp;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 . "&amp;month=" . $next_month . "&amp;day=" . $next_day . $param . "\">" . img_next($langs->trans("Next"), 'class="valignbottom"') . "</a>\n";
    $nav .= " &nbsp; (<a href=\"?year=" . $nowyear . "&amp;month=" . $nowmonth . "&amp;day=" . $nowday . $param . "\">" . $langs->trans("Today") . "</a>)";
    $picto = 'calendarweek';
}
if ($action == 'show_day') {
    $nav = "<a href=\"?year=" . $prev_year . "&amp;month=" . $prev_month . "&amp;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 . "&amp;month=" . $next_month . "&amp;day=" . $next_day . $param . "\">" . img_next($langs->trans("Next"), 'class="valignbottom"') . "</a>\n";
    $nav .= " &nbsp; (<a href=\"?year=" . $nowyear . "&amp;month=" . $nowmonth . "&amp;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';
Ejemplo n.º 6
0
    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 = '&nbsp;<a href="' . $_SERVER["PHP_SELF"] . '?year=' . ($year_current + 1) . '">' . img_next() . '</a>';
print load_fiche_titre($langs->trans("SuppliersVentilation") . "&nbsp;" . $textprevyear . "&nbsp;" . $langs->trans("Year") . "&nbsp;" . $year_start . "&nbsp;" . $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>';
Ejemplo n.º 7
0
 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 . '&amp;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 . '&amp;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') {
Ejemplo n.º 8
0
 /**
  *    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;
 }
Ejemplo n.º 9
0
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);
Ejemplo n.º 10
0
}
$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);
Ejemplo n.º 11
0
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">&nbsp;</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>";
Ejemplo n.º 12
0
    $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();
Ejemplo n.º 13
0
$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).'&amp;mode='.$mode.'">'.img_previous().'</a> ';
$mesg.= $langs->trans("Year")." $year";
$mesg.= ' <a href="month.php?year='.($year + 1).'&amp;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();
Ejemplo n.º 14
0
            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>&nbsp;</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">';
Ejemplo n.º 15
0
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;
Ejemplo n.º 16
0
/**
 *	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>';
    }
}
Ejemplo n.º 17
0
$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>';
Ejemplo n.º 18
0
// 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&oacute;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);
Ejemplo n.º 19
0
$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 . "&amp;month=" . $prev_month . "&amp;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 . "&amp;month=" . $next_month . "&amp;day=" . $next_day . $param . "\">" . img_next($langs->trans("Next")) . "</a>\n";
$nav .= " &nbsp; (<a href=\"?year=" . $nowyear . "&amp;month=" . $nowmonth . "&amp;day=" . $nowday . $param . "\">" . $langs->trans("Today") . "</a>)";
$picto = 'calendarweek';
$nav .= ' &nbsp; <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 . '">';
Ejemplo n.º 20
0
 $numrows = $db->num_rows($result);
 $i = 0;
 // Ligne Solde debut releve
 print "<tr><td colspan=\"4\"><a href=\"releve.php?num={$num}&amp;ve=1&amp;rel={$rel}&amp;account=" . $acct->id . "\">&nbsp;</a></td>";
 print "<td align=\"right\" colspan=\"2\"><b>" . $langs->trans("InitialBankBalance") . " :</b></td><td align=\"right\"><b>" . price($total) . "</b></td><td>&nbsp;</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&amp;num=' . $num . '&amp;account=' . $acct->id . '&amp;dvid=' . $objp->rowid . '">';
     print img_previous() . '</a> ';
     print dol_print_date($db->jdate($objp->dv), "day") . ' ';
     print '<a href="releve.php?action=dvnext&amp;num=' . $num . '&amp;account=' . $acct->id . '&amp;dvid=' . $objp->rowid . '">';
     print img_next() . '</a>';
     print "</td>\n";
     // Type and num
     if ($objp->fk_type == 'SOLD') {
         $type_label = '&nbsp;';
     } 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 . '&amp;account=' . $acct->id . '">';
     $reg = array();
     preg_match('/\\((.+)\\)/i', $objp->label, $reg);
Ejemplo n.º 21
0
$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 .= '&amp;year=' . $year;
    }
    if ($typeid) {
        $param .= '&amp;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);
Ejemplo n.º 22
0
	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 $');