Last active
May 7, 2024 12:49
-
-
Save reinvented/22d173c7f0a607a7069ad7324b125f57 to your computer and use it in GitHub Desktop.
Automating the use of Canada Revenue's Payroll Deductions Online Calculator in PHP
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| // This is a hack, designed for my specific set of circumstances (weekly salaried employees on PEI) | |
| // So if you use it as the basis for your own calculations, you'll likely have to do some customizing. | |
| $options = getopt("d:i:v:"); | |
| $param = array(); | |
| if (array_key_exists('d', $options)) { | |
| list($param['year'], $param['month'], $param['day']) = explode("-", $options['d']); | |
| $param['month'] = str_pad($param['month'], 2, '0', STR_PAD_LEFT); | |
| $param['day'] = str_pad($param['day'], 2, '0', STR_PAD_LEFT); | |
| } | |
| if (array_key_exists('i', $options)) { | |
| $param['income'] = $options['i']; | |
| } | |
| if (array_key_exists('v', $options)) { | |
| $param['vacationPay'] = $options['v']; | |
| } | |
| $requiredParams = array('year' => '', 'month' => '', 'day' => '', 'income' => '', 'vacationPay' => ''); | |
| $missingParams = array_diff_key($requiredParams, $param); | |
| if (count($missingParams)) { | |
| die("Usage: get-pdoc.php -i [income] -v [vacation pay] -d [date]\n\n"); | |
| } | |
| $data = array( | |
| "step0" => array( | |
| "calculationType" => "salary", // Salary | |
| "goStep1" => "Next" | |
| ), | |
| "step1" => array( | |
| "employeeName" => "The Employee", | |
| "employerName" => "The Employer", | |
| "province" => "2", // Prince Edward Island | |
| "payPeriod" => "1", // Weekly | |
| "cmbFirstYear" => $param['year'], | |
| "cmbFirstMonth" => $param['month'], | |
| "cmbFirstDay" => $param['day'], | |
| "goStep2AddOption" => "Next" | |
| ), | |
| "step2" => array( | |
| "incomeTypeAmount" => $param['income'], | |
| "vacationPay" => $param['vacationPay'], | |
| "salaryType" => "na", | |
| "clergyType" => "hna", | |
| "goStep2Option" => "Next" | |
| ), | |
| "step3" => array( | |
| "claimCodeFed" => "1", | |
| "requestAdditionalTax" => "0.00", | |
| "claimCodeProv" => "1", | |
| "yearToDateCPP" => "0", | |
| "yearToDatePeAmount" => "0", | |
| "yearToDateCPPAmount" => "0", | |
| "yearToDateEI" => "0", | |
| "yearToDateIeAmount" => "0", | |
| "yearToDateEIAmount" => "0", | |
| "reducedEIRate" => "0", | |
| "goResults" => "Calculate" | |
| ), | |
| ); | |
| $triggers = array( | |
| "federalTax" => array("Federal tax deduction", 2), | |
| "provincialTax" => array("Provincial tax deduction", 4), | |
| "CPP" => array("CPP deductions", 5), | |
| "EI" => array("EI deductions", 3), | |
| ); | |
| $result = fetch("https://apps.cra-arc.gc.ca/ebci/rhpd/startLanguage.do?lang=English", array('post' => false)); | |
| $result = fetch("https://apps.cra-arc.gc.ca/ebci/rhpd/handleEntryPoint.do", array('refer' => 'https://apps.cra-arc.gc.ca/ebci/rhpd/startLanguage.do?lang=English', 'post' => http_build_query($data['step0'], '', '&'))); | |
| $result = fetch("https://apps.cra-arc.gc.ca/ebci/rhpd/handleGeneralInfo.do", array('refer' => 'https://apps.cra-arc.gc.ca/ebci/rhpd/handleEntryPoint.do', 'post' => http_build_query($data['step1'], '', '&'))); | |
| $result = fetch("https://apps.cra-arc.gc.ca/ebci/rhpd/handleAdditionalOptions.do", array('refer' => 'https://apps.cra-arc.gc.ca/ebci/rhpd/handleGeneralInfo.do', 'post' => http_build_query($data['step2'], '', '&'))); | |
| $result = fetch("https://apps.cra-arc.gc.ca/ebci/rhpd/s-handleInterview.do", array('refer' => 'https://apps.cra-arc.gc.ca/ebci/rhpd/handleAdditionalOptions.do', 'post' => http_build_query($data['step3'], '', '&'))); | |
| $lines = explode("\n", $result); | |
| foreach ($lines as $linenumber => $line) { | |
| foreach ($triggers as $key => $trigger) { | |
| if (strpos($line, $trigger[0]) !== FALSE) { | |
| $values[$key] = trim($lines[$linenumber + $trigger[1]]); | |
| } | |
| } | |
| } | |
| print_r($values); | |
| function fetch( $url, $z=null ) { | |
| $ch = curl_init(); | |
| $useragent = 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2'; | |
| curl_setopt( $ch, CURLOPT_URL, $url ); | |
| curl_setopt( $ch, CURLOPT_RETURNTRANSFER, true ); | |
| curl_setopt( $ch, CURLOPT_AUTOREFERER, true ); | |
| curl_setopt( $ch, CURLOPT_FOLLOWLOCATION, true ); | |
| curl_setopt( $ch, CURLOPT_POST, isset($z['post']) ); | |
| if( isset($z['post']) ) curl_setopt( $ch, CURLOPT_POSTFIELDS, $z['post'] ); | |
| if( isset($z['refer']) ) curl_setopt( $ch, CURLOPT_REFERER, $z['refer'] ); | |
| curl_setopt( $ch, CURLOPT_USERAGENT, $useragent ); | |
| curl_setopt( $ch, CURLOPT_CONNECTTIMEOUT, 5 ); | |
| curl_setopt( $ch, CURLOPT_COOKIEJAR, '/tmp/cra-cookies.txt' ); | |
| curl_setopt( $ch, CURLOPT_COOKIEFILE, '/tmp/cra-cookies.txt' ); | |
| $result = curl_exec( $ch ); | |
| curl_close( $ch ); | |
| return $result; | |
| } |
Does anyone know of other api for Canadian payroll?
Does anyone know of other api for Canadian payroll?
I'm also looking as well!
Me too, looking for an API.
I'm planning to build a micro saas that provides API that calculates the Canada payroll deduction using the T4127 formula.
Is this something that anyone would pay for?
I would certainly look at that!
Michael (Mike) Coffill
Founder | Wages Corp.
Book a Demo Call Here: https://calendly.com/michaelc-wagescorp
Tel: 1-866-311-4441 ext.401
Email: ***@***.******@***.***>
Office Hours:
Monday through Friday 8am-4pm Excluding Holidays
***@***.***
From: Vince Elizaga ***@***.***>
Sent: Thursday, February 8, 2024 12:07 PM
To: vynci ***@***.***>
Cc: Comment ***@***.***>
Subject: Re: reinvented/pdoc.php
@vynci commented on this gist.
…________________________________
I'm planning to build a micro sass that provides API that calculates the Canada payroll deduction using the T4127 formula.
Is this something that anyone would pay for?
—
Reply to this email directly, view it on GitHub<https://gist.github.com/reinvented/22d173c7f0a607a7069ad7324b125f57#gistcomment-4884162> or unsubscribe<https://github.com/notifications/unsubscribe-auth/ASQU6GPZYU2VNIUGGM6XJJ3YSUA3XBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA2DINBXGAYTOMFHORZGSZ3HMVZKMY3SMVQXIZI>.
You are receiving this email because you commented on the thread.
Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
Nice to hear from you @Meekcanadian, I've worked on a project recently that needed to calculate payroll deductions, it wasn't an easy problem to solve as I didn't find any existing API services for it. Every province has its specific formulas and constants, and on top of that, things could change twice a year, so the code needs to be changed as well.
I think creating a micro saas for this would be a good idea.
Yes, and Quebec is another Pandora's box.
The QC government requires software companies to reveal their code to work with Quebec payroll.
Wages Corp (my company) would be very interested in this.
Michael (Mike) Coffill
Founder | Wages Corp.
Book a Demo Call Here: https://calendly.com/michaelc-wagescorp
Tel: 1-866-311-4441 ext.401
Email: ***@***.******@***.***>
Office Hours:
Monday through Friday 8am-4pm Excluding Holidays
***@***.***
From: Vince Elizaga ***@***.***>
Sent: Thursday, February 8, 2024 12:18 PM
To: vynci ***@***.***>
Cc: Mention ***@***.***>
Subject: Re: reinvented/pdoc.php
@vynci commented on this gist.
…________________________________
Nice to hear from you @Meekcanadian<https://github.com/Meekcanadian>, I've worked on a project recently that needed to calculate payroll deductions, it wasn't an easy problem to solve as I didn't find any existing API services for it. Every province has its specific formulas and constants, and on top of that, things could change twice a year, so the code needs to be changed as well.
I think creating a micro saas for this would be a good idea.
—
Reply to this email directly, view it on GitHub<https://gist.github.com/reinvented/22d173c7f0a607a7069ad7324b125f57#gistcomment-4884183> or unsubscribe<https://github.com/notifications/unsubscribe-auth/ASQU6GINMQDVHJZN6UFFGTDYSUCFLBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA2DINBXGAYTOMFHORZGSZ3HMVZKMY3SMVQXIZI>.
You are receiving this email because you were mentioned.
Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
Awesome, I will keep you posted @Meekcanadian. Thanks!
Thank you.
Michael (Mike) Coffill
Founder | Wages Corp.
Book a Demo Call Here: https://calendly.com/michaelc-wagescorp
Tel: 1-866-311-4441 ext.401
Email: ***@***.******@***.***>
Office Hours:
Monday through Friday 8am-4pm Excluding Holidays
***@***.***
From: Vince Elizaga ***@***.***>
Sent: Thursday, February 8, 2024 12:30 PM
To: vynci ***@***.***>
Cc: Mention ***@***.***>
Subject: Re: reinvented/pdoc.php
@vynci commented on this gist.
…________________________________
Awesome, I will keep you posted @Meekcanadian<https://github.com/Meekcanadian>. Thanks!
—
Reply to this email directly, view it on GitHub<https://gist.github.com/reinvented/22d173c7f0a607a7069ad7324b125f57#gistcomment-4884192> or unsubscribe<https://github.com/notifications/unsubscribe-auth/ASQU6GKCNIFDCZCQQXUDWQ3YSUDQJBFKMF2HI4TJMJ2XIZLTSKBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDHNFZXJJDOMFWWLK3UNBZGKYLEL52HS4DFVRZXKYTKMVRXIX3UPFYGLK2HNFZXIQ3PNVWWK3TUUZ2G64DJMNZZDAVEOR4XAZNEM5UXG5FFOZQWY5LFVA2DINBXGAYTOMFHORZGSZ3HMVZKMY3SMVQXIZI>.
You are receiving this email because you were mentioned.
Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I think it doesn't work anymore, great stuff by the way. I think that it now uses session cookies, because if your token doesn't match, it gives an error.