phpMyDataGrid Sample

Calculated Fields and totals

Este ejemplo enseña a utilizar fórmulas para realizar cálculos entre columnas y totalización de datos

This sample teach how to use formula and totals

{"emp_id" : {"strfieldName" : "emp_id","strHeader" : "ID","fieldWidth" : "40","maxlength" : "50","columnwidth" : "93px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"active" : {"strfieldName" : "active","strHeader" : "Status","fieldWidth" : "13","maxlength" : "1","columnwidth" : "60px","align" : "left","mask" : "check:Inactive:Active","default" : "","select" : {0 : "Inactive",1 : "Active"},"cutChar" : "0","datatype" : "check","inputtype" : "0","ordering" : "1"},"fname" : {"strfieldName" : "fname","strHeader" : "Name","fieldWidth" : "13","maxlength" : "20","columnwidth" : "95px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"minit" : {"strfieldName" : "minit","strHeader" : "Middle Name","fieldWidth" : "5","maxlength" : "1","columnwidth" : "80px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"lname" : {"strfieldName" : "lname","strHeader" : "Last Name","fieldWidth" : "5","maxlength" : "30","columnwidth" : "95px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"birth_date" : {"strfieldName" : "birth_date","strHeader" : "Birth Date","fieldWidth" : "5","maxlength" : "10","columnwidth" : "105px","align" : "left","mask" : "date:mdy:/","default" : "","select" : "","cutChar" : "0","datatype" : "date","inputtype" : "0","ordering" : "1"},"salary" : {"strfieldName" : "salary","strHeader" : "Salary","fieldWidth" : "5","maxlength" : "30","columnwidth" : "95px","align" : "right","mask" : "2:x:.","default" : "","select" : "","cutChar" : "0","datatype" : "number","inputtype" : "0","ordering" : "1"},"days" : {"strfieldName" : "days","strHeader" : "Days","fieldWidth" : "5","maxlength" : "30","columnwidth" : "95px","align" : "right","mask" : "integer:x:.","default" : "","select" : "","cutChar" : "0","datatype" : "number","inputtype" : "0","ordering" : "1"},"total_salary" : {"strfieldName" : "total_salary","strHeader" : "Value Days","fieldWidth" : "10","maxlength" : "10","columnwidth" : "120px","align" : "right","mask" : "scalc:((salary/30)*days)//money:$","default" : "","select" : "","cutChar" : "0","datatype" : "calc","inputtype" : "1","ordering" : "1"}};

Export

	ID

	Status

	Name

	Middle Name

	Last Name

	Birth Date

	Salary

	Days

	Value Days

No records found

Tip: Click over the data to edit it directly in the grid
Sugerencia: Haga clic sobre los datos para editar directamente en el grid