I have a project that utilizes a Bootstrap admin theme, [login to view URL]
This project is partially complete and i need some assistance to speed the project along. The project is a jquery mobile MVC/bootstrap application written with Visual Basic 2010 using razor syntax.
================================ 1st Task ===============================================
1. Dashboard "page" or "view". I have 2 charts that retrieve date (json) for the charts. The existing queries need to be corrected to return the right data. The data that is currently being returned looks like this ("7/13", "890.00"; 7/21", "930.00"; 10/29", "1100.00") and i need the chart to show the last 6 months with a sum for each month such as ("July", "120.00"; "Aug", "0.00"; "Sep", "1389.00"). Empty months should show a "0.00". I attached a photo of the chart and how it looks now.
------------- Here is the Controller Action that populates the chart:
Public Function CustomerList(Id As String) As JsonResult
Dim db As New floodpro2Entities
Dim user__1 As v2_Users = [login to view URL](Function(u) u.User_Name = [login to view URL] AndAlso u.user_id_mob = 1).SingleOrDefault()
Dim result = From r In db.v2_Customer Where r.Last_Name IsNot Nothing Where r.Company_UUID = user__1.Company_UUID Where r.inv_total IsNot Nothing Select New With {.tod = r.Create_DateTime, .yor = r.inv_total}
Dim orderGroups = From p In result Group p By Key = [login to view URL] Into Group _
Select tod = Key, yor = [login to view URL](Function(l) [login to view URL])
Return Json(orderGroups, [login to view URL])
End Function
------------ Here is the on page javascript:
$('#myDataTable').dataTable();
$.ajax({
url: '@[login to view URL]("CustomerList", "CloudApp")',
type: 'GET',
dataType: 'json',
success: function (data) {
var datax = [login to view URL](data);
//I implemented the loop below to format the dates in the array.
$.each(data, function (i, item) {
// alert("Mine is " + i + "|" + [login to view URL] + "|" + [login to view URL]);
[login to view URL] = [login to view URL]
[login to view URL] = eval([login to view URL](/\/Date\((\d+)\)\//gi, "new Date($1)"));
[login to view URL] = [login to view URL]() + "/" + [login to view URL]();
});
datax = [login to view URL](data);
// alert(datax);
[login to view URL]({
element: 'placeholder',
data: $.parseJSON(datax),
xkey: ['tod'],
ykeys: ['yor'],
parseTime: false,
xLabels: "day",
labels: ['yor']
});
}
});
================================ 2nd Task ===============================================
The chart that i want you to use can be seen on this page: [login to view URL] It is the small "Net Revenue" chart.
I need this chart to display expenses grouped by months for the last six months.
================================ 3rd Task ===============================================
The chart that i want you to use can be seen on this page: [login to view URL] It is the Demographic Map on the right side of the page.
I need this map to display the "top 5" most recent customers and the map needs to plot their address on the map.
-------------------------------------------------------Expert Team Here ready to start with more than 11 years experinece--------------------------------------
Hi We have excellent designing and website development skills and have completed over 700 projects at Freelancer.com.
Please let us know if you like to have a registration page that will capture prospects registration details on a database as well as send that to you over mail ?
we will complete ur project as u want
Thanks
Gopisoft Private Limited
we are very interested in this job; we don't ask for milestones or escrow, don't pay money unless finishing and you see excellent results; waiting to start now!