��۷��

�м��ַ��ʷ��Ҫһ��ٷ��EMP��ͼ��ű��ԣ��ͼ��ӳ��Ԥ�㡣��Ȼ��Ԥ��¼��ˮƽ�Լ��Ԥ��Ƚ��Ƿ��ʾһЩ��õ��Ϣ��Ҫʵ��ֵı��棬webER��һ��۱��ɹ��ߣ��۱��棭��õ��ı��ģ��л��޸ġ��Щ��pdf��csv�ļ��csv�ļ��Ա��ȡ��

��˵��Ӧ��˿�ģ��ı��Ͳ�ѯѡ��“��۷��”��Ԥ�ȶ��۱��ﶼ��Խ��У�

�޸ı��ƣ��
�޸ı��
��б��沢��һ��PDF�ļ�
��б��沢��CSV�ļ�--��ŷָ�ֵ��Ա��κε��ȡ��

��ҳ��·��Ҳ��Դ��±��ʾ��ݵ��ۺ��Ϣ��EMP��Ե��ı�ά��ʹ��Щ��ٶ��С�

��۷��ɣ�

��Ķ��
��еĶ��

��۷��

��ĵ�һ��Ϣ��

��⣭��ַ��ϡ�
��ࣴ��ÿ��

ÿ��ѡ��е�һ�֣�

��
��Ʒ��
�˿ʹ��룭��ʵ�ʵĸ��ʻ�
��ͣ��۸��
��Ʒ��ͣ��ߴ��/��Ŀ¼��
�˿ͷֹ�˾
��Ա

��水��˳��ÿ��ˮƽ��з��. ��ѵ�һ��óɲ�Ʒ��, �ڶ��ó��۵��ô��ͻ��ʾ��Ʒ�Ĵ��룬Ȼ��ڴ˲�Ʒ��£��Ʒ��۵ĵ��Ҳ��˵��Ʒ��۵ġ�ͨ��˳��ǽ��۵��Ϊ��һ�飬��Ʒ��Ϊ�ڶ��, ��ÿ��۵��в�Ʒ�Ĵ��һ��

ÿ��鶼Ҫ��ָ��һ��Χ��ָ��ָ����ģ��ָ��ı��롣��磬��۵��룭��ǵ��ʼ��С��ֹ��򱨸潫��û��

��۷��

��Ϊ��洴��˱��֮��ǾͿ��Զ��ˡ��б��п��κ�ʱ��޸ġ��۷��ҳ��-��Ӧ��ʿ��۷��棩��ÿ��涼��һ�� "��”��ӣ��ѡ��ı��оͻ��֣�ͬʱ��ʾһ��µ��С��Զ��ÿ��λ��ԣ��Ǳ��ģ�

1��10֮��кš��Щ��־��ҳ�У��еĴ�ӡλ�ã�1��ҳ��У�10��Ҳ��С�
��λ��б��ĵ�һ�к͵ڶ��С�ÿ��λ��15��ַ��
��Ƿ��Ǽ��е��Ҫ��е��ǲ�ͬ�ġ�
��У��Ҫ��ʾ��ݵ��ڼ䷶Χ��ڼ��ֹ��ڼ��ָ��ڼ��ϵͳ�Լ��ɼ��ķ�ʽά��Ļ�ṩ��һ��ʾ��ڼ䡣��Ҫ��ڼ�Ϊ��£��ô�ڼ��ʼֹ��ͬ�ġ�
��ʾ��е��ݿ��Դ��ѡ��ëֵ,��ֵ��۳��ۿۣ��ë��󣬳ɱ��ۿۡ�
Ԥ��ۻ��ʵ�ʵ��ۡ�

��б��Ϊ��㣬��Ҫ��ڼ�ķ�Χ��Ҳ��Ҫ��ѡ��ݵ��ͣ�Ԥ��ʵ�ʡ��Ѽ��ֶε��ø�Ϊyes��ǣ�Ȼ��Ϣ��ť��ʾ��ڼ��Ҫ��ֶΣ�

��ֶΣ��Ҫ��ĵ�һ��кţ��ֶ��ڼ��Ǳ�Ҫ��ġ�
��ĸ�ֶ�--��м��еĻ��ڼ��ĵڶ��λ��Ϊ��--��ô��н�ȫ��ڳ��ķ�ĸ��ó��Ļ��ֶν��Ϊ�հס�
��֮һ��
1. ��ĸ��
2. ��
3. ��
4. ��ӷ�ĸ��
5. ��ȥ��ĸ��
�ڼ��У��κε��֡�
��ĸ�ʽ��Ա�ʾΪ�ٷ��֡�

��Ϣ��Ŧ��м��뵽��ı��С��Ӧ��ʾ�ڶ��б��С��ʾһ��ڶ��е�һ��հױ��Ҫ�µ��λ��λ��б��һ��ɾ��С�

��һ��޸��λ��ӡ��Ա��ʽ��ʾ�Ա��Ҫʱ�޸ġ�
��ά��⣬��ʾ�Ѿ��ı��ı���Թ��޸Ļ��С�Ҫ��б��棬ֻҪ�򵥵ص��PDF��ӡ�

��Щ��۱��ѯ�ܶ��Ϣ��ͨ��Ƕ�̬��ɵģ��ˣ��ǿ��Ի��Լһ��ڴ��ݿ��С�Ȼ��ݾ��ĵ��ƣ��ȷ��ܹ��ԱȺܶ��Ʒ��ö��ٶȶ�̬��ɱ��档

��ֵ�þ�һ��ɱ��ӣ��Ϊÿ��۵��͸õ��Ա��ʾ��۶��ë��
Ӧ��˿>��ѯ�ͱ��棭>��۷��

�ڶ��һ�±��棭��⴦
��“��ۣ��Ե��Ա��”

ѡ��۵��Ϊ“Group By 1" Ȼ��“��ʼ”��0��е��۵��Ŷ��0��Ȼ��“��ֹ”��”ZZZZZ"--ϣ��㶨��۵��0��ZZZZZ֮��--��ֻҪĳһ��ôֻҪ��“��ʼ”��“��ֹ”��ж��ô��뼴�ɡ�

ѡ��“��Ա”��Ϊ“Group By 2" Ȼ��“��ʼ”��0��е��Ա��Ŷ��0��Ȼ��“��ֹ”��”ZZZZZ"--ϣ��㶨��Ա��0��ZZZZZ֮��--��ֻҪĳһ��Ա��ôֻҪ��“��ʼ”��“��ֹ”��ж��ô��뼴�ɡ�

��Ϣ��˱��ݿ⡣

��嵥��ʾ��ǵ��±��“��ۣ��Ա”��е��

��˱��

��1
��1��룭“��۶�”��б��ͷһ��
��2��룭“January 08"��б��ĵڶ��

��ڲ��January 08��ڼ��Ȼ��"��ʼ�ڼ�"��“��ֹ�ڼ�"��ڼ��Ҫ��ʾһ��ڼ䷶Χ��۶��ѡ��κ��ڼ䷶Χ��ֻҪȷ��ֹ�ڼ��ʼ�ڼ�֮�� Ҫ��ʾ1�·ݵ��۶�� “��ʾ��” ѡ��ڡ��Ҫѡ��“Net Sales Value""��۶�“��п��԰��ѡ��κο�ѡ��ݡ�ë��۶�ѡ��ڼ��ۿ�֮ǰ��۶��£��Ҫ��۶
Ԥ��ʵ�ʽ��Ҫ��Ԥ��Ϊʵ�ʡ��Ҫ�Ƚ�Ԥ����ô��Ԥ��Ҫ��롣��Ŀǰû�н��û��ֶ��Ԥ�㣩��

��Ϣ,ϵͳ��ҳͷ��ʾ��еĶ��壬�Լ��е��¿հ��С�
ҪΪһ�·ݵ�ë��󴴽��һ�У��ͬ��һ��ֻ��2��Ұѱ��ִ��۶��Ϊë��󣭣�ʹ��ͬ��ڼ䷶Χ��“��ʾ��”��ѡ��“ë��”��Լ�Ԥ��ʵ��ѡ“ʵ��”��ٴε��Ϣ��ܵڶ��У��л��ʾ��Ļ�ϡ�

��б��棬��“ά��”��ӣ��鿴�Ѿ��ı��б�Ѱ��“��ۣ��Ա”��棬��“��PDF��”“--ϵͳ��б��棬һ��pdf��ᱻ��ʾ��

��ֶε��

��磬��1��ʾ2008��һ�µ��۶��2��ʾ2007��һ�µ��۶��ϣ��е��У��ʾ��۶�ռȥ��İٷֱȡ�

Ҫ��3��кţ��3��б��⣭��ȥ��ӵ�%��ѡ��--Yes, Ȼ��Ϣ��ťEnter Information Button--��ʾ“��#"�ͷ�ĸ�У�“��

��Ӧ��Ƿ��У��1��1��ĸ��Ϊ2��

��Ӧ�Ƿ��ӱ��ĸ��Ҳ��ѡ�
��ĸ�ʽӦ��ǰٷ��

�Զ��۱��

��˱��󣬿��԰��۱���ű�MailSalesReport.php��һ��ģ�塣EMPû��õ��˽ű��ӣ��Ҳû��Ϊ��ð�ȫˮ׼��ΨһҪ��ǰѴ˽ű��Ϊ��֣��.phpΪ��׺��ű��ͬһ·��¡�

�ű��Ҫ�༭�ռ��˵ĵ��ʵ�ַ�ͱ��ɣģ��ϵͳ��Ҫ��еı��š�Ҫ�༭��ǣ�
/*Ҫ��͵��۱��*/
$ReportID = 4;

/*�յ��ʱ��Ա*/
$Recipients = array('"Root" ','"some one else" ');

��/*��*/��Χ��г�Ϊע�͡�

һ��༭��ѡ��ReportID��ռ��ˣ��Ϳ��Դ��ļ��ˡ�

��linux��£��ƻ��ÿ��յ�0:0�㣬��crontab��õļƻ��棨��wget��װ��/usr/bin/wget ��ҳ��ͬһ��ϣ��½ű��ΪDailySalesReport.php),��ôӦ��
# Scheduled email of a daily sales report ��мƻ��ط��ÿ��۱��

0 0 * * 2-5 root /usr/bin/wget http://localhost/web-erp/DailySalesReport.php

��ҳû��ҳ��û��壬��ᷢ��һ��ʵ��ռ��

��һ��Ƶ�ģ��ű��MailSalesReport_csv.php,��Ϊһ��ReportID�ʼ�csv�ļ��ռ��ˡ�

�Զ��ʼ��۷��һ��ŵĽ��ʹ�ýű�report_runner.php��Դ�shell��cronֱ��У��в��ŵ��ڲ��д��һ��߽ű��ű��µ��У�
-r reportnumber (the number of the EMP report) -r �� EMP�ı��ţ�
-n reportname (the name you want to give the report) ��n �� 㸳��ı��
-e emailaddress[;emailaddress;emailaddres...] (who you want to send it to) -e ��ʵ�ַ[;��ʵ�ַ��ʵ�ַ��ݣ��Ҫ��͵��ռ��ˣ�
[-t reporttext ] (some words you want to send with the report-optional) �ۣ�t ��֣ݣ��汨��Ҫ��͵��֣��ѡ��
[ -H EMPHOME] (the home directory for EMP - or edit the php file) �ۣ�H EMPHome](EMP�ļ�Ŀ¼��߱༭php�ļ��