php-general Digest 31 Aug 2012 04:12:24 -0000 Issue 7944 Topics (messages 318928 through 318932):
Re: PHP to XLS Security Alert issue 318928 by: Maciek Sokolewicz How to use wsdl files? 318929 by: Michelle Konzack 318930 by: Matijn Woudt 318931 by: Matijn Woudt 318932 by: Michelle Konzack Administrivia: To subscribe to the digest, e-mail: php-general-digest-subscr...@lists.php.net To unsubscribe from the digest, e-mail: php-general-digest-unsubscr...@lists.php.net To post to the list, e-mail: php-gene...@lists.php.net ----------------------------------------------------------------------
--- Begin Message ---On 29-08-2012 19:28, admin wrote:-----Original Message----- From: Matijn Woudt [mailto:tijn...@gmail.com] Sent: Tuesday, August 28, 2012 3:55 PM To: admin Cc: php-gene...@lists.php.net Subject: Re: [PHP] PHP to XLS Security Alert issueI believe that's normal, and that it does that with any document downloaded from the web. I'm not sure if there's a workaround, but you should not ask that here but on a Microsoft Office forum/list, or just ask the question to Microsoft themselves. - Matijn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpMatijn, I understand YOU believe this is normal. I am sorry you feel that way because the construction of the document is exactly where the problem was resolved, and that is in PHP. So asking in the PHP-List was the exact the place to post a question of document construction using PHP. Yes understanding the document verification methods of Microsoft helps but it is up to the DEVELOPER to put the correct headers and content strings to make the document valid and that is what I was asked. Q: I am exporting to a XLS file and the file does export, but when I open the file Microsoft is giving a Excel Security Notice. I am sure there is something in the header that is missing or causing this problem?Regardless of the fact if it was produced using PHP, ASP, C or using a plain text editor, the point is still that there is apparently a "problem" with the file itself. The easiest solution would still be to ask, as Matijn suggested, the people from Microsoft Office. Since they are the developers/users of the software, they will know what causes that problem, and will be able to better help you than asking on this list where people are less likely to know exactly what the cause is of that warning.As a metaphor: If I build a building out of steel, and all buildings in the area start to collapse because the ground sags, I wouldn't ask a steel-merchant for help, but rather someone who knows a lot about sagging ground.And no, I don't know what exactly causes that warning: ask people who have a more intimate knowledge of Excel.- Tul
--- End Message ---
--- Begin Message ---Hello Experts, I am coding an Online Shop and need to include a VAT validation for the Europe Community. The Form can be found here: <http://ec.europa.eu/taxation_customs/vies/vatRequest.html> However, there is a SOAP API: <http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl> but I do not understand, how I have to use it. I need it very simple and a response of "TRUE" or "FALSE" plus maybe an ERROR CODE is enough. I would prefer to use a simple URL call and take the reponse to validate a business customer. An help welcome. Thanks, Greetings and nice Day/Evening Michelle Konzack -- ##################### Debian GNU/Linux Consultant ###################### Development of Intranet and Embedded Systems with Debian GNU/Linux Internet Service Provider, Cloud Computing <http://www.itsystems.tamay-dogan.net/> itsystems@tdnet Jabber linux4miche...@jabber.ccc.de Owner Michelle Konzack Gewerbe Strasse 3 Tel office: +49-176-86004575 77694 Kehl Tel mobil: +49-177-9351947 Germany Tel mobil: +33-6-61925193 (France) USt-ID: DE 278 049 239 Linux-User #280138 with the Linux Counter, http://counter.li.org/signature.pgp
Description: Digital signature
--- End Message ---
--- Begin Message ---On Thu, Aug 30, 2012 at 2:57 PM, Michelle Konzack <linux4miche...@tamay-dogan.net> wrote: > Hello Experts, > > I am coding an Online Shop and need to include a VAT validation for the > Europe Community. The Form can be found here: > > <http://ec.europa.eu/taxation_customs/vies/vatRequest.html> > > However, there is a SOAP API: > > <http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl> > > but I do not understand, how I have to use it. I need it very simple and > a response of "TRUE" or "FALSE" plus maybe an ERROR CODE is enough. I > would prefer to use a simple URL call and take the reponse to validate a > business customer. > > An help welcome. > > Thanks, Greetings and nice Day/Evening > Michelle Konzack > Hi Michelle, You could start by looking at the PHP SoapClient [1], which takes a URI to a WSDL descriptor as argument. You can enter the URL to the WSDL file there, like this: $client = new SoapClient("http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl"); Now you need to know which function you want to call, let's say it's called SomeFunction, then you can do: $client->SomeFunction($paramA, $paramB); Hope this gets you started. - Matijn
--- End Message ---
--- Begin Message ---On Thu, Aug 30, 2012 at 4:44 PM, Matijn Woudt <tijn...@gmail.com> wrote: > On Thu, Aug 30, 2012 at 2:57 PM, Michelle Konzack > <linux4miche...@tamay-dogan.net> wrote: >> Hello Experts, >> >> I am coding an Online Shop and need to include a VAT validation for the >> Europe Community. The Form can be found here: >> >> <http://ec.europa.eu/taxation_customs/vies/vatRequest.html> >> >> However, there is a SOAP API: >> >> <http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl> >> >> but I do not understand, how I have to use it. I need it very simple and >> a response of "TRUE" or "FALSE" plus maybe an ERROR CODE is enough. I >> would prefer to use a simple URL call and take the reponse to validate a >> business customer. >> >> An help welcome. >> >> Thanks, Greetings and nice Day/Evening >> Michelle Konzack >> > > Hi Michelle, > > You could start by looking at the PHP SoapClient [1], which takes a > URI to a WSDL descriptor as argument. You can enter the URL to the > WSDL file there, like this: > $client = new > SoapClient("http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl"); > > Now you need to know which function you want to call, let's say it's > called SomeFunction, then you can do: > $client->SomeFunction($paramA, $paramB); > > Hope this gets you started. > > - Matijn And the URL I was referring to: [1] http://nl.php.net/manual/en/soapclient.soapclient.php
--- End Message ---
--- Begin Message ---Hello Matijn Woudt, Am 2012-08-30 16:44:53, hacktest Du folgendes herunter: > You could start by looking at the PHP SoapClient [1], which takes a > URI to a WSDL descriptor as argument. You can enter the URL to the > WSDL file there, like this: > $client = new > SoapClient("http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl"); > > Now you need to know which function you want to call, let's say it's > called SomeFunction, then you can do: > $client->SomeFunction($paramA, $paramB); > > Hope this gets you started. Ah thanks... Interesting how it works. However, I have found "wsdl2php" and converted the wsdl file to a PHP class, but I hate classes... Never used it in 12 years. :-D --8<-------------------------------------------------------------------- <?php class checkVat{ var $countryCode; //string var $vatNumber; //string } class checkVatResponse{ var $countryCode; //string var $vatNumber; //string var $requestDate; //date var $valid; //boolean var $name; //string var $address; //string } class checkVatApprox{ var $countryCode; //string var $vatNumber; //string var $traderName; //string var $traderCompanyType; //companyTypeCode var $traderStreet; //string var $traderPostcode; //string var $traderCity; //string var $requesterCountryCode; //string var $requesterVatNumber; //string } class checkVatApproxResponse{ var $countryCode; //string var $vatNumber; //string var $requestDate; //date var $valid; //boolean var $traderName; //string var $traderCompanyType; //companyTypeCode var $traderAddress; //string var $traderStreet; //string var $traderPostcode; //string var $traderCity; //string var $traderNameMatch; //matchCode var $traderCompanyTypeMatch; //matchCode var $traderStreetMatch; //matchCode var $traderPostcodeMatch; //matchCode var $traderCityMatch; //matchCode var $requestIdentifier; //string } class checkVatService{ var $soapClient; private static $classmap = array('checkVat' => 'checkVat' ,'checkVatResponse' => 'checkVatResponse' ,'checkVatApprox' => 'checkVatApprox' ,'checkVatApproxResponse' => 'checkVatApproxResponse'); function __construct($url='http://ec.europa.eu/taxation_customs/vies/checkVatService.wsdl') { $this->soapClient = new SoapClient($url,array("classmap" => self::$classmap, "trace" => true, "exceptions" => true)); } function checkVat(checkVat $checkVat) { $checkVatResponse = $this->soapClient->checkVat($checkVat); return $checkVatResponse; } function checkVatApprox(checkVatApprox $checkVatApprox) { $checkVatApproxResponse = $this->soapClient->checkVatApprox($checkVatApprox); return $checkVatApproxResponse; } } ?> --8<-------------------------------------------------------------------- OK, tried $VALS = new checkVat; $VALS->countryCode = 'DE'; $VALS->vatNumber = '278049239'; $OBJECT = new checkVatService; $OBJECT->checkVat; and up the here I have no error. But How do I get the answer now? $ANS = $OBJECT->checkVat; or $ANS = $OBJECT->checkVat(); do not seem to work print_r($ANS); Also $RET = new checkVatResponse; print_r($RET); seems not to work What I am missing? Thanks, Greetings and nice Day/Evening Michelle Konzack -- ##################### Debian GNU/Linux Consultant ###################### Development of Intranet and Embedded Systems with Debian GNU/Linux Internet Service Provider, Cloud Computing <http://www.itsystems.tamay-dogan.net/> itsystems@tdnet Jabber linux4miche...@jabber.ccc.de Owner Michelle Konzack Gewerbe Strasse 3 Tel office: +49-176-86004575 77694 Kehl Tel mobil: +49-177-9351947 Germany Tel mobil: +33-6-61925193 (France) USt-ID: DE 278 049 239 Linux-User #280138 with the Linux Counter, http://counter.li.org/ --8<-------------------------------------------------------------------- Thanks, Greetings and nice Day/Evening Michelle Konzack -- ##################### Debian GNU/Linux Consultant ###################### Development of Intranet and Embedded Systems with Debian GNU/Linux Internet Service Provider, Cloud Computing <http://www.itsystems.tamay-dogan.net/> itsystems@tdnet Jabber linux4miche...@jabber.ccc.de Owner Michelle Konzack Gewerbe Strasse 3 Tel office: +49-176-86004575 77694 Kehl Tel mobil: +49-177-9351947 Germany Tel mobil: +33-6-61925193 (France) USt-ID: DE 278 049 239 Linux-User #280138 with the Linux Counter, http://counter.li.org/signature.pgp
Description: Digital signature
--- End Message ---