.
*/
// 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
?>
:
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']);
}