Posts

Display Status Column in reactjs

 Display status column with action button if status_id == 3 { title : 'Status' , dataIndex : [ 'status' , 'status_title' ], render : (dom, entity) => ( <Space> <span> {dom} </span> {entity. status .id === 3 && ( <Button onClick = {() => handleStatusButtonClick (entity)} > Action </Button> )} </Space> ), },

Permission issue after upload project

If Permission issue after upload project then type below command   sudo chown -R www-data:www-data /var/www/api.connect21.in/storage /var/www/api.connect21.in/bootstrap/cache

Get All MySql user list using command

Login using Below command  mysql -u root -p  After login type below command to know complete mysql User List SELECT User, Host FROM mysql.user;

Send Data on click Button in reactJs

 Send Data on click Button in reactJs const handleOpenMap = (latitude, longitude) => {   // Use the latitude and longitude in the URL   const mapsUrl = `https://www.google.com/maps?q=${latitude},${longitude}`;   window.open(mapsUrl, '_blank'); }; <a type={"link"} onClick={() => handleOpenMap(currentRow?.lat, currentRow?.long)}>   {currentRow?.lat},{currentRow?.long} </a>

Name Validation in Laravel

  Alphabetic and Spaces Names often contain spaces (e.g., first and last names). To allow alphabetic characters and spaces: $request->validate([ 'name' => 'required|regex:/^[a-zA-Z\s]*$/', ]); Including Dashes and Apostrophes Some names might include dashes or apostrophes. You can adjust the regular expression to allow these: $request->validate([ 'name' => 'required|regex:/^[a-zA-Z\s\'\-]*$/', ]);

Axis Bank BBPS API Integration

Integrating with Axis Bank's Bharat Bill Payment System (BBPS) involves a few key steps that require both technical know-how and access to specific financial services APIs. The BBPS, facilitated by the National Payments Corporation of India (NPCI), provides a standardized platform for making bill payments across the country. While I can guide you through the general process, please note that the exact details, including API credentials and specific integration steps, will be available only through Axis Bank's official channels and documentation. ### General Steps for API Integration: 1. **Register with Axis Bank**: Before you can integrate with their BBPS API, you need to establish a formal relationship with Axis Bank. This involves registering your business and applying for access to their payment APIs. The registration process may require you to submit business details, KYC documentation, and other relevant information. 2. **API Documentation**: Once registered, you will gain

Group by Provider ID of Logged in User in Laravel

  To adjust the query to accommodate transactions where the status_id is either 1 or 6, you can use the whereIn method provided by Laravel's Query Builder. This method allows you to specify an array of values that the status_id column must match. Here's how you can modify the getTransactionAggregates method in your controller to include this logic: namespace App\Http\Controllers; use Illuminate\Http\Request; use Illuminate\Support\Facades\DB; class TransactionController extends Controller { public function getTransactionAggregates($user_id, Request $request) { $startDate = $request->query('startDate'); $endDate = $request->query('endDate'); $transactionAggregates = DB::table('reports') ->where('reports.user_id', $user_id) ->join('providers', 'reports.provider_id', '=', 'providers.id') ->whereBetween('reports.created_at'