Skip to content

Instantly share code, notes, and snippets.

View atapatel's full-sized avatar
😇
Eat, Code.... Repeat

Ajay Patel atapatel

😇
Eat, Code.... Repeat
21 followers · 58 following
View GitHub Profile
@atapatel
atapatel / ddas.skema
Created December 6, 2015 11:20
aas
[{"name":"assetss","color":"Red","position":{"x":100,"y":100},"increment":true,"timestamp":true,"softdelete":true,"column":[{"name":"","type":"increments","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c27","order":0},{"name":"Enum","type":"increments","length":"","defaultvalue":"","enumvalue":"","ai":false,"pk":false,"nu":false,"ui":false,"in":false,"un":false,"fillable":false,"guarded":false,"visible":false,"hidden":false,"colid":"c49","order":1}],"relation":[],"seeding":[]}]
@atapatel
atapatel / gist:25dd5b19dc1d69a402ab503c6503b136
Created February 14, 2019 11:16
# magento2 create order for guest customer using rest api
### 1. Get the admin token :-
EndPoint : http://magento.host/index.php/rest/V1/integration/admin/token
Method : POST
Headers:
Content-Type : application/json
@atapatel
atapatel / keybase.md
Created April 16, 2019 07:15

Keybase proof

I hereby claim:

  • I am atapatel on github.
  • I am ajaypatel (https://keybase.io/ajaypatel) on keybase.
  • I have a public key whose fingerprint is 9BCE 08BD 2AD7 B7AB 1B9D CE21 42FC 44CE B7C8 67BC

To claim this, I am signing this object:

@atapatel
atapatel / gist:d19a934538534ac82413e4ba1a32f8a6
Created April 29, 2019 11:46
Id |User |Host |db |Command|Time|State |Info
----|---------|---------------|--------|-------|----|-------------------------------|--------------------------------------------------------------------
925|crm |localhost |crm |Query |2878|Waiting for table metadata lock|LOCK TABLES `job` WRITE
940|crm |localhost |crm |Query |2865|Waiting for table metadata lock|SELECT job.id AS `id`, job.name AS `name`, job.deleted AS `deleted`,
@atapatel
atapatel / Make fast composer
Created July 19, 2019 06:02
composer config --global repo.packagist composer https://packagist.org
@atapatel
atapatel / updateProduct.php
Created July 26, 2019 06:02
product qty sku.
<?php
// Report simple running errors
error_reporting(E_ERROR | E_WARNING | E_PARSE);
use \Magento\Framework\App\Bootstrap;
include('app/bootstrap.php');
$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();
$instance = \Magento\Framework\App\ObjectManager::getInstance();
$storeManager = $instance->get('\Magento\Store\Model\StoreManagerInterface');
@atapatel
atapatel / chirag query
Created September 16, 2019 06:49
SELECT u.id,
u.user_login,
u.user_email,
u.user_registered,
MAX(IF(m.meta_key = 'first_name',m.meta_value,null)) AS firstName,
MAX(IF(m.meta_key = 'last_name',m.meta_value,null)) AS lastName,
MAX(IF(m.meta_key = 'free_trial',m.meta_value,null)) AS freeTrialEnddate,
MAX(IF(m.meta_key = 'membership_plan',m.meta_value,null)) AS plan,
MAX(IF(m.meta_key = 'membership_expiration',m.meta_value,null)) AS membershipEnded,
MAX(IF(m.meta_key = 'wp_last_active',m.meta_value,null)) AS lastLogin,
@atapatel
atapatel / gist:4c79a275967afb717b4eab9886898fa9
Created October 4, 2019 08:59
[2019-10-03 04:46:46] production.ERROR: PDOException: SQLSTATE[HY000]: General error: 1364 Field 'location_type' doesn't have a default value in /var/www/vsshah.co/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Stack trace:
#0 /var/www/vsshah.co/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute(NULL)
#1 /var/www/vsshah.co/vendor/laravel/framework/src/Illuminate/Database/Connection.php(458): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/vsshah.co/vendor/laravel/framework/src/Illuminate/Database/Connection.php(657): Illuminate\Database\Connection->Illuminate\Database\{closure}('insert into `in...', Array)
#3 /var/www/vsshah.co/vendor/laravel/framework/src/Illuminate/Database/Connection.php(624): Illuminate\Database\Connection->runQueryCallback('insert into `in...', Array, Object(Closure))
#4 /var/www/vsshah.co/vendor/laravel/framework/src/Illuminate/Database/Connection.php(459): Illuminate\Database\Connection->run('insert into `in...', Arra
@atapatel
atapatel / login.blade.php
Created October 9, 2019 02:16
`
<html>
<head>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
<script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
<!------ Include the above in your HEAD tag ---------->
<style>
/* BASIC */
@atapatel
atapatel / login.blade.php
Created October 9, 2019 06:45
`
<html>
<head>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
<script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
<!------ Include the above in your HEAD tag ---------->
<style>
/* BASIC */