select( $select, $where, $orderstr, $_SESSION['config']['databasetype'] ); $status_list = $tab; $form_content .= '

' . _NOTIFICATIONS_DEST_USER_DIFF_TYPE_WITH_STATUS . '

'; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= ''; $form_content .= '
'; $form_content .= '
'; $form_content .= ''._SELECT_ALL.''; $form_content .= '		'; $form_content .= ''; $form_content .= '
'; $form_content .= '
'; $form_content .= ''; $form_content .= '		'; $form_content .= '
'; $form_content .= ''._SELECT_ALL.''; $form_content .= '
'; break; case 'recipients': $recipients = array(); $dbRecipients = new dbquery(); $dbRecipients->connect(); $select = "SELECT distinct us.*"; $from = " FROM listinstance li JOIN users us ON li.item_id = us.user_id"; $where = " WHERE li.coll_id = 'letterbox_coll' AND li.item_mode = 'dest'"; switch($event->table_name) { case 'notes': $from .= " JOIN notes ON notes.coll_id = li.coll_id AND notes.identifier = li.res_id"; $from .= " JOIN res_letterbox lb ON lb.res_id = notes.identifier"; $where .= " AND notes.id = " . $event->record_id . " AND li.item_id != notes.user_id" . " AND (" . " notes.id not in (SELECT DISTINCT note_id FROM note_entities) " . " OR us.user_id IN (SELECT ue.user_id FROM note_entities ne JOIN users_entities ue ON ne.item_id = ue.entity_id WHERE ne.note_id = " . $event->record_id . ")" . ")"; if($notification->diffusion_properties!=''){$status_tab=explode(",",$notification->diffusion_properties);$status_str=implode("','",$status_tab); $where .= " AND lb.status in ('".$status_str."')";} break; case 'res_letterbox': case 'res_view_letterbox': $from .= " JOIN res_letterbox lb ON lb.res_id = li.res_id"; $where .= " AND lb.res_id = " . $event->record_id ; if($notification->diffusion_properties!=''){$status_tab=explode(",",$notification->diffusion_properties);$status_str=implode("','",$status_tab); $where .= " AND lb.status in ('".$status_str."')";} break; case 'listinstance': default: //$where .= " AND listinstance_id = " . $event->record_id; $from .= " JOIN res_letterbox lb ON lb.res_id = li.res_id"; $where .= " AND listinstance_id = " . $event->record_id; if($notification->diffusion_properties!=''){$status_tab=explode(",",$notification->diffusion_properties);$status_str=implode("','",$status_tab); $where .= " AND lb.status in ('".$status_str."')";} } $query = $select . $from . $where; if($GLOBALS['logger']) { $GLOBALS['logger']->write($query , 'DEBUG'); } $dbRecipients->query($query); while($recipient = $dbRecipients->fetch_object()) { $recipients[] = $recipient; } break; case 'attach': $attach = false; break; case 'res_id': $select = "SELECT li.res_id"; $from = " FROM listinstance li"; $where = " WHERE li.coll_id = 'letterbox_coll' "; switch($event->table_name) { case 'notes': $from .= " JOIN notes ON notes.coll_id = li.coll_id AND notes.identifier = li.res_id"; $from .= " JOIN res_letterbox lb ON lb.res_id = notes.identifier"; $where .= " AND notes.id = " . $event->record_id . " AND li.item_id != notes.user_id"; if($notification->diffusion_properties!=''){$status_tab=explode(",",$notification->diffusion_properties);$status_str=implode("','",$status_tab); $where .= " AND lb.status in ('".$status_str."')";} break; case 'res_letterbox': case 'res_view_letterbox': $from .= " JOIN res_letterbox lb ON lb.res_id = li.res_id"; $where .= " AND lb.res_id = " . $event->record_id; if($notification->diffusion_properties!=''){$status_tab=explode(",",$notification->diffusion_properties);$status_str=implode("','",$status_tab); $where .= " AND lb.status in ('".$status_str."')";} break; case 'listinstance': default: //$where .= " AND listinstance_id = " . $event->record_id; $from .= " JOIN res_letterbox lb ON lb.res_id = li.res_id"; $where .= " AND listinstance_id = " . $event->record_id; if($notification->diffusion_properties!=''){$status_tab=explode(",",$notification->diffusion_properties);$status_str=implode("','",$status_tab); $where .= " AND lb.status in ('".$status_str."')";} } $query = $query = $select . $from . $where; if($GLOBALS['logger']) { $GLOBALS['logger']->write($query , 'DEBUG'); } $dbResId = new dbquery(); $dbResId->connect(); $dbResId->query($query); $res_id_record = $dbResId->fetch_object(); $res_id = $res_id_record->res_id; break; } ?>