function _comments($id, $ref, $element)
{
$element_tag = TTwiiit::getTag($element, $ref);
$PDOdb = new TPDOdb();
$r = '';
$Tab = $PDOdb->ExecuteAsArray("SELECT DISTINCT t.rowid\n\tFROM " . MAIN_DB_PREFIX . "twiiit t \n\t WHERE (t.fk_object=" . (int) $id . " AND t.type_object='" . $element . "') OR (t.comment LIKE '%" . $element_tag . "%')\n\t ORDER BY t.date_cre DESC");
foreach ($Tab as &$row) {
$twiiit = new TTwiiit();
$twiiit->load($PDOdb, $row->rowid);
$r .= '<div class="comm">';
if ($id != $twiiit->fk_object || $element != $twiiit->type_object) {
$origin_element = $twiiit->getNomUrl();
if (!empty($origin_element)) {
$r .= '<div class="object">' . $origin_element . '</div> ';
}
}
$r .= $twiiit->getComment();
$r .= '<div class="date">' . dol_print_date($twiiit->date_cre, 'dayhourtextshort') . '</div>';
$r .= '</div>';
}
return $r;
}
/** Overloading the doActions function : replacing the parent's function with the one below
* @param parameters meta datas of the hook (context, etc...)
* @param object the object you want to process (an invoice if you are in invoice module, a propale in propale's module, etc...)
* @param action current action (if set). Generally create or edit or null
* @return void
*/
function beforePDFCreation($parameters, &$object, &$action, $hookmanager)
{
// pour implementation dans Dolibarr 3.7
if (in_array('pdfgeneration', explode(':', $parameters['context']))) {
define('INC_FROM_DOLIBARR', true);
dol_include_once('/dispatch/config.php');
dol_include_once('/asset/class/asset.class.php');
dol_include_once('/dispatch/class/dispatchdetail.class.php');
global $conf;
if (isset($parameters['object']) && get_class($object) == 'Expedition') {
$PDOdb = new TPDOdb();
foreach ($object->lines as &$line) {
$sql = 'SELECT DISTINCT(lot_number),rowid FROM ' . MAIN_DB_PREFIX . 'expeditiondet_asset WHERE fk_expeditiondet = ' . $line->line_id;
$PDOdb->Execute($sql);
$TRes = $PDOdb->Get_All();
if (count($TRes) > 0) {
$line->desc .= "<br>Lot(s) expédié(s) : ";
foreach ($TRes as $res) {
$dispatchDetail = new TDispatchDetail();
$dispatchDetail->load($PDOdb, $res->rowid);
$asset = new TAsset();
$asset->load($PDOdb, $dispatchDetail->fk_asset);
$asset->load_asset_type($PDOdb);
$unite = $asset->assetType->measuring_units == 'unit' ? 'unité(s)' : measuring_units_string($dispatchDetail->weight_reel_unit, $asset->assetType->measuring_units);
$desc = "<br>- " . $res->lot_number . " x " . $dispatchDetail->weight_reel . " " . $unite;
if (empty($conf->global->DISPATCH_HIDE_DLUO_PDF)) {
$desc .= ' (DLUO : ' . $asset->get_date('dluo') . ')';
}
$line->desc .= $desc;
}
}
}
}
//pre($object,true);exit;
}
}
/**
* Overloading the doActions function : replacing the parent's function with the one below
*
* @param array() $parameters Hook metadatas (context, etc...)
* @param CommonObject &$object The object to process (an invoice if you are in invoice module, a propale in propale's module, etc...)
* @param string &$action Current action (if set). Generally create or edit or null
* @param HookManager $hookmanager Hook manager propagated to allow calling another hook
* @return int < 0 on error, 0 on success, 1 to replace standard code
*/
function blockRelated($parameters, &$object, &$action, $hookmanager, $moreStyle = '')
{
global $langs, $db, $user, $conf, $related_link_added;
$error = 0;
// Error counter
//var_dump($objet);
define('INC_FROM_DOLIBARR', true);
dol_include_once('/related/config.php');
$PDOdb = new TPDOdb();
$langs->load('related@related');
if (GETPOST('action') == 'add_related_link' && !$related_link_added) {
$type = GETPOST('type_related_object');
//var_dump($type);exit;
if ($type == 'projet') {
$type = 'project';
} else {
if ($type == 'invoice') {
$type = 'facture';
} else {
if ($type == 'company') {
$type = 'societe';
} else {
if ($type == 'facture_fournisseur') {
$type = 'invoice_supplier';
} else {
if ($type == 'commande_fournisseur') {
$type = 'order_supplier';
}
}
}
}
}
$res = $object->add_object_linked($type, GETPOST('id_related_object'));
$object->fetchObjectLinked();
if (empty($res)) {
setEventMessage($langs->trans('RelationCantBeAdded'), 'errors');
} else {
$related_link_added = true;
global $langs, $conf;
dol_include_once('/core/class/interfaces.class.php');
$interface = new Interfaces($db);
$object->id_related_object = GETPOST('id_related_object');
$object->type_related_object = $type;
$result = $interface->run_triggers('RELATED_ADD_LINK', $object, $user, $langs, $conf);
if ($result < 0) {
if (!empty($this->errors)) {
$this->errors = array_merge($this->errors, $interface->errors);
} else {
$this->errors = $interface->errors;
}
}
setEventMessage($langs->trans('RelationAdded'));
}
} elseif (GETPOST('action') == 'delete_related_link') {
$idLink = GETPOST('id_link');
if ($idLink) {
$PDOdb->Execute("DELETE FROM " . MAIN_DB_PREFIX . "element_element WHERE rowid = " . $idLink);
$object->fetchObjectLinked();
}
} else {
//var_dump($object);
if (empty($object->linkedObjects)) {
$object->fetchObjectLinked();
}
}
//var_dump($object->linkedObjectsIds);
?>
<div class="blockrelated_content" style="<?php
echo $moreStyle;
?>
">
<form name="formLinkObj" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post">
<input type="hidden" name="action" value="add_related_link" />
<input type="hidden" name="id" value="<?php
echo GETPOST('id');
?>
" />
<input type="hidden" name="facid" value="<?php
echo GETPOST('facid');
?>
" />
<br>
<div class="titre"><?php
echo $langs->trans('ElementToLink');
?>
</div>
<input type="hidden" id="id_related_object" name="id_related_object" value="" />
<input type="hidden" id="type_related_object" name="type_related_object" value="" />
<table class="noborder allwidth">
<tr class="liste_titre">
<td><?php
echo $langs->trans("Ref");
?>
<input type="text" id="add_related_object" name="add_related_object" value="" class="flat" /> <input type="submit" id="bt_add_related_object" name="bt_add_related_object" class="button" value="<?php
echo $langs->trans('AddRelated');
?>
" style="display:none" /></td>
<td align="center"><?php
echo $langs->trans("Date");
?>
</td>
<td align="center"><?php
echo $langs->trans("Status");
?>
</td>
<td align="center"><?php
echo $langs->trans("Action");
?>
</td>
</tr>
<?php
$class = 'pair';
foreach ($object->linkedObjectsIds as $objecttype => &$TSubIdObject) {
//var_dump($objecttype);
if (isset($object->linkedObjects[$objecttype]) && $objecttype != 'societe' && $objecttype != 'product' && $object->element != 'project') {
continue;
}
// on affiche ici que les objects non géré en natif
foreach ($TSubIdObject as $id_object) {
$date_create = 0;
$classname = ucfirst($objecttype);
$statut = 'N/A';
if ($objecttype == 'task') {
dol_include_once('/projet/class/task.class.php');
} else {
if ($objecttype == 'event' || $objecttype == 'action') {
dol_include_once('/comm/action/class/actioncomm.class.php');
$classname = 'ActionComm';
} else {
if ($objecttype == 'project') {
dol_include_once('/projet/class/project.class.php');
} else {
if ($objecttype == 'ordre_fabrication') {
dol_include_once('/of/class/ordre_fabrication_asset.class.php');
$classname = 'TAssetOf';
$abricot = true;
}
}
}
}
if (!class_exists($classname)) {
$link = 'CantInstanciateClass ' . $classname;
} else {
if (!empty($abricot)) {
if (empty($PDOdb)) {
$PDOdb = new TPDOdb();
}
$subobject = new $classname();
$subobject->load($PDOdb, $id_object);
if (method_exists($subobject, 'getNomUrl')) {
$link = $subobject->getNomUrl(1);
} else {
$link = $id_object . '/' . $classname;
}
$class = $class == 'impair' ? 'pair' : 'impair';
$date_create = $subobject->date_cre;
if (method_exists($subobject, 'getLibStatut')) {
$statut = $subobject->getLibStatut(3);
}
} else {
$subobject = new $classname($db);
$subobject->fetch($id_object);
if (method_exists($subobject, 'getNomUrl')) {
$link = $subobject->getNomUrl(1);
} else {
$link = $id_object . '/' . $classname;
}
$class = $class == 'impair' ? 'pair' : 'impair';
if (!empty($subobject->date_creation)) {
$date_create = $subobject->date_creation;
}
if (empty($date_create) && !empty($subobject->date_create)) {
$date_create = $subobject->date_create;
}
if (empty($date_create) && !empty($subobject->date_c)) {
$date_create = $subobject->date_c;
}
if (method_exists($subobject, 'getLibStatut')) {
$statut = $subobject->getLibStatut(3);
}
}
}
$Tids = TRequeteCore::get_id_from_what_you_want($PDOdb, MAIN_DB_PREFIX . "element_element", array('fk_source' => $id_object, 'fk_target' => $object->id, 'sourcetype' => $objecttype, 'targettype' => $object->element));
?>
<tr class="<?php
echo $class;
?>
">
<td><?php
echo $link;
?>
</td>
<td align="center"><?php
echo !empty($date_create) ? dol_print_date($date_create, 'day') : '';
?>
</td>
<td align="center"><?php
echo $statut;
?>
</td>
<td align="center"><a href="?id=<?php
echo $object->id;
?>
&action=delete_related_link&id_link=<?php
echo $Tids[0];
?>
"><?php
print img_picto($langs->trans("Delete"), 'delete.png');
?>
</a></td>
</tr>
<?php
}
}
?>
</table>
</form>
</div>
<script type="text/javascript">
$(document).ready(function() {
$('#add_related_object').autocomplete({
source: function( request, response ) {
$.ajax({
url: "<?php
echo dol_buildpath('/related/script/interface.php', 1);
?>
",
dataType: "json",
data: {
key: request.term
,get:'search'
}
,success: function( data ) {
var c = [];
$.each(data, function (i, cat) {
var first = true;
$.each(cat, function(j, label) {
if(first) {
c.push({value:i, label:i, object:'title'});
first = false;
}
c.push({ value: j, label:' '+label, object:i});
});
});
response(c);
}
});
},
minLength: 1,
select: function( event, ui ) {
if(ui.item.object == 'title') return false;
else {
$('#id_related_object').val(ui.item.value);
$('#add_related_object').val(ui.item.label.trim());
$('#type_related_object').val(ui.item.object);
$('#bt_add_related_object').css('display','inline');
return false;
}
},
open: function( event, ui ) {
$( this ).removeClass( "ui-corner-all" ).addClass( "ui-corner-top" );
},
close: function() {
$( this ).removeClass( "ui-corner-top" ).addClass( "ui-corner-all" );
}
});
$( "#add_related_object" ).autocomplete( "instance" )._renderItem = function( ul, item ) {
$li = $( "<li />" )
.attr( "data-value", item.value )
.append( item.label )
.appendTo( ul );
if(item.object=="title") $li.css("font-weight","bold");
return $li;
};
var blockrelated = $('div.tabsAction .blockrelated_content');
if (blockrelated.length == 1)
{
if ($('.blockrelated_content').length > 1)
{
blockrelated.remove();
}
else
{
$('div.tabsAction').after(blockrelated.clone());
blockrelated.remove();
}
}
});
</script>
<?php
if (!$error) {
return 0;
// or return 1 to replace standard code
} else {
$this->errors[] = 'Cant link related';
return -1;
}
}
static function route($action, &$object)
{
$PDOdb = new TPDOdb();
$sql = "SELECT rowid\n FROM " . MAIN_DB_PREFIX . "routing\n WHERE trigger_code='" . $action . "'";
$Tab = $PDOdb->ExecuteAsArray($sql);
foreach ($Tab as $row) {
$route = new TRouting();
$route->load($PDOdb, $row->rowid);
$route->routeLines($object);
}
// mvt inverse pour annulation
$sql = "SELECT rowid\n FROM " . MAIN_DB_PREFIX . "routing\n WHERE trigger_code_reverse='" . $action . "'";
$Tab = $PDOdb->ExecuteAsArray($sql);
foreach ($Tab as $row) {
$route = new TRouting();
$route->load($PDOdb, $row->rowid);
$route->routeLines($object, -1);
}
}
<?php
define('INC_FROM_DOLIBAR', true);
require_once '../config.php';
dol_include_once('/ideabox/lib/ideabox.lib.php');
$langs->load('ideabox@ideabox');
$PDOdb = new TPDOdb();
$sql = 'SELECT DISTINCT(ib.rowid), ib.label, ib.fk_usergroup
FROM ((' . MAIN_DB_PREFIX . 'usergroup ub RIGHT JOIN ' . MAIN_DB_PREFIX . 'ideabox ib on ib.fk_usergroup = ub.rowid)
INNER JOIN ' . MAIN_DB_PREFIX . 'usergroup_user ubu on ub.rowid = ubu.fk_usergroup)
WHERE ubu.fk_user = '******'
UNION
SELECT ib.rowid, ib.label, ib.fk_usergroup
FROM ' . MAIN_DB_PREFIX . 'ideabox ib
WHERE fk_usergroup = -1';
$PDOdb->Execute($sql);
?>
$('document').ready(function(){
function openIdeaboxWidget(){
$ideabox = $('<div id="ideabox_widget"><div class="titre center">Ajouter une idée dans une boîte</div>Boîte : <select id="ideabox_widget_select"></select><br /></div>');
$ideabox.append('Titre : <br /><input id="ideabox_widget_label" type="text" id="ideabox_widget_label" placeholder="Titre de l\'idée" /><br />');
$ideabox.append('Description : <br /><textarea id="ideabox_widget_description" cols="10" rows="2" type="text" placeholder="Description de l\'idée" /><br />');
$ideabox.append('<div class="center" style="margin-top:5px;"><a id="ideabox_widget_valid" class="button" style="cursor:pointer;">Ajouter</a> '
+ '<a id="ideabox_widget_cancel" class="button" style="cursor:pointer;">Annuler</a></div>');
$('body').append($ideabox);
}
}
if (isset($_REQUEST['modele'])) {
//Récupération des parametres transmis
$nbVides = !empty($_REQUEST['startpos']) ? $_REQUEST['startpos'] - 1 : 0;
$nbCopies = !empty($_REQUEST['copie']) ? $_REQUEST['copie'] : 1;
$modele = $_REQUEST['modele'];
$expedition = new Expedition($db);
$expedition->fetch($_REQUEST['expedition']);
$expedition->fetch_lines();
$TetiquettesVides = array();
$Tetiquettes = array();
//création des div vides
for ($i = 0; $i < $nbVides; $i++) {
$TetiquettesVides[$i] = array($i);
}
$TPDOdb = new TPDOdb();
//création des div pleines
foreach ($expedition->lines as $ligne) {
$TPDOdb->Execute("SELECT rowid FROM " . MAIN_DB_PREFIX . "expeditiondet_asset WHERE fk_expeditiondet = " . $ligne->rowid);
$TidExepeditiondetAsset = array();
while ($TPDOdb->Get_line()) {
$TidExepeditiondetAsset[] = $TPDOdb->Get_field('rowid');
}
foreach ($TidExepeditiondetAsset as $idExpeditiondetAsset) {
$sql = "SELECT p.ref, p.label as nom, p.note as descritpion, eda.tare as tare, a.serial_number as code, a.lot_number as lot, eda.weight_reel as poids, eda.weight_reel_unit as poids_unit, eda.tare_unit as tare_unit\n\t\t\t\t\tFROM " . MAIN_DB_PREFIX . "expeditiondet_asset as eda\n\t\t\t\t\t\tLEFT JOIN " . MAIN_DB_PREFIX . "asset as a ON (a.rowid = eda.fk_asset)\n\t\t\t\t\t\tLEFT JOIN " . MAIN_DB_PREFIX . "product as p ON (p.rowid = a.fk_product)\n\t\t\t\t\tWHERE eda.rowid = " . $idExpeditiondetAsset;
$TPDOdb->Execute($sql);
$TPDOdb->Get_line();
$tare_unit = _unit($TPDOdb->Get_field('tare_unit'));
$poids_unit = _unit($TPDOdb->Get_field('poids_unit'));
//On duplique l'étiquette autant de fois que demandé en paramètre
for ($i = 0; $i < $nbCopies; $i++) {
<?php
require 'config.php';
if (!$user->rights->mandarin->graph->ca_client_month) {
accessforbidden();
}
llxHeader('', $langs->trans('CAClientMonth'), '');
dol_fiche_head();
$PDOdb = new TPDOdb();
//$PDOdb->debug=true;
$year = (int) GETPOST('year');
if (empty($year)) {
$year = (int) date('Y');
}
$TYear = $TMonth = $ColFormat = $ColTotal = array();
$y = (int) date('Y');
for ($i = $y - 10; $i < $y + 3; $i++) {
$TYear[$i] = $i;
}
for ($i = 1; $i <= 12; $i++) {
$TMonth[$i] = $langs->trans('month' . date('M', strtotime(date('Y-' . $i . '-01')))) . '-' . $year;
$ColFormat[$TMonth[$i]] = 'number';
$ColTotal[$TMonth[$i]] = 'sum';
}
$ColFormat['total'] = 'number';
$ColTotal['total'] = 'sum';
$mode = GETPOST('mode');
$TData = array();
if ($mode == 'order') {
//commande non brouillon par date de livraison
$sql = "SELECT commande.fk_soc, SUM(commande.total_ht) as total, MONTH(commande.date_livraison) as 'month' FROM " . MAIN_DB_PREFIX . "commande as commande\n\t\t\t\tINNER JOIN " . MAIN_DB_PREFIX . "societe as soc ON soc.rowid=commande.fk_soc WHERE commande.fk_statut>0 AND YEAR(commande.date_livraison)=" . $year . "\n\t\t\t\tGROUP BY commande.fk_soc,soc.nom, MONTH(commande.date_livraison)\n ORDER BY soc.nom,MONTH(commande.date_livraison)";
#!/usr/bin/php
<?php
chdir(__DIR__);
//echo __DIR__."\n";
define('INC_FROM_CRON_SCRIPT', true);
require 'config.php';
dol_include_once('/user/class/usergroup.class.php');
dol_include_once('/core/class/CMailFile.class.php');
//dol_include_once('/query/lib/Wkhtmltopdf.php');
$PDOdb = new TPDOdb();
if (!is_dir('files')) {
mkdir('files', 0777);
}
//var_dump($argv);
$frequence = $argv[1];
if (empty($frequence)) {
$frequence = 'DAY';
}
$step = (int) $argv[2];
if (empty($step)) {
$step = 1;
}
$sql = "SELECT uid,rowid, title, fk_usergroup,fk_user_author FROM " . MAIN_DB_PREFIX . "qdashboard WHERE send_by_mail = '" . $frequence . "' AND fk_usergroup>0";
$Tab = $PDOdb->ExecuteAsArray($sql);
$f1 = fopen('files/convert.sh', 'w');
fputs($f1, "cd " . __DIR__ . "/files \n");
// var_dump($sql,$Tab);
foreach ($Tab as $row) {
$author = new User($db);
$author->fetch($row->fk_user_author);
//var_dump( is_file( 'files/'.$row->uid.'.pdf'), dol_buildpath('/query/files/'.$row->uid.'.pdf') );
<?php
require "../config.php";
require DOL_DOCUMENT_ROOT . "/custom/asset/class/asset.class.php";
if (isset($_POST['id_detail'])) {
$id_detail = $_POST['id_detail'];
} else {
return 0;
}
$ATMdb = new TPDOdb();
$sql = "DELETE FROM " . MAIN_DB_PREFIX . "expeditiondet_asset WHERE rowid = " . $id_detail;
$ATMdb->Execute($sql);
return 1;
<?php
require '../config.php';
$PDOdb = new TPDOdb();
$QB = new TQueryBuilder();
$sql = $QB->select('user', array('login', 'pass'))->where("datelastlogin>'2010-01-01'")->build();
echo $sql;
var_dump($PDOdb->ExecuteAsArray($sql));
/**
* Function called when a Dolibarrr business event is done.
* All functions "run_trigger" are triggered if file
* is inside directory core/triggers
*
* @param string $action Event action code
* @param Object $object Object
* @param User $user Object user
* @param Translate $langs Object langs
* @param conf $conf Object conf
* @return int <0 if KO, 0 if no triggered ran, >0 if OK
*/
public function run_trigger($action, $object, $user, $langs, $conf)
{
if ($action === 'ORDER_VALIDATE') {
global $conf, $db;
if ($conf->global->CREATE_OF_ON_ORDER_VALIDATE) {
define('INC_FROM_DOLIBARR', true);
dol_include_once('/product/class/product.class.php');
dol_include_once('/of/config.php');
dol_include_once('/of/class/ordre_fabrication_asset.class.php');
$PDOdb = new TPDOdb();
foreach ($object->lines as $line) {
// Uniquement si c'est un produit
if (!empty($line->fk_product) && $line->fk_product_type == 0) {
// On charge le produit pour vérifier son stock
$prod = new Product($db);
$prod->fetch($line->fk_product);
$prod->load_stock();
if ($prod->stock_reel < $line->qty) {
$assetOF = new TAssetOF();
$assetOF->fk_commande = $_REQUEST['id'];
$assetOF->fk_soc = $object->socid;
$assetOF->addLine($PDOdb, $line->fk_product, 'TO_MAKE', $line->qty);
$assetOF->save($PDOdb);
}
}
}
}
} elseif ($action === 'ORDER_CANCEL') {
if ($conf->global->DELETE_OF_ON_ORDER_CANCEL) {
define('INC_FROM_DOLIBARR', true);
dol_include_once('/of/config.php');
dol_include_once('/of/class/ordre_fabrication_asset.class.php');
$PDOdb = new TPDOdb();
// On récupère les identifiants des of créés à partir de cette commande
$TID_OF_command = TAssetOF::getTID_OF_command($_REQUEST['id']);
foreach ($TID_OF_command as $id_of) {
$asset = new TAssetOF();
$asset->load($PDOdb, $id_of);
if ($asset->status == "DRAFT" || $asset->status == "VALID") {
$asset->delete($PDOdb);
}
}
}
} elseif ($action === 'TASK_TIMESPENT_CREATE') {
if ($conf->workstation->enabled) {
define('INC_FROM_DOLIBARR', true);
dol_include_once('/of/config.php');
dol_include_once('/of/class/ordre_fabrication_asset.class.php');
$PDOdb = new TPDOdb();
$PDOdb->Execute("SELECT rowid \n\t\t\t\t\t\tFROM " . MAIN_DB_PREFIX . "asset_workstation_of \n\t\t\t\t\t\tWHERE fk_project_task=" . $object->id);
if ($obj = $PDOdb->Get_line()) {
$wsof = new TAssetWorkstationOF();
$wsof->load($PDOdb, $obj->rowid);
$wsof->nb_hour_real = ($object->duration_effective + $object->timespent_duration) / 3600;
// Parce que Dolibarr mets le THM à jour après la création de la tâche :/
$sql = "UPDATE " . MAIN_DB_PREFIX . "projet_task_time";
$sql .= " SET thm = (SELECT thm FROM " . MAIN_DB_PREFIX . "user WHERE rowid = " . $object->timespent_fk_user . ")";
// set average hour rate of user
$sql .= " WHERE rowid = " . $object->timespent_id;
$object->db->query($sql);
$wsof->db =& $object->db;
$wsof->save($PDOdb);
}
}
} elseif ($action === 'ORDERSUPPLIER_ADD_LIVRAISON') {
global $db;
if ($conf->of->enabled) {
define('INC_FROM_DOLIBARR', true);
dol_include_once('/of/config.php');
dol_include_once('/of/class/ordre_fabrication_asset.class.php');
$resql = $db->query('SELECT fk_statut FROM llx_commande_fournisseur WHERE rowid = ' . $_REQUEST['id']);
$res = $db->fetch_object($resql);
if ($res->fk_statut == 5) {
// La livraison est totale
//On cherche l'OF lié
$resql = $db->query("SELECT fk_source \n\t\t\t\t\t\t\t\t\t\t\tFROM " . MAIN_DB_PREFIX . "element_element \n\t\t\t\t\t\t\t\t\t\t\tWHERE fk_target = " . $_REQUEST['id'] . " \n\t\t\t\t\t\t\t\t\t\t\t\tAND sourcetype = 'ordre_fabrication' \n\t\t\t\t\t\t\t\t\t\t\t\tAND targettype = 'order_supplier'");
$res = $db->fetch_object($resql);
$id_of = $res->fk_source;
if ($id_of > 0) {
$of = new TAssetOF();
$of->load($PDOdb, $id_of);
if ($of->status != 'CLOSE') {
$of->closeOF($PDOdb);
setEventMessage($langs->trans('OFAttachedClosedAutomatically', '<a href="' . dol_buildpath('/of/fiche_of.php?id=' . $id_of, 2) . '">' . $of->numero . '</a>'));
}
}
}
}
}
return 0;
}
