mogy74
Member
Hi to all
I need to run a scheduled task for update many row about a date controll
(i need to check if a subcrition is valid or not)
I try to do it with php plug in but after run update record are 0
i write log but report just error 4
i think proplem is in the update query but i realy can't understand where...
this is the code
$adesso = date('Y-m-d' , strtotime("now"));
$non = 'Contratto Scaduto';
$si = 'Contratto Valido';
$mai = 'Contratto Non Presente';
$db = JFactory::getDBO();
$ids = JRequest::getVar( 'ids', array(), 'method', 'array' );
foreach ($ids AS $id) {
$row = $model->getRow($id);
$scadenza = $row->anagrafica_collaboratori___data_fine_contratto;
$scadenza = $scadenza->format('Y-m-d');
$non = 'Contratto Scaduto';
$si = 'Contratto Valido';
$mai = 'Contratto Non Presente';
//var_dump($controllo);
if ($scadenza == 0){
$query="UPDATE anagrafica_collaboratori SET stato_contratto = '$mai'";
$db->setQuery($query);
$db->query();
}else{
if ($adesso > $scadenza){
$query="UPDATE anagrafica_collaboratori SET stato_contratto = '$non'";
$db->setQuery($query);
$db->query();
}else{
$query="UPDATE anagrafica_collaboratori SET stato_contratto = '$si'";
$db->setQuery($query);
$db->query();
}
}
}
I try to update 'stato_contratto' with different message stored in $non ,$si and $mai
but seems don't work
some one have did the same and know the solution?
any help are welcome
Thanks in advance
I need to run a scheduled task for update many row about a date controll
(i need to check if a subcrition is valid or not)
I try to do it with php plug in but after run update record are 0
i write log but report just error 4
i think proplem is in the update query but i realy can't understand where...
this is the code
$adesso = date('Y-m-d' , strtotime("now"));
$non = 'Contratto Scaduto';
$si = 'Contratto Valido';
$mai = 'Contratto Non Presente';
$db = JFactory::getDBO();
$ids = JRequest::getVar( 'ids', array(), 'method', 'array' );
foreach ($ids AS $id) {
$row = $model->getRow($id);
$scadenza = $row->anagrafica_collaboratori___data_fine_contratto;
$scadenza = $scadenza->format('Y-m-d');
$non = 'Contratto Scaduto';
$si = 'Contratto Valido';
$mai = 'Contratto Non Presente';
//var_dump($controllo);
if ($scadenza == 0){
$query="UPDATE anagrafica_collaboratori SET stato_contratto = '$mai'";
$db->setQuery($query);
$db->query();
}else{
if ($adesso > $scadenza){
$query="UPDATE anagrafica_collaboratori SET stato_contratto = '$non'";
$db->setQuery($query);
$db->query();
}else{
$query="UPDATE anagrafica_collaboratori SET stato_contratto = '$si'";
$db->setQuery($query);
$db->query();
}
}
}
I try to update 'stato_contratto' with different message stored in $non ,$si and $mai
but seems don't work
some one have did the same and know the solution?
any help are welcome
Thanks in advance