示例#1
0
        public async Task <IActionResult> ClickStat(TechType techtype, DateTime?date1, DateTime?date2, string obj_type, string obj_id)
        {
            var partinfo = (PartnerInfo)GetUserInfo();

            if (!partinfo.IsApproved || partinfo.IsAnal)
            {
                return(StatusCode(403, new Dictionary <string, string>()
                {
                    ["method"] = "clickstat",
                    ["status"] = "Access denied",
                    ["errorMsg"] = "Нет доступа в раздел статистики кликов"
                }));
            }

            _cm.GetDates(date1, date2, out DateTime start_date, out DateTime end_date);

            var sqlparameters = new SqlParameters
            {
                { "start_date", start_date },
                { "end_date", end_date },
                { "p_service_type", (int)techtype },
                { "p_obj_type", obj_type },
                { "p_obj_id", obj_id },
                { "p_idp", partinfo.Idp }
            };

            var data = new List <Dictionary <string, object> >();

            try
            {
                data = (await _db.SQLSendQueryMySQLAsync("getdata", sqlparameters).ConfigureAwait(false))[0];
            }
            catch (Exception ex)
            {
                return(StatusCode(503, ex.Message));
            }

            var hashes = data.Select(item => new { hash = (string)item["hash"], service_type = (sbyte)item["service_type"] }).ToArray();

            using var hashdata = new DataTable();

            hashdata.Columns.Add("hash", typeof(string));
            hashdata.Columns.Add("service_type", typeof(int));
            foreach (var item in hashes)
            {
                hashdata.Rows.Add(item.hash, item.service_type);
            }

            var sqlcommand = new SqlCommand("GetClickStat")
            {
                CommandType = CommandType.StoredProcedure
            };
            SqlParameter tvpParam = sqlcommand.Parameters.AddWithValue("@hashes", hashdata);

            tvpParam.SqlDbType = SqlDbType.Structured;

            var statdata = new List <Dictionary <string, object> >();

            try
            {
                statdata = (await _db.SQLSendQueryFromCommandAsync(sqlcommand).ConfigureAwait(false))[0];
            }
            catch (Exception ex)
            {
                return(StatusCode(503, ex.Message));
            }

            var result = (from d in data
                          join s in statdata
                          on d["hash"] equals s["hash"]
                          select new Dictionary <string, object>
            {
                { "date", d["date"] },
                { "obj_type", d["obj_type"] },
                { "obj_id", d["obj_id"] },
                { "phone", d["phone"] },
                { "ip", d["ip"] },
                { "host", d["host"] },
                { "uri", d["uri"] },
                { "referer", d["referer"] },
                { "orderid", s["orderid"] },
                { "orderstat", s["orderstat"] }
            }).ToList();

            string fileDownloadName = $"{techtype}_clickstat_from_{start_date:yyyy-MM-dd}_to_{end_date:yyyy-MM-dd}.xlsx";

            byte[] fileContents = await FileFormatter.GetFile(FileType.xlsx, result);

            if (fileContents == null || fileContents.Length == 0)
            {
                return(NotFound());
            }

            return(File(
                       fileContents: fileContents,
                       contentType: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
                       fileDownloadName: fileDownloadName
                       ));
        }
        public async Task <IActionResult> GetFile(OrderType ordertype,
                                                  FileType format,
                                                  DateTime?date1,
                                                  DateTime?date2)
        {
            _cm.GetDates(date1, date2, out DateTime start_date, out DateTime end_date);

            var partinfo = (PartnerInfo)GetUserInfo();

            if (!partinfo.IsApproved || partinfo.IsAnal)
            {
                return(StatusCode(403, new Dictionary <string, string>()
                {
                    ["method"] = "files",
                    ["status"] = "Access denied",
                    ["errorMsg"] = "Нет доступа в раздел файлов"
                }));
            }

            var sqlparameters = new SqlParameters
            {
                { "part_id", partinfo.UserId },
                { "start_date", start_date },
                { "end_date", end_date }
            };

            string command = ordertype switch
            {
                OrderType.report_stat => $"EXEC dbo.GetReport {sqlparameters}",
                OrderType.cross_stat => $"EXEC dbo.GetCross {sqlparameters}",
                _ => null
            };

            var keys = ordertype switch
            {
                OrderType.report_stat => new string[] { "id", "name", "city", "status", "createddate" },
                OrderType.cross_stat => new string[] { "id", "name", "city", "phone", "address" },
                _ => null
            };

            List <Dictionary <string, object> > data;

            try
            {
                data = (await _db.SQLSendQueryAsync <QueryData>(command, sqlparameters).ConfigureAwait(false))[0];
            }
            catch (Exception ex)
            {
                return(StatusCode(503, ex.Message));
            }

            var contentType = format switch
            {
                FileType.xml => "application/xml",
                FileType.xlsx => "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
                _ => ""
            };

            string fileDownloadName = $"{ordertype}_from_{start_date:yyyy-MM-dd}_to_{end_date:yyyy-MM-dd}.{format}";

            byte[] fileContents = await FileFormatter.GetFile(format, data, keys);

            if (fileContents == null || fileContents.Length == 0)
            {
                return(NotFound());
            }

            return(File(
                       fileContents: fileContents,
                       contentType: contentType,
                       fileDownloadName: fileDownloadName
                       ));
        }
    }
}