按照系统脚本说明帮助提示，下面的脚本
int vr_remind_008_func()
{
string sql,today,beg_date,sql;
today=get_cur_date_std();
beg_date=date_add(today,-7);
sql = "select clew_id,eba_name,eba_from,linkman,state,state_date,create_date,create_user_id,office_no,mobile_no,qq_no,msn_no,emp_id,note_info from crm_clew where ";
sql= sql + "(state ='A' or state='B') and state_date <='"+beg_date+"'";
//msg(sql);
db_run(sql);
//db_show();
db_set_field_info(0,'clew_id',"线索编号",60);
db_set_field_info(1,'eba_name',"客户名称",150);
db_set_field_info(2,'eba_from',"客户来源",60);
db_set_field_info(3,'linkman',"联系人",60);
db_set_field_info(4,'state',"线索状态",60);
db_set_field_info(5,'state_date',"更新日期",80);
db_set_field_info(6,'create_date',"创建日期",80);
db_set_field_info(7,'create_user_id',"创建员工",60);
db_set_field_info(8,'office_no',"电话",100);
db_set_field_info(9,'mobile_no',"手机",100);
db_set_field_info(10,'qq_no',"QQ号",80);
db_set_field_info(11,'msn_no',"旺旺号",80);
db_set_field_info(12,'emp_id',"业务员",80);
db_set_field_info(13,'note_info',"备注",80);
db_map('eba_from','eba_from',"eba_from");
db_map('crm_clew_state','state',"state");
db_map('app_emp','emp_id','emp_id');
user_para_set('vr_remind_obj_type','crm_clew');
user_para_set('vr_remind_obj_key_col','clew_id');
return 1;
};
中的，
user_para_set('vr_remind_obj_type','crm_clew');
user_para_set('vr_remind_obj_key_col','clew_id');
应该可以实现通过双击打开客户线索编辑界面，但实际操作中却没法实现。 |
