. */ // Group - Basket Form : actions params require_once 'apps' . DIRECTORY_SEPARATOR . $_SESSION['config']['app_id'] . DIRECTORY_SEPARATOR . 'apps_tables.php'; if($_SESSION['service_tag'] == 'group_basket') { $current_groupbasket = $_SESSION['m_admin']['basket']['groups'][$_SESSION['m_admin']['basket']['ind_group']]; $current_compteur = $_SESSION['m_admin']['compteur']; // This param is only for the actions with the keyword : indexing if(trim($_SESSION['m_admin']['basket']['all_actions'][$current_compteur]['KEYWORD']) == 'indexing') // Indexing case { $_SESSION['m_admin']['show_where_clause'] = false; $is_default_action = false; // Is the action the default action for the group on this basket ? if( isset($current_groupbasket['DEFAULT_ACTION']) && $_SESSION['m_admin']['basket']['all_actions'][$current_compteur]['ID'] == $current_groupbasket['DEFAULT_ACTION']) { $is_default_action = true; } // indexing statuses list ?>

_statuseslist"));' >

_statuseslist"),document.getElementById("_statuses_chosen"));' />

_statuses_chosen"),document.getElementById("_statuseslist"));' />

0) { for ($k=0; $k < count($_REQUEST[$_SESSION['m_admin']['basket']['groups'][$cpt]['ACTIONS'][$j]['ID_ACTION'].'_statuses_chosen']); $k++) { $statusId = $_REQUEST[$_SESSION['m_admin']['basket']['groups'][$cpt]['ACTIONS'][$j]['ID_ACTION'].'_statuses_chosen'][$k]; $stmt = $db->query("SELECT label_status FROM " .$_SESSION['tablename']['status']. " WHERE id = ?", array($statusId)); $res = $stmt->fetchObject(); $label = $res->label_status; array_push($chosen_statuses , array( 'ID' => $statusId, 'LABEL' => $label)); } } $_SESSION['m_admin']['basket']['groups'][$cpt]['ACTIONS'][$j]['STATUSES_LIST'] = $chosen_statuses ; } if ($_SESSION['m_admin']['basket']['groups'][$cpt]['GROUP_ID'] == $groupe) { $ind = $cpt; $find = true; break; } if ($old_group == $_SESSION['m_admin']['basket']['groups'][$cpt]['GROUP_ID']) { $ind = $cpt; $find = true; break; } } } if ($find && $ind >= 0) { //$_SESSION['m_admin']['basket']['groups'][$ind]['PARAM_DEFAULT_ACTION'] = array(); $_SESSION['m_admin']['basket']['groups'][$ind]['PARAM_DEFAULT_ACTION']['STATUSES_LIST'] = array(); if (isset($_REQUEST[$_SESSION['m_admin']['basket']['groups'][$ind]['DEFAULT_ACTION'].'_statuses_chosen']) && count($_REQUEST[$_SESSION['m_admin']['basket']['groups'][$ind]['DEFAULT_ACTION'].'_statuses_chosen']) > 0) { for ($l=0; $l < count($_REQUEST[$_SESSION['m_admin']['basket']['groups'][$ind]['DEFAULT_ACTION'].'_statuses_chosen']); $l++) { $statusId = $_REQUEST[$_SESSION['m_admin']['basket']['groups'][$ind]['DEFAULT_ACTION'].'_statuses_chosen'][$l]; $stmt = $db->query("SELECT label_status FROM " .$_SESSION['tablename']['status']. " WHERE id = ?", array($statusId)); $res = $stmt->fetchObject(); $label = $res->label_status; array_push($_SESSION['m_admin']['basket']['groups'][$ind]['PARAM_DEFAULT_ACTION']['STATUSES_LIST'] , array( 'ID' =>$statusId, 'LABEL' => $label)); } } } $_SESSION['m_admin']['load_groupbasket'] = false; } elseif($_SESSION['service_tag'] == 'load_basket_session') { $db = new Database(); for($cpt=0; $cpt < count($_SESSION['m_admin']['basket']['groups'] ); $cpt++) { $_SESSION['m_admin']['basket']['groups'][$cpt]['PARAM_DEFAULT_ACTION']['STATUSES_LIST'] = array(); if(!empty($_SESSION['m_admin']['basket']['groups'][$cpt]['DEFAULT_ACTION'] )) { $query = "SELECT status_id, label_status FROM " . GROUPBASKET_STATUS . " left join " . $_SESSION['tablename']['status'] . " on status_id = id " . " WHERE basket_id= ? and group_id = ? and action_id = ?"; $arrayPDO = array(trim($_SESSION['m_admin']['basket']['basketId']), trim($_SESSION['m_admin']['basket']['groups'][$cpt]['GROUP_ID']), $_SESSION['m_admin']['basket']['groups'][$cpt]['DEFAULT_ACTION']); $stmt = $db->query($query, $arrayPDO); $array = array(); while($status = $stmt->fetchObject()) { $array[] = array('ID' => $status->status_id, 'LABEL' => $status->label_status); } $_SESSION['m_admin']['basket']['groups'][$cpt]['PARAM_DEFAULT_ACTION']['STATUSES_LIST'] = $array; } for($j=0;$jquery($query, $arrayPDO); $array = array(); while($status = $stmt->fetchObject()) { $array[] = array('ID' => $status->status_id, 'LABEL' => $status->label_status); } $_SESSION['m_admin']['basket']['groups'][$cpt]['ACTIONS'][$j]['STATUSES_LIST'] = $array; } } } elseif($_SESSION['service_tag'] == 'load_basket_db') { $db = new Database(); $indexing_actions = array(); for($cpt=0; $cptquery( "DELETE FROM " . GROUPBASKET_STATUS . " WHERE basket_id= ? and group_id = ? and action_id = ?", array(trim($_SESSION['m_admin']['basket']['basketId']), trim($GroupBasket['GROUP_ID']), $GroupBasket['DEFAULT_ACTION'])); for ($k = 0; $k < count($GroupBasket['PARAM_DEFAULT_ACTION']['STATUSES_LIST']); $k++) { $Status = $GroupBasket['PARAM_DEFAULT_ACTION']['STATUSES_LIST'][$k]; $db->query( "INSERT INTO " . GROUPBASKET_STATUS . " (group_id, basket_id, action_id, status_id) values (?, ?, ?, ?)", array(trim($GroupBasket['GROUP_ID']), trim($_SESSION['m_admin']['basket']['basketId']), $GroupBasket['DEFAULT_ACTION'], $Status['ID']) ); } } for($j=0;$jupdate_redirect_groupbasket_db($_SESSION['m_admin']['basket']['groups'][$cpt]['GROUP_ID'], $_SESSION['m_admin']['basket']['basketId'],$_SESSION['m_admin']['basket']['groups'][$cpt]['ACTIONS'][$j]['ID_ACTION'],$_SESSION['m_admin']['basket']['groups'][$cpt]['ACTIONS'][$j]['STATUSES_LIST']); $db->query( "DELETE FROM " . GROUPBASKET_STATUS . " where basket_id= ? and group_id = ? and action_id = ?", array(trim($_SESSION['m_admin']['basket']['basketId']), trim($GroupBasket['GROUP_ID']), $GroupBasketAction['ID_ACTION'])); if (isset($GroupBasketAction['STATUSES_LIST'])) { for ($k = 0; $k < count($GroupBasketAction['STATUSES_LIST']); $k++) { $Status = $GroupBasketAction['STATUSES_LIST'][$k]; $db->query( "INSERT INTO " . GROUPBASKET_STATUS . " (group_id, basket_id, action_id, status_id) values (?, ?, ?, ?)", array(trim($GroupBasket['GROUP_ID']), trim($_SESSION['m_admin']['basket']['basketId']), $GroupBasketAction['ID_ACTION'], $Status['ID']) ); } } } } } } else if($_SESSION['service_tag'] == 'del_basket' && !empty($_SESSION['temp_basket_id'])) { $db = new Database(); $db->query("DELETE FROM ".GROUPBASKET_STATUS." WHERE basket_id = ?", array($_SESSION['temp_basket_id'])); unset($_SESSION['temp_basket_id']); }