function _liste()
{
    global $langs, $db, $user, $conf;
    $langs->load('asset@asset');
    llxHeader('', $langs->trans('ListControl'), '', '');
    getStandartJS();
    if (isset($_SESSION['AssetMsg'])) {
        print_r('<div class="info">' . $langs->trans($_SESSION['AssetMsg']) . '</div>');
        unset($_SESSION['AssetMsg']);
    }
    $form = new TFormCore();
    $assetControl = new TAssetControl();
    $r = new TSSRenderControler($assetControl);
    $sql = 'SELECT rowid as id, libelle, type, question, "" as action FROM ' . MAIN_DB_PREFIX . 'asset_control';
    $THide = array('id');
    $form = new TFormCore($_SERVER['PHP_SELF'], 'form', 'GET');
    $ATMdb = new TPDOdb();
    $r->liste($ATMdb, $sql, array('limit' => array('nbLine' => '30'), 'subQuery' => array(), 'link' => array('libelle' => '<a href="' . DOL_URL_ROOT . '/custom/asset/control.php?id=@id@">' . img_picto('', 'object_generic.png', '', 0) . '@val@</a>', 'question' => '<a href="' . DOL_URL_ROOT . '/custom/asset/control.php?id=@id@">@val@</a>', 'action' => '<a title="Modifier" href="control.php?id=@id@&action=edit">' . img_picto('', 'edit.png', '', 0) . '</a>&nbsp;&nbsp;&nbsp;<a title="Supprimer" onclick="if (!window.confirm(\'Confirmez-vous la suppression ?\')) return false;" href="control.php?id=@id@&action=delete">' . img_picto('', 'delete.png', '', 0) . "</a>"), 'search' => array('libelle' => array('recherche' => true, 'table' => '')), 'translate' => array(), 'hide' => $THide, 'liste' => array('titre' => $langs->trans('ListControl'), 'image' => img_picto('', 'title.png', '', 0), 'picto_precedent' => img_picto('', 'back.png', '', 0), 'picto_suivant' => img_picto('', 'next.png', '', 0), 'noheader' => 0, 'messageNothing' => $langs->trans('AssetEmptyControl'), 'picto_search' => img_picto('', 'search.png', '', 0)), 'title' => array('libelle' => 'Libelle', 'type' => 'Type', 'nb_value' => 'Nombre de valeurs associƩs', 'question' => 'Question', 'action' => 'Action'), 'eval' => array('type' => 'TAssetControl::$TType["@val@"]')));
    $form->end();
    echo '<div class="tabsAction">';
    echo '<a class="butAction" href="control.php?action=new">' . $langs->trans('AssetCreateControl') . '</a>';
    echo '</div>';
    $ATMdb->close();
    llxFooter('');
}
function _list(&$PDOdb)
{
    global $langs, $conf, $user, $db;
    llxHeader();
    dol_fiche_head(array(), 'menu', 'Menu');
    $l = new TListviewTBS('lMenu');
    $sql = "SELECT rowid,title, type_menu, tab_object, mainmenu,leftmenu,date_cre \n\tFROM " . MAIN_DB_PREFIX . "query_menu \n\tWHERE entity IN (0," . $conf->entity . ")";
    $menu_static = new TQueryMenu();
    echo $l->render($PDOdb, $sql, array('title' => array('title' => $langs->trans('Title'), 'leftmenu' => $langs->trans('LeftMenu'), 'mainmenu' => $langs->trans('MainMenu'), 'date_cre' => $langs->trans('Date'), 'tab_object' => $langs->trans('TabsObject'), 'type_menu' => $langs->trans('TypeMenu')), 'translate' => array('tab_object' => $menu_static->TTabObject, 'type_menu' => $menu_static->TTypeMenu), 'link' => array('title' => '<a href="?id=@rowid@&action=edit">@val@</a>'), 'hide' => array('rowid'), 'type' => array('date_cre' => 'date')));
    /*$kiwi = new TKiwi;
    	$kiwi->fk_soc = $object->id;
    	$kiwi->fk_product = 1;
    	$kiwi->save($PDOdb);
    	*/
    // pied de page
    dol_fiche_end();
    llxFooter();
}
Example #3
0
			print '</td><td valign="top" width="50%">';

			// Rien a droite

			print '</td></tr></table>';

			if ($expedition->origin_id)
			{
				print '<br>';
				//show_list_sending_receive($expedition->origin,$expedition->origin_id," AND e.rowid <> ".$expedition->id);
				show_list_sending_receive($expedition->origin,$expedition->origin_id);
			}
		}
		else
		{
			/* Expedition non trouvee */
			print "Expedition inexistante ou acces refuse";
		}
	}
	else
	{
		/* Expedition non trouvee */
		print "Expedition inexistante ou acces refuse";
	}
}

$db->close();

llxFooter('$Date: 2011/07/31 23:24:38 $ - $Revision: 1.114 $');
?>
Example #4
0
				$i++;
			}

			print '<tr class="liste_total">';
			print "<td colspan=\"5\" align=\"left\">".$langs->trans("Total").": </td>";
			print "<td align=\"right\"><b>".price($total_ht)."</b></td>";
			print "<td align=\"right\"><b>".price($total_ttc)."</b></td>";
			print "<td align=\"right\"><b>".price($total_paid)."</b></td>";
			print '<td align="center">&nbsp;</td>';
			print "</tr>\n";
		}

		print "</table>";
		$db->free();
	}
	else
	{
		dol_print_error($db);
	}

}




$db->close();

llxFooter('$Date: 2011/07/31 23:57:01 $ - $Revision: 1.25 $');
?>
Example #5
0
    $resql = $db->query($sql);
    if ($resql) {
        $num = $db->num_rows($resql);
        $i = 0;
        $var = True;
        print_barre_liste($langs->trans('Payments'), $page, 'paiement.php', '', $sortfield, $sortorder, '', $num);
        print '<table class="noborder" width="100%">';
        print '<tr class="liste_titre">';
        print_liste_field_titre($langs->trans('Invoice'), 'paiement.php', 'facnumber', '', '', '', $sortfield, $sortorder);
        print_liste_field_titre($langs->trans('Date'), 'paiement.php', 'dp', '', '', '', $sortfield, $sortorder);
        print_liste_field_titre($langs->trans('Type'), 'paiement.php', 'libelle', '', '', '', $sortfield, $sortorder);
        print_liste_field_titre($langs->trans('Amount'), 'paiement.php', 'fa_amount', '', '', 'align="right"', $sortfield, $sortorder);
        print '<td>&nbsp;</td>';
        print "</tr>\n";
        while ($i < min($num, $limit)) {
            $objp = $db->fetch_object($resql);
            $var = !$var;
            print '<tr ' . $bc[$var] . '>';
            print '<td><a href="facture.php?facid=' . $objp->facid . '">' . $objp->facnumber . "</a></td>\n";
            print '<td>' . dol_print_date($db->jdate($objp->dp)) . "</td>\n";
            print '<td>' . $objp->paiement_type . ' ' . $objp->num_paiement . "</td>\n";
            print '<td align="right">' . price($objp->amount) . '</td><td>&nbsp;</td>';
            print '</tr>';
            $i++;
        }
        print '</table>';
    }
}
$db->close();
llxFooter('$Date: 2011/08/08 01:01:46 $ - $Revision: 1.114 $');
Example #6
0
    // Add action
    if ($conf->agenda->enabled && !empty($conf->global->MAIN_REPEATTASKONEACHTAB)) {
        if ($user->rights->agenda->myactions->create) {
            print '<a class="butAction" href="' . DOL_URL_ROOT . '/comm/action/fiche.php?action=create&socid=' . $objsoc->id . '">' . $langs->trans("AddAction") . '</a>';
        } else {
            print '<a class="butAction" title="' . dol_escape_js($langs->trans("NotAllowed")) . '" href="#">' . $langs->trans("AddAction") . '</a>';
        }
    }
    /*if ($user->rights->societe->contact->creer)
    	{
    		print '<a class="butAction" href="'.DOL_URL_ROOT.'/contact/fiche.php?socid='.$objsoc->id.'&amp;action=create">'.$langs->trans("AddContact").'</a>';
    	}*/
    print '</div>';
    print "<br>\n";
    if (!empty($conf->global->MAIN_REPEATCONTACTONEACHTAB)) {
        print '<br>';
        // List of contacts
        show_contacts($conf, $langs, $db, $objsoc, $_SERVER["PHP_SELF"] . '?socid=' . $objsoc->id);
    }
    if (!empty($conf->global->MAIN_REPEATTASKONEACHTAB)) {
        // List of todo actions
        show_actions_todo($conf, $langs, $db, $objsoc);
        // List of done actions
        show_actions_done($conf, $langs, $db, $objsoc);
    }
} else {
    dol_print_error($db, 'Bad value for socid parameter');
}
$db->close();
llxFooter('$Date: 2011/08/08 16:15:05 $ - $Revision: 1.283 $');
Example #7
0
print '<li>';
//print $langs->trans("SeeWikiPage",'http://wiki.dolibarr.org/index.php/List_of_OpenSource_Software_companies_and_freelancers');
print '<a target="_blank" href="'.DOL_URL_ROOT.'/support/index.php">'.$langs->trans("HelpCenter").'</a>';
print '</li>';
print '</ul>';


print '<br>'.$langs->trans("MakeADonation").':<br>';

print '<ul>';
print '<form action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_blank">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="hosted_button_id" value="6573525">';
print '<input class="none" type="image" src="'.DOL_URL_ROOT.'/theme/common/paypal.png" border="0" name="submit" alt="Help Dolibarr making a donation">';
print '</form>';
print '</ul>';


llxFooter('$Date: 2011/07/31 22:23:14 $ - $Revision: 1.5 $');
?>










Example #8
0
 */

print '<div class="tabsAction">';

if ($_GET["action"] != 'create' && $_GET["action"] != 'edit')
{
	if ($user->rights->deplacement->creer)
	{
		print '<a class="butAction" href="fiche.php?action=edit&id='.$id.'">'.$langs->trans('Modify').'</a>';
	}
	else
	{
		print '<a class="butActionRefused" href="#" title="'.dol_escape_htmltag($langs->trans("NotAllowed")).'">'.$langs->trans('Modify').'</a>';
	}
	if ($user->rights->deplacement->supprimer)
	{
		print '<a class="butActionDelete" href="fiche.php?action=delete&id='.$id.'">'.$langs->trans('Delete').'</a>';
	}
	else
	{
		print '<a class="butActionRefused" href="#" title="'.dol_escape_htmltag($langs->trans("NotAllowed")).'">'.$langs->trans('Delete').'</a>';
	}
}

print '</div>';

$db->close();

llxFooter('$Date: 2011/08/03 00:46:35 $ - $Revision: 1.56 $');
?>
Example #9
0
					print dol_print_date($db->jdate($objp->date_contrat))."</td>";
					//print "<td align=\"right\">".price($objp->total_ht)."</td>\n";
					//print '<td align="right">';
					print '<td align="center">'.($objp->nb_initial>0?$objp->nb_initial:'').'</td>';
					print '<td align="center">'.($objp->nb_running+$objp->nb_late>0?$objp->nb_running+$objp->nb_late:'').'</td>';
					print '<td align="center">'.($objp->nb_closed>0?$objp->nb_closed:'').'</td>';
					//$contratstatic->LibStatut($objp->statut,5).'</td>';
					print "</tr>\n";
					$i++;
				}
			}
		}
		else
		{
			dol_print_error($db);
		}
		print "</table>";
		print '<br>';
		$db->free($result);
	}
}
else
{
	dol_print_error();
}

$db->close();

llxFooter('$Date: 2011/08/08 16:07:48 $ - $Revision: 1.47 $');
?>
Example #10
0
/**
 *	Show a message to say access is forbidden and stop program
 *	Calling this function terminate execution of PHP.
 *
 *	@param	string	$message			    Force error message
 *	@param	int		$printheader		    Show header before
 *  @param  int		$printfooter         Show footer after
 *  @param  int		$showonlymessage     Show only message parameter. Otherwise add more information.
 *  @return	void
 */
function accessforbidden($message = '', $printheader = 1, $printfooter = 1, $showonlymessage = 0)
{
    global $conf, $db, $user, $langs;
    if (!is_object($langs)) {
        include_once DOL_DOCUMENT_ROOT . '/core/class/translate.class.php';
        $langs = new Translate('', $conf);
    }
    $langs->load("errors");
    if ($printheader) {
        if (function_exists("llxHeader")) {
            llxHeader('');
        } else {
            if (function_exists("llxHeaderVierge")) {
                llxHeaderVierge('');
            }
        }
    }
    print '<div class="error">';
    if (!$message) {
        print $langs->trans("ErrorForbidden");
    } else {
        print $message;
    }
    print '</div>';
    print '<br>';
    if (empty($showonlymessage)) {
        if ($user->login) {
            print $langs->trans("CurrentLogin") . ': <font class="error">' . $user->login . '</font><br>';
            print $langs->trans("ErrorForbidden2", $langs->trans("Home"), $langs->trans("Users"));
        } else {
            print $langs->trans("ErrorForbidden3");
        }
    }
    if ($printfooter && function_exists("llxFooter")) {
        llxFooter();
    }
    exit(0);
}
Example #11
0
				print '</td>';
            }
            print '<td align="center" nowrap="nowrap">';
            print img_tick();
            print '</td>';
        }
        else
        {
            // Do not own permission
            if ($caneditperms)
            {
                print '<td align="center"><a href="perms.php?id='.$fuser->id.'&amp;action=addrights&amp;rights='.$obj->id.'#'.$objMod->getName().'">'.img_edit_add($langs->trans("Add")).'</a></td>';
            }
            print '<td>&nbsp</td>';
        }

        $perm_libelle=($conf->global->MAIN_USE_ADVANCED_PERMS && ($langs->trans("PermissionAdvanced".$obj->id)!=("PermissionAdvanced".$obj->id))?$langs->trans("PermissionAdvanced".$obj->id):(($langs->trans("Permission".$obj->id)!=("Permission".$obj->id))?$langs->trans("Permission".$obj->id):$obj->libelle));
        print '<td>'.$perm_libelle. '</td>';

        print '</tr>'."\n";

        $i++;
    }
}
print '</table>';

$db->close();

llxFooter('$Date: 2011/08/01 13:15:54 $ - $Revision: 1.57 $');
?>
Example #12
0
  $var=True;
  while ($i < $num)
  {
    $objp = $dbosc->fetch_object($resql);
    $var=!$var;
    print "<TR $bc[$var]>";
    print "<TD>$objp->products_id</TD>\n";
    print "<TD>$objp->products_model</TD>\n";
    print "<TD>$objp->products_name</TD>\n";
    print "<TD>$objp->manufacturers_name</TD>\n";
    print '<TD align="center">'.$objp->products_quantity."</TD>\n";
    print '<TD align="center">'.$objp->products_status."</TD>\n";
    print "</TR>\n";
    $i++;
  }
  $dbosc->free();
}
else
{
	dol_print_error($dbosc);
}

print "</TABLE>";


$dbosc->close();

llxFooter('$Date: 2011/08/03 00:45:45 $ - $Revision: 1.10 $');
?>
Example #13
0
print '<!-- Form to crop -->'."\n";
print '<fieldset id="redim_file">';
print '<legend>'.$langs->trans("Recenter").'</legend>';
print $langs->trans("DefineNewAreaToPick").'...<br>';
print '<br><center>';
print '<div style="border: 1px solid #888888; width: '.$width.'px;"><img src="'.DOL_URL_ROOT.'/viewimage.php?modulepart=product&file='.$original_file.'" alt="" id="cropbox" /></div>';
print '</center><br>';
print '<form action="'.$_SERVER["PHP_SELF"].'?id='.$_GET['id'].'" method="post" onsubmit="return checkCoords();">
      <div class="jc_coords">
         '.$langs->trans("NewSizeAfterCropping").':
         <label>X1 <input type="text" size="4" id="x" name="x" /></label>
         <label>Y1 <input type="text" size="4" id="y" name="y" /></label>
         <label>X2 <input type="text" size="4" id="x2" name="x2" /></label>
         <label>Y2 <input type="text" size="4" id="y2" name="y2" /></label>
         <label>W <input type="text" size="4" id="w" name="w" /></label>
         <label>H <input type="text" size="4" id="h" name="h" /></label>
      </div>

      <input type="hidden" id="file" name="file" value="'.urlencode($original_file).'" />
      <input type="hidden" id="action" name="action" value="confirm_crop" />
      <input type="hidden" id="product" name="product" value="'.$_REQUEST['id'].'" />
	  <input type="hidden" name="id" value="'.$_REQUEST['id'].'" />
      <br><input type="submit" class="button" value="'.dol_escape_htmltag($langs->trans("Recenter")).'" />
   </form>';
print '</fieldset>';

}


llxFooter('$Date: 2011/07/31 23:45:15 $ - $Revision: 1.14 $');
?>
Example #14
0
{
	print '<td nowrap="nowrap" align="right" colspan="2">';
	print $langs->trans("NotAvailableWhenAjaxDisabled");
	print "</td>";
}
else
{
	print '<td width="60" align="right">';
	$arrval=array('0'=>$langs->trans("No"),
	'1'=>$langs->trans("Yes").' ('.$langs->trans("NumberOfKeyToSearch",1).')',
    '2'=>$langs->trans("Yes").' ('.$langs->trans("NumberOfKeyToSearch",2).')',
    '3'=>$langs->trans("Yes").' ('.$langs->trans("NumberOfKeyToSearch",3).')',
	);
	print $html->selectarray("activate_COMPANY_USE_SEARCH_TO_SELECT",$arrval,$conf->global->COMPANY_USE_SEARCH_TO_SELECT);
	print '</td><td align="right">';
	print '<input type="submit" class="button" value="'.$langs->trans("Modify").'">';
	print "</td>";
}
print '</tr>';
print '</form>';

print '</table>';


dol_fiche_end();

$db->close();

llxFooter('$Date: 2011/07/31 22:23:23 $ - $Revision: 1.61 $');
?>
Example #15
0
				if ($project->statut >= 0 && $userAccess) print '</a>';
				print '</td>';

				// Icon update et delete
				print '<td align="center" nowrap>';
				if ($user->rights->projet->creer && $userAccess)
				{
					print '&nbsp;';
					print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$project->id.'&amp;action=deleteline&amp;lineid='.$tab[$i]['rowid'].'">';
					print img_delete();
					print '</a>';
				}
				print '</td>';

				print "</tr>\n";

				$i ++;
			}
		}
		print "</table>";
	}
	else
	{
		print "ErrorRecordNotFound";
	}
}

$db->close();

llxFooter('$Date: 2011/07/31 23:23:39 $');
?>
Example #16
0
			$d = dol_print_date($db->jdate($objp->dp),"%d");
			print $d."\n";
			print " <a href=\"propal.php?year=$y&month=$m\">";
			print $mt."</a>\n";
			print " <a href=\"propal.php?year=$y\">";
			print $y."</a></td>\n";

			// Prix
			print "<td align=\"right\">".price($objp->total_ht)."</td>\n";
			print "<td align=\"right\">".$propalstatic->LibStatut($objp->fk_statut,5)."</td>\n";
			print "<td>&nbsp;</td>";
			print "</tr>\n";

			$i++;
		}

		print "</table>";
		$db->free($result);
	}
	else
	{
		dol_print_error($db);
	}
}
$db->close();


llxFooter('$Date: 2011/08/03 00:46:24 $ - $Revision: 1.194 $');

?>
Example #17
0
				print '<td align="left"><a href="fiche.php?socid='.$obj->rowid.'">'.img_object($langs->trans("ShowCompany"),"company").' '.dol_trunc($obj->nom,44).'</a></td>'."\n";
				print '<td align="right">';
				print dol_print_date($db->jdate($obj->dp),'day').'</td>'."\n";
				print '<td align="right">'.price($obj->total_ttc).'</td>';
				print '<td align="center" width="14">'.$propalstatic->LibStatut($obj->fk_statut,3).'</td>'."\n";
				print '</tr>'."\n";
				$i++;
				$total += $obj->total_ttc;
			}
			if ($total>0) {
				print '<tr class="liste_total"><td colspan="3">'.$langs->trans("Total")."</td><td align=\"right\">".price($total)."</td><td>&nbsp;</td></tr>";
			}
			print "</table><br>";
		}
	}
	else
	{
		dol_print_error($db);
	}
}


print '</td></tr>';
print '</table>';

$db->close();


llxFooter('$Date: 2011/08/08 14:25:44 $ - $Revision: 1.173 $');
?>
Example #18
0
    print '<tr class="liste_titre">';
    print '<td>Nom</td>';
    print '<td>adresse</td>';
    print '<td>appartement</td>';
    print '<td>loyer total</td>';
    print '<td>encours loyer</td>';
    print '<td>&nbsp;</td>';
    print "</tr>\n";
    $var = True;
    while ($i < min($num_lignes, $limit)) {
        $objp = $db->fetch_object($result);
        $var = !$var;
        print "<tr {$bc[$var]}>";
        print '<td>' . stripslashes(nl2br($objp->nom)) . '</td>';
        print '<td>' . stripslashes(nl2br($objp->adresse)) . '</td>';
        print '<td>' . stripslashes(nl2br($objp->local)) . '</td>';
        print '<td>' . stripslashes(nl2br($objp->total)) . '</td>';
        print '<td>' . stripslashes(nl2br($objp->encours)) . '</td>';
        print '<td align="right"><a href="contrat/fiche_contrat.php?id=' . $objp->reference . '">';
        print img_edit();
        print '</a></td>';
        print "</tr>";
        $i++;
    }
    print "</table>";
} else {
    print $db->error();
}
$db->close();
llxFooter("<em>Derni&egrave;re modification {$Date}: 2009/02/20 22:54:07 \$ r&eacute;vision {$Revision}: 1.15 \$</em>");
Example #19
0
            print '<td class="nobordernopadding">';
            print $obj->societe;
            print ($obj->societe && $obj->nom?' / ':'');
            print $obj->nom;
            print '</td>';

            print '<td width="16" align="right" class="nobordernopadding">';
            print price($obj->amount);
            print '</td>';

            // Date
            print '<td align="center">'.dol_print_date($db->jdate($obj->datem),'day').'</td>';

            print '<td align="right">'.$donation_static->LibStatut($obj->fk_statut,5).'</td>';

            print '</tr>';
            $i++;
        }
    }
    print "</table><br>";
}
else dol_print_error($db);


print '</td></tr></table>';

$db->close();

llxFooter('$Date: 2011/08/03 00:46:37 $ - $Revision: 1.29 $');
?>
Example #20
0
$resql = 0;
if ($resql)
{
	print '<table class="noborder" width="100%">';
	print '<tr class="liste_titre"><td colspan="2">'.$langs->trans("TasksToDo").'</td>';
	print "</tr>\n";
	$var = True;
	$i = 0;
	while ($i < $db->num_rows($resql))
	{
		$obj = $db->fetch_object($resql);
		$var=!$var;

		print "<tr $bc[$var]><td>".dol_print_date($obj->da,"day")."</td>";
		print "<td><a href=\"action/fiche.php\">$obj->libelle $obj->label</a></td></tr>";
		$i++;
	}
	$db->free($resql);
	print "</table><br>";
}

print '</td></tr>';

print '</table>';

$db->close();


llxFooter('$Date: 2011/08/08 14:25:45 $ - $Revision: 1.185 $');
?>
Example #21
0
    print '<tr '.$bc[$var].'><td>'.$langs->trans("ShowProfIdInAddress").' - '.$langs->transcountry("ProfId2",$mysoc->pays_code).'</td><td>';
    print yn($conf->global->MAIN_PROFID2_IN_ADDRESS,1);
    print '</td></tr>';

    // Show prof id 3 in address into pdf
    $var=!$var;
    print '<tr '.$bc[$var].'><td>'.$langs->trans("ShowProfIdInAddress").' - '.$langs->transcountry("ProfId3",$mysoc->pays_code).'</td><td>';
    print yn($conf->global->MAIN_PROFID3_IN_ADDRESS,1);
    print '</td></tr>';

    // Show prof id 4 in address into pdf
    $var=!$var;
    print '<tr '.$bc[$var].'><td>'.$langs->trans("ShowProfIdInAddress").' - '.$langs->transcountry("ProfId4",$mysoc->pays_code).'</td><td>';
    print yn($conf->global->MAIN_PROFID4_IN_ADDRESS,1);
    print '</td></tr>';

    print '</table>'."\n";


    print '<div class="tabsAction">';
    print '<a class="butAction" href="'.$_SERVER["PHP_SELF"].'?action=edit">'.$langs->trans("Modify").'</a>';
    print '</div>';
	print '<br>';
}


$db->close();

llxFooter('$Date: 2011/07/31 22:23:24 $ - $Revision: 1.130 $');
?>
Example #22
0
$sql .= ")";
$sql .= "ORDER BY date";
$result = $db->query($sql);
if ($result) {
    $num_lignes = $db->num_rows($result);
    $i = 0;
    print '<table class="border" width="100%">';
    print '<tr class="liste_titre">';
    print '<td>' . $langs->trans("date") . '</td>';
    print '<td>' . $langs->trans("debit") . '</td>';
    print '<td>' . $langs->trans("credit") . '</td>';
    print '<td>' . $langs->trans("description") . '</td>';
    print "</tr>\n";
    $var = True;
    while ($i < min($num_lignes, $limit)) {
        $objp = $db->fetch_object($result);
        $var = !$var;
        print "<tr {$bc[$var]}>";
        print '<td>' . dol_print_date($db->jdate($objp->date), 'day') . '</td>';
        print '<td>' . $objp->debit . '</td>';
        print '<td>' . $objp->credit . '</td>';
        print '<td>' . $objp->des . '</td>';
        print "</tr>";
        $i++;
    }
    print '</table>';
} else {
    print $db->error();
}
llxFooter('');
$db->close();
Example #23
0
    print '<td align="right">' . $langs->trans("NbOfCheques") . '</td>';
    print '<td align="right">' . $langs->trans("Amount") . '</td>';
    print '<td align="right">' . $langs->trans("Status") . '</td>';
    print "</tr>\n";
    $var = true;
    while ($objp = $db->fetch_object($resql)) {
        $checkdepositstatic->id = $objp->rowid;
        $checkdepositstatic->ref = $objp->ref ? $objp->ref : $objp->rowid;
        $checkdepositstatic->statut = $objp->statut;
        $accountstatic->id = $objp->bid;
        $accountstatic->label = $objp->label;
        $var = !$var;
        print "<tr {$bc[$var]}>\n";
        print '<td>' . $checkdepositstatic->getNomUrl(1) . '</td>';
        print '<td>' . dol_print_date($db->jdate($objp->db), 'day') . '</td>';
        print '<td>' . $accountstatic->getNomUrl(1) . '</td>';
        print '<td align="right">' . $objp->nbcheque . '</td>';
        print '<td align="right">' . price($objp->amount) . '</td>';
        print '<td align="right">' . $checkdepositstatic->LibStatut($objp->statut, 3) . '</td>';
        print '</tr>';
    }
    print "</table>";
    $db->free($resql);
} else {
    dol_print_error($db);
}
print "</td></tr>\n";
print "</table>\n";
$db->close();
llxFooter('$Date: 2011/08/03 00:46:28 $ - $Revision: 1.21 $');
Example #24
0
    $i = 0;
    $num = $db->num_rows($resql);
    while ($i < $num) {
        $row = $db->fetch_row($resql);
        print '<tr><td>' . $row[0] . '</td>';
        print '<td align="right">' . $row[1] . '</td>';
        print '<td align="right">' . $row[2] . '</td>';
        print '<td align="right">' . $row[3] . '</td>';
        print '<td align="right">' . $row[4] . '</td>';
        print '<td align="right">' . $row[5] . '</td>';
        print '<td align="right">' . $row[6] . '</td>';
        print '<td align="right">' . $row[7] . '</td>';
        print '<td align="right">' . $row[8] . '</td>';
        print '<td align="right">' . $row[9] . '</td>';
        print '<td align="right">' . $row[10] . '</td>';
        print '<td align="right">' . $row[11] . '</td>';
        print '<td align="right">' . $row[12] . '</td>';
        print '<td align="right"><b>' . $row[13] . '</b></td>';
        print '</tr>';
        $i++;
    }
    $db->free($resql);
} else {
    print $db->lasterror();
    // affiche la derniere erreur sql
}
print "</table>\n";
print '</td></tr></table>';
$db->close();
llxFooter('$Date: 2006/12/23 15:24:24 $ - $Revision: 1.11 $');
Example #25
0
		print '<input type="submit" class="button" name="update" value="'.$langs->trans("Save").'">';
		print '&nbsp; &nbsp;';
		print '<input type="submit" class="button" name="cancel" value="'.$langs->trans("Cancel").'">';
		print '</td></tr>';
	}

    print "</table>";
	print "</form>\n";


    /*
    * Actions
    */
    print '</div>';
    print '<div class="tabsAction">';

    if ($user->rights->user->user->creer && $action != 'edit')
    {
        print "<a class=\"butAction\" href=\"note.php?id=".$fuser->id."&amp;action=edit\">".$langs->trans('Modify')."</a>";
    }

    print "</div>";


}

$db->close();

llxFooter('$Date: 2011/07/31 23:19:42 $ - $Revision: 1.24 $');
?>
Example #26
0
			print "</tr>";

			print "<tr>";
			print "<td colspan=\"2\" align=\"center\">";
			print "<input type=\"submit\" class=\"button\" name=\"modify\" value=\"".$langs->trans("Modify")."\">";
			print " &nbsp; ";
			print "<input type=\"submit\" class=\"button\" name=\"delete\" value=\"".$langs->trans("Delete")."\">";
			print "<input type=\"hidden\" name=\"numero_entry\"  value=\"".$idrss."\">";
			print "</td>";
			print "</tr>";

			print "</form>";

			$i++;
		}
	}
	else
	{
		dol_print_error($db);
	}

	print '</table>';

}


$db->close();

llxFooter('$Date: 2011/08/01 00:01:01 $ - $Revision: 1.5 $');
?>
Example #27
0
  accessforbidden();



/*
 * View
 */

llxHeader();

$form = new Form($db);


print_fiche_titre($langs->trans("SystemToolsArea"),'','setup');

print $langs->trans("SystemToolsAreaDesc").'<br>';
print "<br>";


if ($message) print $message.'<br>';


print info_admin($langs->trans("SystemAreaForAdminOnly")).'<br>';



$db->close();

llxFooter('$Date: 2011/08/03 00:45:43 $ - $Revision: 1.7 $');
?>
Example #28
0
    {
        $objp = $db->fetch_object($resql);
        $var=!$var;
        print "<tr $bc[$var]>";
        print '<td>'.'<a href="'.DOL_URL_ROOT.'/compta/paiement/fiche.php?id='.$objp->rowid.'">'.img_object($langs->trans("ShowPayment"),"payment").' '.$objp->rowid.'</a></td>';
        print '<td width="80" align="center">'.dol_print_date($db->jdate($objp->dp),'day')."</td>\n";
        print "<td>$objp->paiement_type $objp->num_paiement</td>\n";
        print '<td align="right">'.price($objp->amount).'</td>';
        print '<td align="center">';

        if ($objp->statut == 0)
        {
            print '<a href="fiche.php?id='.$objp->rowid.'&amp;action=valide">'.$langs->trans("PaymentStatusToValidShort").'</a>';
        }
        else
        {
            print "-";
        }

        print '</td>';
        print "</tr>";
        $i++;
    }
    print "</table>";
}

$db->close();

llxFooter('$Date: 2011/08/03 00:46:34 $ - $Revision: 1.13 $');
?>
Example #29
0
        // Status
        print '<tr><td valign="top">' . $langs->trans("Status") . '</td>';
        print '<td colspan="3">' . $object->getLibStatut(4) . '</td></tr>';
        print '<tr><td>' . $langs->trans("NbOfAttachedFiles") . '</td><td colspan="3">' . count($filearray) . '</td></tr>';
        print '<tr><td>' . $langs->trans("TotalSizeOfAttachedFiles") . '</td><td colspan="3">' . $totalsize . ' ' . $langs->trans("bytes") . '</td></tr>';
        print "</table>\n";
        print "</div>\n";
        dol_htmloutput_mesg($mesg, $mesgs);
        /*
         * Confirmation suppression fichier
         */
        if ($action == 'delete') {
            $ret = $form->form_confirm($_SERVER["PHP_SELF"] . '?id=' . $object->id . '&urlfile=' . urlencode($_GET["urlfile"]), $langs->trans('DeleteFile'), $langs->trans('ConfirmDeleteFile'), 'confirm_deletefile', '', 0, 1);
            if ($ret == 'html') {
                print '<br>';
            }
        }
        // Affiche formulaire upload
        $formfile = new FormFile($db);
        $formfile->form_attach_new_file(DOL_URL_ROOT . '/compta/bank/document.php?id=' . $object->id, '', 0, 0, $user->rights->banque, 50, $object);
        // List of document
        $param = '&id=' . $object->id;
        $formfile->list_of_documents($filearray, $object, 'bank', $param);
    } else {
        dol_print_error($db);
    }
} else {
    Header('Location: index.php');
}
llxFooter();
$db->close();
Example #30
0
        print img_object($langs->trans("ShowBill"),"bill");
          print '&nbsp;<a href="'.DOL_URL_ROOT.'/compta/facture.php?facid='.$obj->facid.'">'.$obj->facnumber."</a></td>\n";
        print '</a></td>';

        print '<td><a href="fiche.php?id='.$obj->rowid.'">'.$obj->nom."</a></td>\n";

        print '<td align="center"><a href="fiche.php?id='.$obj->rowid.'">'.$obj->code_client."</a></td>\n";

        print '<td align="center">'.dol_print_date($db->jdate($obj->datec),'day')."</td>\n";

        print '<td align="right">'.price($obj->amount)."</td>\n";

        print '<td>&nbsp;</td>';

        print "</tr>\n";
        $i++;
    }
    print "</table>";
    $db->free($result);
}
else
{
    dol_print_error($db);
}

$db->close();


llxFooter('$Date: 2011/07/31 22:23:29 $ - $Revision: 1.35 $');
?>