CREATE TABLE `clients` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`name` varchar(11) NOT NULL,
`associate` varchar(100) NOT NULL,
`revenue` int(12) NOT NULL,
`profit` int(12) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN key (`associate`) references `emp`(`emp_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
alter table `emp` add COLUMN `phone` int(12) not null after `name`
alter table `emp` add COLUMN `phone` int(12) null after `name`
alter table `emp` modify `phone` int(12) null
alter table `emp` drop column `phone`
ALTER TABLE `emp`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `emp_code` (`emp_code`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `emp`
--
ALTER TABLE `emp`
MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;
COMMIT;
Month: February 2019
How to fix Composer should be invoked via the CLI version of PHP, not the cgi-fcgi SAPI error in SSH?
Put this in your bash profile and run source ~/.bashrc
alias composer="/opt/cpanel/ea-php71/root/usr/bin/php /opt/cpanel/composer/bin/composer"
As Composer is now available via WHM you can use this to find it:
which composer
This returned path “/opt/cpanel/composer/bin/composer” for me. If this returns nothing then disregard the rest of this answer, as Composer is not available to you at system level.
You can now use php-cli to call this with Composer’s absolute path:
php-cli /opt/cpanel/composer/bin/composer install
php-cli /opt/cpanel/composer/bin/composer update
php-cli /opt/cpanel/composer/bin/composer require whatever/example
You may however need to alias php-cli if your system claims this isn’t found. It very much depends how PHP has been deployed on the WHM server. Learn how to fix PHP CLI error. You can do this by adding a user alias to the end of your “.bashrc” or “.bash_profile” file as follows:
alias php-cli=/opt/cpanel/ea-php72/root/usr/bin/php
Replace ea-php72 with the release of PHP you want to use. Submit this as a command in the shell to make it available immediately, otherwise it’ll become available when you open your next Bash session.
If you want to make this available with just composer alone you could create this alias again in “.bashrc”:
alias composer=/opt/cpanel/ea-php72/root/usr/bin/php /opt/cpanel/composer/bin/composer
Reference: https://stackoverflow.com/a/53478183/2229148
How to switch your DNS to Google DNS or Cloudflare DNS on Windows 10?
So, this is the scenario. You are using some local ISP which has its own DNS server fulfilling your DNS requests but to speed things up and not rely upon a DNS server which is updated less frequently. For that purpose,we can switch our computer’s DNS to some other public DNS like Google’s or Cloudflare DNS.
Step 1: Right click the Network Icon in your task bar.
Step 2: Choose “Open Network & Sharing Settings“
Step 3: Click on “Change Adapter Options“
Step 4: Right click on the active hardware and select “properties“
Step 5: Select “Internet Protocol Version 4 (TCP/IPv4)” and Click Properties button in the bottom
Step 6: Input the IP addresses after choosing “Use the following DNS Server Addresses“
Step 7: Select OK to close the pop up window. Restart your browser and have a better browsing experience.
Cloudflare’s Public DNS Servers/addresses for IPv4:
1.1.1.1
1.0.0.1
Cloudflare’s Public DNS Servers/addresses for IPv6:
2606:4700:4700::1111
2606:4700:4700::1001
Google’s DNS Servers for IPv4:
8.8.8.8
8.8.4.4
The Google Public DNS IPv6 addresses are:
2001:4860:4860::8888
2001:4860:4860::8844
What happened to googleforwork.com? Welcome the new cloudconnect.goog domain
So GoogleforWork.com is now being redirected to cloud.google.com and the same applies for its subdomain connect.googleforwork.com.
Earlier the campaigns at google work communities are now hosted at www.cloudconnect.goog
It is interesting to note that it uses .goog and not .google TLD, here is some more info about .goog TLD
In the past we have seen .google tld for many purposes like AI to Everyone at ai.google and Google’s design lab and research on design technology
The future will be interesting in terms of TLDs when banks, tech giants and telecom companies are switching their websites to their own custom TLDs and regular people can hardly remember the apparently new gTLDs.
Testing Configuration for Paytm Gateway Plugin India
Paytm Payment Gateway Testing Data
Online payment solutions for all your transactions by Paytm Woocommerce Plugin
Download the plugin here: https://github.com/Paytm-Payments/Paytm_Woocommerce_Kit
Enable/Disable
Enable/Disable Enable Paytm Payments.
Title
Title
Paytm
This controls the title which the user sees during checkout.
Description
Description
The best payment gateway provider in India for e-payment through credit card, debit card & netbanking.
This controls the description which the user sees during checkout.
Merchant Identifier
Merchant Identifier
<provided link below>
Merchant Id Provided by Paytm
Secret Key
Secret Key
<provided link below>
Merchant Secret Key Provided by Paytm
Website
Website
WEBSTAGING
Website Name Provided by Paytm
Industry Type
Industry Type
Retail
Industry Type Provided by Paytm
Channel ID
Channel ID
WEB
Channel ID Provided by Paytm
Transaction URL
Transaction URL
https://securegw-stage.paytm.in/theia/processTransaction
Transaction URL Provided by Paytm
Transaction Status Url
Transaction Status Url
https://securegw-stage.paytm.in/merchant-status/getTxnStatus
Transaction Status URL Provided by Paytm
API Keys
You can get your keys here https://dashboard.paytm.com/next/apikeys
API keys are unique credentials issued to every merchant. While MID is used as an identification used for all exchange correspondence, merchant key is used to encrypt every API request to Paytm and decrypt every response from Paytm. Ensure that you keep the merchant key on server side and should not be shared with anyone. In case API keys are compromised, please reach out to our helpdesk to get new API keys.
- MID (Merchant ID) – Unique identifier issued to every merchant.
- Merchant Key – This is a unique secret key used for secure encryption of every request. This needs to be kept on server side and should never be shared with anyone.
- Industry Type ID – This is part of bank and paymode configuration done wrt to an account.
- Website – This parameter is used to support multiple callback URLs to post the transaction response. Each URL needs to be mapped to a website parameter.
Test API Details are something like this:
- Test Merchant ID WArHEFXXXXXXXXXXXXXX <–wont work
- Test Account Secret Key XXXXXXXXOcv1u7P2 <- wont work
Testing Resources / Testing Instruments
Source: https://developer.paytm.com/docs/testing-integration
- Testing Debit/Credit Card
| Card Number | Any Visa or Master Card |
| Expiration Month & Year | Any Future month and Year |
| CVV | 123 |
| OTP | 123123 |
- Testing Paytm Wallet Details
| Mobile Number | 77777 77777 |
| Password | Paytm12345 |
| OTPDoesn’t require 2nd factor authentication | 489871 |
- Testing Netbanking Details
| Bank Name | Andhra Bank |
| User ID | test |
| Password | Test |
Note:
In case you are testing on production environment, use live paymode details to complete the transaction. Once the transaction is successful, you can initiate refund from the dashboard.
What are Customer Relationship Management (CRM) Software?
What Is CRM?
CRM, also known as Customer Relationship Management can be understand as the software which was developed to improve the customer services and to make the customer services much more efficient.
CRM Software act as the single tools which has the ability to bring your sales, marketing, customer support services at one place and helps you to manage them at one single platform.
Who uses a CRM system?
CRM System can be easily customized and changed by the different Organisations and companies according to their needs and requirements. The CRM software can be used by the any business types and size for increasing their sales, marketing, and customer support services i.e, Small Scale Startups, Large Organizations, Real-estate, Healthcare, Insurance and the list goes on and on….
Customer relationship management systems can be easily customized to meet the specific needs of any business type and size. Start-ups, large enterprises, and verticals like real-estate, healthcare, insurance, legal, media, restaurants, travel, banking, tax, freelancers, and non-profits all use a customer relationship management software for increasing their sales, marketing, and customer support efforts.
With CRM you get,
300%
Improvement in
lead conversion rates.
41%
Revenue increase
per sales person.
27%
Improvement in
customer retention.
24%
Decreased
sales cycles
23%
Decreased sales and
marketing costs.
Here is a list of some famous CRM Software
Salesforce helps you to connect to your customer in a whole new way to build more meaningful and lasting relationship. With a single view of every customer interaction you can sell, service and market. With the help of salesforce you will get more lead, close more deals much faster, Increase customer loyalty, retention and satisfaction. You can also manage your business anytime and anywhere.
Full feature package: Salesforce Lightning Professional
Cost when billed annually: $75 per user, per month
Cost when billed monthly: n/a
Pipedrive focuses your mind on the pipeline and shuffles deals with due activities to the top in the list. In pipedrive your emails, calls, progress are tracked automatically. Pipedrive is rated the easiest sales tool to implement by leading software site. Pipedrive supports visual indicators which shows you where to focus and what actions are needed to close more sales.
Full feature package: Pipedrive Platinum
Cost when billed annually: $62.50 per user, per month
Cost when billed monthly: $75 per user, per month
In Microsoft dynamics you can engage with customers on any channel or device. You can personalise your services and deliver them fast. You can innovate with an application that is easy to tailor, extend and connect to other applications also which are already in use.
Full feature package: Dynamics 365 Plan
Cost: Starting at $210 per user, per month
Hubspot is a developer and marketer of the software products, it was founded 2006. Hubspot provide tools for social media marketing, content management, web analytics, landing page and search engine optimization. CRM has Integration Features of salesforce.com, sugarCRM, Netsuite, Microsoft Dynamics CRM and more.
Full feature package: HubSpot CRM is not a “full feature” CRM, and lacks reporting and certain sales process capabilities out of the box.
Cost: Free. Reporting can be added for $200/month
Zoho uses a open application programming interface for its writer, sheet, show, creator, meeting and product planner.it also has plugins into Microsoft excel and word, and plugins for Firefox. Zoho CRM has the some features like procurement, inventory, and some accounting functions from the realm of ERP. The free version is limited to 10 users only.
Full feature package: Zoho Enterprise
Cost when billed annually: $35 per user, per month
Cost when billed monthly: $45 per user, per month
amoCRM is very easy to use and also very powerful CRM Solution for the Organisations.it was founded in 2004 .The amoCRM is first CRM company to introduced integration with messaging application.It has easy to use pipeline management of data and information.it also gives a feature of sale automation to its users.
Full feature package: amoCRM Enterprise
Cost: $45 per user, per month, with a six-month minimum commitment
Nutshell is powerful and flexible enough to fit every to fit every sales model. Nutshell software helps in sales automation, We can manage our contacts and emails. We get the feature of reporting and performance tracking. It also offer pipeline management and friendly customer care.
Full feature package: Nutshell Pro
Cost when billed annually: $35 per user, per month
Cost when billed monthly: $39 per user, per month
Insightly CRM is for lifelong customer relationship, It can help you to grow your revenues more than 20% annually. Close more deal faster with work automation. In insightly, We can automatically convert closed deals to projects. It also provide apps integration to stay connected to apps you already use.
Full feature package: Insightly Professional
Cost when billed annually: $49 per user, per month
Cost when billed monthly: $59 per user, per month
Oracle is a complete, Integrated, Extensible application suite for modern customer experience. Oracle helps in analyze marketing performance, attribute revenue, and gain better insight into the customer experiences. We can deploy and use the CRM system easily, optimize sales performance and simplify everything in one place.
Full feature package: Oracle Sales Cloud Standard Edition
Cost: Starting at $100 per user, per month
SAP customer data cloud helps to create seamless customer experience and it also provide the data privacy, customer transparency and control. It provide personalise customer experience across the business. It helps in saving time and guesswork to accelerate sales and manage the sales territories and incentives.
Full feature package: SAP Business By Design CRM Sales
Cost when billed annually: $89 per user, per month
Cost when billed monthly: n/a
Copper is the Best CRM for G Suite users. Copper integrates with G Suite, gets rid of manual data entry, and It is super easy to use. If you can use Gmail, you’ll know how to use Copper. They have over 12,000 customers love using Copper and selling more with the CRM teams.
Full feature package: Copper Professional
Cost when billed annually: $49 per user, per month
Cost when billed monthly: $69 per user, per month
How to customize Magento 2 Maintenance mode page?
Edit the file pub/errors/default/503.phtml and put the following code
<?php
/**
* How to edit and customize code of Magento 2 Maintenance 503 Page
* Add analytics if any
* Replace <COMPANY NAME> with your Organization Name
*/
?>
<!doctype html>
<title>Site Maintenance</title>
<style>
body { text-align: center; padding: 150px; }
h1 { font-size: 50px; }
body { font: 20px Helvetica, sans-serif; color: #333; }
article { display: block; text-align: left; width: 650px; margin: 0 auto; }
a { color: #dc8100; text-decoration: none; }
a:hover { color: #333; text-decoration: none; }
</style>
<article>
<h1>We’ll be back soon!</h1>
<div>
<p>Sorry for the inconvenience but we’re performing some maintenance at the moment. If you need to you can always <a href="mailto:abcd@COMPANY NAME">contact us</a>, otherwise we’ll be back online shortly!</p>
<p>— Team COMPANY NAME</p>
</div>
</article>
SSL certification setup: Cloudflare.
This article will guide you to set your SSL certification using Cloudflare. Cloudflare is an internet security company which provides content delivery network service.
You can get free SSL certification as well as paid one from Cloudflare.
A breif discussion on SSL certification and https redirection.
So, Let’s start the process.
Steps:
Step1
Signup and Login to cloudflare. There you will get an option to add your site url. Do it and proceed.
Step2
Cloudflare will check your DNS records. You just click next and proceed.
Step3
Now choose your plan according to your needs. For this tutorial i preffered free plan. Paid plans will add some extra features and security to your site.
Step4
Now it will show you some details of your site to confirm. Just Click continue. And move on.
Step5
Cloudflare will give you two nameservers to replace with your default nameserver. Just
If everything went good so far, cloudflare will activate security on your website. Click Re-check button to refresh cloudflare and it will show the status.
We are almost done. The last thing to do is – get your API key and paste it to wordpress plugin of cloudflare, and save API credentials.
That is it. Your site is now secured with a SSL certification from cloudflare. This certification is valid for 1 year.