Ügyfelek listázása
eladó
vevő
kapcsolat
Vevők
Név:
Prioritás (legalább):
$res = my_query ("select customer_priority.id as id, customer_priority.name as nameid, dict.id as dictid, dict.hu as name from customer_priority inner join dict on customer_priority.name = dict.id where customer_priority.act = 'enabled' order by customer_priority.pos"); while ($row = my_fetch_array ($res)) echo "
$row[name]
\n"; ?>
Prioritás (legfeljebb):
$res = my_query ("select customer_priority.id as id, customer_priority.name as nameid, dict.id as dictid, dict.hu as name from customer_priority inner join dict on customer_priority.name = dict.id where customer_priority.act = 'enabled' order by customer_priority.pos"); while ($row = my_fetch_array ($res)) echo "
$row[name]
\n"; ?>
Eladók
megbízás lejárta
tól:
ig:
Kapcsolatok
értékesítő:
---válasszon---
$uid=$_SESSION[user_id]; $user_sl=my_ff("SELECT user_post_id FROM user WHERE id='$uid'"); $uagid=my_ff("SELECT agency_id FROM user WHERE id='$uid'"); switch ($user_sl) { case '11' : $sql_ext=" AND 1 "; break; case '18' : $sql_ext=" AND ( sup_user_id='$uid' OR id='$uid' OR agency_id='$uagid') "; break; default : $sql_ext=" AND id='$uid'"; } $res=my_query("SELECT id, name FROM user WHERE act='enabled' $sql_ext ORDER BY name", true); while ( $row = my_fetch_array($res) ) { print '
' . $row[name] . '
'; } ?>
iroda:
---válasszon---
$uid=$_SESSION[user_id]; $user_sl=my_ff("SELECT user_post_id FROM user WHERE id='$uid'"); $uagid=my_ff("SELECT agency_id FROM user WHERE id='$uid'"); switch ($user_sl) { case '11' : $sql_ext=" AND 1 "; break; case '18' : $sql_ext=" AND id='$uagid' "; break; default : $sql_ext=" AND id='$uagid' "; } $res=my_query("SELECT id, name FROM agency WHERE act='enabled' $sql_ext", true); while ( $row = my_fetch_array($res) ) { print '
' . $row[name] . '
'; } ?>
listázás