Project

General

Profile

CR #3141

CR #3059: It would be better to include a one liner of recent activity history along with date, time and file name

Added by Carolin Babu over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Low
Target version:
Start date:
07/23/2024
Due date:
12/05/2024
% Done:

100%

Estimated time:
Milestone:
Sprint 21 Tukxi Ride 2024 July 01 to July 31
Branch name:

Description

https://mine.tukxi.in/admin/import_incentives.php

For the above-mentioned page, it will be great if we provide a one liner of recent activity history along with date, time and file name


Impact Analysis

Created a table called activity_logs for tracking the users activities , every time user import data the last activity will be show in the activities division.


Related issues

Related to CR #3059: Driver App Earnings Page (Service)ClosedAnandhu P Kumar08/09/202408/12/2024

Actions
#1

Updated by Shalu T S over 1 year ago

  • Related to CR #3059: Driver App Earnings Page (Service) added
#2

Updated by Jithin Kuriakose over 1 year ago

  • Tracker changed from Enhancements to CR
  • Assignee changed from Jithin Kuriakose to Anandhu P Kumar
  • Milestone set to Sprint 21 Tukxi Ride 2024 July 01 to July 31
#3

Updated by Anandhu P Kumar over 1 year ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100
  • Impact Analysis updated (diff)

Created a table called activity_logs for tracking the users activities, added the recent activity is listing in the activity division. Also provided a sample csv file to import data correctly.
Need to add below query for creating the table activity_logs,

CREATE TABLE `ridedoot_mine`.`activity_logs` (
`id` INT NOT NULL AUTO_INCREMENT,
`user_id` INT NOT NULL,
`activity_type` ENUM NOT NULL,
`description` VARCHAR NULL DEFAULT NULL,
`timestamp` DATETIME NOT NULL,
`ip_address` VARCHAR NULL DEFAULT NULL,
`additional_info` JSON NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;

#4

Updated by Anandhu P Kumar over 1 year ago

correct query to create activity_log table

CREATE TABLE `ridedoot_mine`.`activity_logs` (
`id` INT NOT NULL AUTO_INCREMENT,
`user_id` INT NOT NULL,
`activity_type` ENUM NOT NULL,
`description` VARCHAR NULL DEFAULT NULL,
`timestamp` DATETIME NOT NULL,
`ip_address` VARCHAR NULL DEFAULT NULL,
`additional_info` JSON NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE = InnoDB;

#5

Updated by Jithin Kuriakose over 1 year ago

  • Status changed from Resolved to QA Ready
#6

Updated by Shalu T S over 1 year ago

  • Status changed from QA Ready to Reopened

1. "Out of 3 rows, 1 rows uploaded successfully, Failed to upload 2 rows." Message showing while upload the document with one row of data.
2. The amount is not gets updated in the driver app.

#7

Updated by Anandhu P Kumar over 1 year ago

changed the sample csv file, the issue is getting after deleting an existing data and upadating with new data so the sample data provided in the csv is reduced to 1.

#8

Updated by Anandhu P Kumar over 1 year ago

  • Status changed from Reopened to In Progress
#9

Updated by Anandhu P Kumar over 1 year ago

  • Status changed from In Progress to Resolved
#10

Updated by Jithin Kuriakose over 1 year ago

  • Status changed from Resolved to QA Ready
#11

Updated by Shalu T S over 1 year ago

  • Status changed from QA Ready to QA Passed

Issue fixed.

#13

Updated by Shalu T S over 1 year ago

  • Due date set to 12/05/2024
  • Status changed from QA Passed to Closed

Also available in: Atom PDF