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');
