function cw_salesman_get_list_smarty() { $users = cw_user_get_short_list('B'); return $users; }
function cw_warehouse_get_list_smarty() { return cw_user_get_short_list('P'); }
function cw_pos_get_list_smarty() { $pos_users = cw_user_get_short_list('G'); return $pos_users; }
} $valid_statuses = cw_query_column("select code from {$tables['order_statuses']} where inventory_decreasing=1"); foreach ($users as $k => $v) { $users[$k]['orders'] = cw_query_first_cell("SELECT count(d.doc_id) FROM {$tables['docs_user_info']} dui, {$tables['docs']} d WHERE dui.customer_id={$v['customer_id']} AND dui.doc_info_id=d.doc_info_id AND d.type='O' and d.status in ('" . implode("','", $valid_statuses) . "')"); } $smarty->assign('users', $users); } $smarty->assign('mode', $mode); } $predefined_lng_variables[] = 'lbl_search_user_' . $usertype; if (is_array($search_data['users'][$usertype]['address']['state'])) { $search_data['users'][$usertype]['address']['state'] = json_encode($search_data['users'][$usertype]['address']['state']); } $smarty->assign('js_tab', $search_data['users'][$usertype]['js_tab']); $smarty->assign('mode', $mode); $smarty->assign('payment_methods', cw_func_call('cw_payment_search', array('data' => array('type' => 1, 'active' => 1)))); $smarty->assign('memberships', cw_user_get_memberships($usertype == 'C' ? array('C', 'R') : $usertype)); $smarty->assign('employees', cw_user_get_short_list('E')); $smarty->assign('sales_managers', cw_user_get_short_list('B')); $smarty->assign('countries', cw_map_get_countries()); $smarty->assign('states', cw_map_get_states()); $smarty->assign('saved_user_search', cw_query("select * from {$tables['saved_search']} where type='C' order by name, ss_id")); $smarty->assign('search_prefilled', $search_data['users'][$usertype]); $smarty->assign('current_search_type', $usertype); $smarty->assign('current_loaded_search_id', $current_loaded_search_id); $smarty->assign('current_loaded_search_name', cw_query_first_cell("select name from {$tables['saved_search']} where type='C' and ss_id='{$current_loaded_search_id}'")); if ($is_ajax) { global $ajax_blocks; $ajax_blocks[] = array('id' => 'search_result', 'template' => 'main/users/search_results.tpl'); $ajax_blocks[] = array('id' => 'script', 'template' => 'js/navigation.js'); }
cw_header_location('index.php'); } if ($action == "apply" && is_array($plans)) { foreach ($plans as $k => $v) { db_query("REPLACE INTO {$tables['salesman_commissions']} (salesman_customer_id, plan_id) VALUES ('{$k}', '{$v}')"); } cw_header_location("index.php?target=salesman_commissions&mode=go&page={$page}&salesman={$salesman}&applied"); } elseif ($action == "apply_global" && $pc) { // TODO: no SQL, API only $salesmans = cw_query_column("SELECT customer_id FROM {$tables['customers']} WHERE usertype = 'B'" . ($salesman && $use_filter ? " AND email LIKE '%{$salesman}%'" : "")); if ($salesmans) { foreach ($salesmans as $v) { db_query("REPLACE INTO {$tables['salesman_commissions']} (salesman_customer_id, plan_id) VALUES ('{$v}', '{$pc}')"); } } $top_message['content'] = cw_get_langvar_by_name("txt_plan_was_successfully_applied"); $top_message['type'] = "I"; cw_header_location("index.php?target=salesman_commissions&mode=go&pc={$pc}&salesman={$salesman}&use_filter={$use_filter}"); } elseif ($action == "go") { // TODO: no SQL, API only $salesman_info = cw_query("SELECT {$tables['salesman_commissions']}.plan_id, {$tables['customers']}.customer_id FROM {$tables['customers']} LEFT JOIN {$tables['salesman_commissions']} ON {$tables['salesman_commissions']}.salesman_customer_id={$tables['customers']}.customer_id WHERE {$tables['customers']}.usertype = 'B' AND {$tables['customers']}.email LIKE '" . (empty($salesman) || $use_filter != 'Y' ? "%" : "%{$salesman}%") . "' order by {$tables['customers']}.customer_id"); $smarty->assign("salesman_info", $salesman_info); $smarty->assign('mode', 'go'); } $salesmans = cw_user_get_short_list('B'); $salesman_plans = cw_query("SELECT * FROM {$tables['salesman_plans']} ORDER BY title, plan_id"); $smarty->assign("salesman_plans", $salesman_plans); $smarty->assign("salesmans", $salesmans); $smarty->assign("salesman", $salesman); $smarty->assign("use_filter", $use_filter); $smarty->assign('main', 'commissions');