혹시 db쿼리랑 php 잘 하시는 분 계실까요

검색관련해서 코드를 좀 수정해야 되는데 도움이 필요해요~

견적 내주시면 작업을 맡길게요

 

 

 

현재 검색결과 화면

https://0gichul.com/?&act=IS&search_target=title_content&is_keyword=%EB%8B%88%ED%83%95%EA%B0%9C

 

요청사항

1. 구글 검색결과로 나온 파일들의 url정보로부터 해당 파일이 위치하고 있는 문서의 제목 추출

 가. 수정하고자 하는 이유

    파일을 열어봐도 문제파일 같은 경우에는 시험정보가 따로 없어서 어디에서 출제된 문제인지 알 수가 없음

 

 나. 요청사항

    검색결과 밑에 "파일 위치: 2018 국가직 9급 ooo" 라고 출력되고 클릭하면 이동

 

 

2. 파일을 클릭했을 때 연결되는 구글문서뷰어의 파일경로 변경

 가. 현재 구글문서뷰어로 보는 파일의 경로

https://docs.google.com/gview?url=https://0gichul.com/./files/attach/binaries/96910/323/109/0e8306dbec8460d71d733bc679a033b5

 

 나. 수정하고자 하는 이유

   우측상단 다운로드 버튼을 누르면 파일명과 확장자가 없는 채로 다운로드됨

 

 다. 요청사항

   다운로드 받았을 때 파일이 정상적인 “파일명.pdf” 와 같은 형태가 되도록 url을 수정

 

 라. 활용할 수 있는 정보들

   구글검색결과 화면의 파일들은 url은 file_srl이 있는 형태와 없는 형태로 나타남  

   구글 검색결과 예시

    1)

https://www.google.com/url?q=http://0gichul.com/%3Fmodule%3Dfile%26act%3DprocFileDownload%26file_srl%3D109282%26sid%3D01df95f941bade28f15bc986afb09025%26module_srl%3D96910&sa=U&ved=0ahUKEwiBvsqb7o7fAhUG8rwKHSRICGEQFggPMAU&client=internal-uds-cse&cx=partner-pub-6044976500498797:8035249101&usg=AOvVaw3GN1tDcxBoGS4Cknwd-EYw

    2)

https://www.google.com/url?q=https://0gichul.com/files/attach/binaries/92873/007/093/305c74111edc3597260485236b952394&sa=U&ved=0ahUKEwiBvsqb7o7fAhUG8rwKHSRICGEQFggMMAQ&client=internal-uds-cse&cx=partner-pub-6044976500498797:8035249101&usg=AOvVaw0r2n0fac0u1vZRXdEDTgg4

 

 

   기존의 작업으로 구글문서뷰어로 연결되도록 url이 변경됨
   1) file_srl이 있는 것 -> https://0gichul.com/_api/google.php?file_srl=109324
      클릭해서 들어가면 다음과 같이 주소 변환
https://docs.google.com/gview?url=https://0gichul.com/./files/attach/binaries/96910/323/109/0e8306dbec8460d71d733bc679a033b5
   2) file_srl이 없는 것
https://docs.google.com/gview?url=https://0gichul.com/files/attach/binaries/96910/323/109/794e5c4d6777701c4375a6f79ccb1f9b

    

   url 변경 코드 위치
   /www/modules/isx/skins/default/file.html
   /www/_api/google.php
 

능력자님 계시면 쪽지나 댓글 주세요~