dashboard_data.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

DELIMITER //

delete from qx_chart
//

insert into qx_chart (chart_id, name, public_chart, system_chart, body, `timestamp`)
values (1, 'Tickets by Priority', 1, 1, '<?xml version="1.0" encoding="UTF-8"?>
<chart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../../core/3.0u/trunk/qwcore/misc/xsd/chart.xsd">
	<chart-req>
		<chart-category-field entity="ticket.ticket" name="qw_priority" sortdir="asc" formid="eservice__ticket__ticket__ticket.ticket"/>
		<chart-data-field entity="ticket.ticket" name="qw_ticketid" formid="eservice__ticket__ticket__ticket.ticket"/>
		<req-filters>
			<req-filter entity="ticket.ticket" name="qw_status" formid="eservice__ticket__ticket__ticket.ticket">
				<req-filter-value>0</req-filter-value>
				<req-filter-value>1</req-filter-value>
				<req-filter-value>2</req-filter-value>
				<req-filter-value>3</req-filter-value>
				<req-filter-value>4</req-filter-value>
				<req-filter-value>5</req-filter-value>
				<req-filter-value>6</req-filter-value>
				<req-filter-value>7</req-filter-value>
				<req-filter-value>8</req-filter-value>
				<req-filter-value>9</req-filter-value>
			</req-filter>
		</req-filters>
	</chart-req>
	<chart-params>
		<title>Tickets created by Priority</title>
		<type>pie</type>
		<orientation>vertical</orientation>
		<chart-param name="colors" value="0xA52A2A, 0xF03800, 0x56BCBC, 0x339933, 0xFFF12D"/>
	</chart-params>
</chart>
', curdate())
//

insert into qx_chart (chart_id, name, public_chart, system_chart, body, `timestamp`)
values (2, 'Tickets by Status', 1, 1, '<?xml version="1.0" encoding="UTF-8"?>
<chart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../../core/3.0u/trunk/qwcore/misc/xsd/chart.xsd">
	<chart-req>
		<chart-category-field entity="ticket.ticket" name="qw_status" sortdir="asc" formid="eservice__ticket__ticket__ticket.ticket"/>
		<chart-data-field entity="ticket.ticket" name="qw_ticketid" formid="eservice__ticket__ticket__ticket.ticket"/>
		<req-filters>
			<req-filter entity="ticket.ticket" name="qw_status" formid="eservice__ticket__ticket__ticket.ticket">
				<req-filter-value>0</req-filter-value>
				<req-filter-value>1</req-filter-value>
				<req-filter-value>2</req-filter-value>
				<req-filter-value>3</req-filter-value>
				<req-filter-value>4</req-filter-value>
				<req-filter-value>5</req-filter-value>
				<req-filter-value>6</req-filter-value>
				<req-filter-value>7</req-filter-value>
				<req-filter-value>8</req-filter-value>
				<req-filter-value>9</req-filter-value>
			</req-filter>
		</req-filters>
	</chart-req>
	<chart-params>
		<title>Tickets created by Status</title>
		<type>bar</type>
	</chart-params>
</chart>
', curdate())
//

insert into qx_chart (chart_id, name, public_chart, system_chart, body, `timestamp`)
values (3, 'Tickets by Product', 1, 1, '<?xml version="1.0" encoding="UTF-8"?>
<chart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../../core/3.0u/trunk/qwcore/misc/xsd/chart.xsd">
	<chart-req>
		<chart-category-field entity="ticket.ticket" name="qw_productid" sortdir="asc" formid="eservice__ticket__ticket__ticket.ticket"/>
		<chart-data-field entity="ticket.ticket" name="qw_ticketid" formid="eservice__ticket__ticket__ticket.ticket"/>
		<req-filters>
			<req-filter entity="ticket.ticket" name="qw_status" formid="eservice__ticket__ticket__ticket.ticket">
				<req-filter-value>0</req-filter-value>
				<req-filter-value>1</req-filter-value>
				<req-filter-value>2</req-filter-value>
				<req-filter-value>3</req-filter-value>
				<req-filter-value>4</req-filter-value>
				<req-filter-value>5</req-filter-value>
				<req-filter-value>6</req-filter-value>
				<req-filter-value>7</req-filter-value>
				<req-filter-value>8</req-filter-value>
				<req-filter-value>9</req-filter-value>
			</req-filter>
		</req-filters>
	</chart-req>
	<chart-params>
		<title>Tickets by Product</title>
		<type>bar</type>
	</chart-params>
</chart>
', curdate())
//

insert into qx_chart (chart_id, name, public_chart, system_chart, body, `timestamp`)
values (4, 'Tickets by Organization', 1, 1, '<?xml version="1.0" encoding="UTF-8"?>
<chart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../../core/3.0u/trunk/qwcore/misc/xsd/chart.xsd">
	<chart-req>
		<chart-category-field entity="customer.ticket" name="qw_orgid" sortdir="asc" formid="eservice__ticket__ticket__customer.ticket"/>
		<chart-data-field entity="ticket.ticket" name="qw_ticketid" formid="eservice__ticket__ticket__ticket.ticket"/>
		<req-filters>
			<req-filter entity="ticket.ticket" name="qw_status" formid="eservice__ticket__ticket__ticket.ticket">
				<req-filter-value>0</req-filter-value>
				<req-filter-value>1</req-filter-value>
				<req-filter-value>2</req-filter-value>
				<req-filter-value>3</req-filter-value>
				<req-filter-value>4</req-filter-value>
				<req-filter-value>5</req-filter-value>
				<req-filter-value>6</req-filter-value>
				<req-filter-value>7</req-filter-value>
				<req-filter-value>8</req-filter-value>
				<req-filter-value>9</req-filter-value>
			</req-filter>
		</req-filters>
	</chart-req>
	<chart-params>
		<title>Tickets by Organization</title>
		<type>bar</type>
	</chart-params>
</chart>
', curdate())
//