has a demand. We need to search for the corresponding transportation company according to origin and destination . origin and destination need to select provinces, cities, regions (counties). If there is no corresponding transportation company in the specified area, give the transportation company at the next level.
for example:
search transportation companies from Baiyun District, Guangzhou City, Guangdong Province to Xihu District, Hangzhou City, Zhejiang Province ,
if there is no match above, search for transportation companies from Baiyun District, Guangzhou City, Guangdong Province to Hangzhou City, Zhejiang Province ;
if there is no match, search Guangzhou City, Guangdong Province to Hangzhou City, Zhejiang Province transportation companies;
if there is no match above, search for Guangzhou City, Guangdong Province to Zhejiang Province transportation companies;
if there is no match above, search Guangdong Province to Zhejiang Province transportation companies;
the current idea is to put the data in a table, search according to the six conditions of the provinces, cities, autonomous regions (counties) of origin and destination , and then make several judgments until the search results are found.
is looking for a better solution, asking the bosses for advice. In terms of table building and code, mysql and php are used.